Enable Technology



About Enable Technology Leamington Spa Access Training Courses

We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

We provide instructor led training coupled with hands on training. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Leamington Spa. We are happy to modify the Access syllabus to match your teams training requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Lloyds TSB Bank PLC, Carillion PLC, West Bromwich Building Society, Keele University, Boots UK Limited, Canadian High Commission, Loughborough University and Halfords Group PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Leamington Spa
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Setting Break Expressions
    Understanding Procedures
    Understanding the Order of Events
    Using the Select Case...End Select Structure
    Why Program in Access?
    Working with Recordsets
    Determining the Value of Expressions
    Controlling Program Execution
    Working with Procedures and Functions
    Working with Inline Error Handling
    Understanding the Form Object
    Creating a Standard Module
    Creating a Function Procedure
    Understanding Classes and Objects
    Stepping through Code
    Using the If...End If Decision Structures
    Guidelines for use of Branching Structures
    Using Expressions, Variables, and Intrinsic Functions
    Understanding the Development Environment

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Leamington Spa
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Understanding VBA
    Modifying Forms
    Setting Table Relationships
    Creating Queries
    Using a Navigation Form
    DIY Forms
    Action Queries
    Working With Records
    Adding Transactional Records
    Parameter Queries
    Relational Database Design
    Sorting and Filtering
    Database Security
    Designing a Lookup Database
    Creating and Using Macros
    Database Wellness
    Data Validation
    Formatting Tables
    Aggregation Queries
    Creating and Using Forms
    An Introduction to VBA

  • See Training Course Details...

Email us about this courses

Other Leamington Spa Enable Technology Training Courses

JQuery Mobile - Leamington Spa JavaScript Training Courses
PL/SQL - Leamington Spa SQL Training Courses
SSAS Tabular - Leamington Spa SQL Server Analysis Services Training Courses
Data Warehouse Leamington Spa Training Courses
SSAS Leamington Spa Training Courses
JavaScript Leamington Spa Training Courses