Enable Technology



About Enable Technology Bridgend Access Training Courses

Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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 specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We can also deliver the Access course at a socially distanced local training venue in Bridgend. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are EDF Energy PLC, Birmingham Heartlands Hospital, Lloyds TSB Bank PLC, Vodafone Group Services, Halfords Group PLC, Norwich Union PLC, South Staffordshire Water PLC and National Power PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bridgend
  • 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 ...
  • Trapping Errors with the On Error Statement
    Understanding Errors
    Understanding the DoCmd Object
    Naming Procedures
    Debugging Code
    Using the With Statement
    Determining the Value of Expressions
    Understanding Procedures
    Using the Do...Loop Structure
    Specifying a Recordset Cursor Location - Optional
    Locking Records for Updating
    Using the Select Case...End Select Structure
    Using the CacheSize Property - Optional
    Understanding VBA's Error Trapping Options
    Using the Immediate Window to Call Procedures
    Setting Breakpoints
    Working with Properties
    Working with the Application Object

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Bridgend
  • 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 ...
  • Setting Table Relationships
    Calculations in Queries
    Multi Table Queries
    Macros on Forms
    Adding Records to a Table
    Working With Records
    Aggregation Queries
    Creating a Relational Database
    Using a Navigation Form
    Creating Queries
    Macro Techniques
    Data Validation
    Modifying Table Structures
    Navigation Pane Protection
    DIY Forms
    Designing a Lookup Database
    Creating a Lookup Database
    Formatting Tables
    An Introduction to VBA
    Creating and Using Macros
    Creating and Using Reports

  • See Training Course Details...

Email us about this courses

Other Bridgend Enable Technology Training Courses

Excel Power Pivot - Bridgend Excel Training Courses
Excel 365 Intermediate - Bridgend Excel Training Courses
PL/SQL - Bridgend SQL Training Courses
SSAS Tabular - Bridgend SQL Server Analysis Services Training Courses
VBA Bridgend Training Courses
JQuery Mobile - Bridgend JavaScript Training Courses