Enable Technology



About Enable Technology Worcester Access Training Courses

We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with Access training materials which they keep 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 provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. Every Access course can be modified to meet your bespoke 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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Dollond & Aitchison Limited, West Bromwich Building Society, DHL Express, Halfords Group PLC, Vodafone Group Services, Canadian High Commission, Barclays Bank PLC and Carillion PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Worcester
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Using the Immediate Window to Call Procedures
    Understanding Classes and Objects
    Using the CacheSize Property - Optional
    Using Visual Basic Help
    Understanding Control-of-Flow Structures
    Using the With Statement
    Working with Procedures and Functions
    Understanding Data Types
    Creating a Function Procedure
    Debugging Code
    Creating a Sub Procedure
    Guidelines for use of Branching Structures
    Understanding Expressions and Statements
    Trapping Errors with the On Error Statement
    Working with the Code Editor
    Understanding the Development Environment
    Why Program in Access?
    Handling Errors

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Worcester
  • 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 ...
  • Querying Techniques
    An Introduction to VBA
    Macro Techniques
    DIY Forms
    Action Queries
    Navigation Pane Protection
    Database Wellness
    Creating and Using Macros
    Adding Records to a Table
    Importing and Exporting Records
    Parameter Queries
    Creating a Relational Database
    Adding Transactional Records
    Relational Database Design
    Calculations in Queries
    Sorting and Filtering
    Database Security
    Using a Navigation Form
    Multi Table Queries
    Macros on Forms
    Understanding VBA

  • See Training Course Details...

Email us about this courses

Other Worcester Enable Technology Training Courses

SSAS Tabular - Worcester SQL Server Analysis Services Training Courses
TSQL Worcester Training Courses
Excel Power Pivot Worcester Training Courses
PL/SQL Worcester Training Courses
Excel 365 Intermediate Worcester Training Courses
Report Builder Worcester Training Courses