Enable Technology



About Enable Technology North East Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. 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.

Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a Access course at an alternative training site in North East. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Homeserve PLC, Norwich Union PLC, West Bromwich Building Society, Shell UK Oil Products Ltd, Fujistu PLC, Wolverhampton City Council, Carillion PLC and Countrywide Homes Limited.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: North East
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Working with Variable Lifetime
    Understanding Constants
    Understanding the DoCmd Object
    Using the Object Browser
    Locking Records for Updating
    Using the If...End If Decision Structures
    Understanding Recordset Cursor Properties - Optional
    Why Program in Access?
    Understanding Classes and Objects
    Working with Inline Error Handling
    Creating a Function Procedure
    Using Debugging Tools
    Using Break Mode during Run Mode
    Specifying a Recordset Cursor Location - Optional
    Working with Methods
    Determining the Value of Expressions
    Working with the ADODB Recordset Object
    Stepping through Code
    Understanding Error Handling
    Naming Procedures

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: North East
  • 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 ...
  • Creating Queries
    Macros on Forms
    Querying Techniques
    Aggregation Queries
    Sorting and Filtering
    Creating and Using Reports
    Designing a Lookup Database
    Creating a Relational Database
    Creating and Using Macros
    Using a Navigation Form
    Database Security
    Understanding VBA
    Parameter Queries
    Getting to Know Access 
    An Introduction to VBA
    Multi Table Queries
    Navigation Pane Protection
    Formatting Tables
    Creating a Lookup Database
    Importing and Exporting Records
    Working With Records

  • See Training Course Details...

Email us about this courses

Other North East Enable Technology Training Courses

Excel 365 Intermediate - North East Excel Training Courses
Excel 365 Basic North East Training Courses
JQuery - North East JavaScript Training Courses
PL/SQL North East Training Courses
TSQL - North East SQL Training Courses
JavaScript - North East JavaScript Training Courses