Enable Technology



About Enable Technology Huyton Access Training Courses

Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a training location in Huyton. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Barclays Bank PLC, Lloyds TSB Bank PLC, Capita Group PLC, EDF Energy PLC, GKN PLC, Nuclear Engineering Services, Cadbury PLC and Yell Group PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Huyton
  • 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 Events
    Creating a Standard Module
    Stepping through Code
    Understanding Objects
    Understanding Classes and Objects
    Understanding Modules
    Understanding VBA's Error Trapping Options
    Using the If...End If Decision Structures
    Organizing Code and Procedures
    Understanding Error Handling
    Using Visual Basic Help
    Setting Break Expressions
    Working with Boolean Expressions
    Controlling Program Execution
    Using Expressions, Variables, and Intrinsic Functions
    Working with Inline Error Handling
    Understanding Collections
    Using the Object Browser
    Guidelines for use of Branching Structures
    Understanding Recordset Cursor Properties - Optional

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Huyton
  • 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 ...
  • An Introduction to VBA
    Macros on Forms
    Understanding VBA
    Using a Navigation Form
    DIY Forms
    Modifying Table Structures
    Macro Techniques
    Designing a Lookup Database
    Parameter Queries
    Data Validation
    Querying Techniques
    Creating and Using Forms
    Navigation Pane Protection
    Creating a Relational Database
    Creating a Lookup Database
    Database Wellness
    Creating and Using Reports
    Formatting Tables
    Aggregation Queries
    Relational Database Design
    Adding Records to a Table

  • See Training Course Details...

Email us about this courses

Other Huyton Enable Technology Training Courses

VBA - Huyton Excel Training Courses
Excel Power Pivot Huyton Training Courses
Excel 365 Intermediate - Huyton Excel Training Courses
Power BI - Huyton Microsoft Power BI Training Courses
Excel 365 Advanced - Huyton Excel Training Courses
SSRS - Huyton SQL Server Reporting Services Training Courses