Enable Technology

ACCESS CARLISLE TRAINING COURSES 

ACCESS TRAINING COURSES CARLISLE




About Enable Technology Carlisle Access Training Courses

We are a company that provides short intensive Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

We provide instructor led training coupled with hands on training. We are set up to deliver Access training courses onsite at your premises. Another way we could deliver the Access course is at a local training site. We are happy to modify the Access syllabus to match your teams training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Total Telecommunications Limited, Birmingham Heartlands Hospital, Vodafone Group Services, Birmingham City University, National Power PLC, Keele University, EDF Energy PLC and Royal & Sun Alliance Group PLC.




Microsoft Access

  • 2 day course
  • Location: Carlisle
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Designing a Lookup Database
    Querying Techniques
    Calculations in Queries
    Importing and Exporting Records
    Aggregation Queries
    DIY Forms
    Creating and Using Macros
    Data Validation
    Multi Table Queries
    Modifying Table Structures
    Modifying Forms
    An Introduction to VBA
    Macro Techniques
    Adding Transactional Records
    Relational Database Design
    Database Wellness
    Database Security
    Getting to Know Access 
    Action Queries
    Macros on Forms
    Using a Navigation Form

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Carlisle
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Understanding the Form Object
    Understanding Control-of-Flow Structures
    Calling Procedures
    Using Message Boxes
    Understanding Data Types
    Working with Variable Scope
    Using the Do...Loop Structure
    Using Break Mode during Run Mode
    Understanding Errors
    Understanding Recordset Cursor Properties - Optional
    Working with the ADODB Recordset Object
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Procedures
    Using the Object Browser
    Declaring Variables
    Understanding Error Handling
    Understanding Collections
    Working with Recordsets
    Working with Boolean Expressions

  • See Training Course Details...



Email us about this courses



Other Carlisle Enable Technology Training Courses

Report Builder - Carlisle SQL Server Reporting Services Training Courses
Excel Power Pivot Carlisle Training Courses
Oracle SQL Carlisle Training Courses
JQuery - Carlisle JavaScript Training Courses
SSIS Carlisle Training Courses
JavaScript - Carlisle JavaScript Training Courses