Microsoft Access – Level 3

Our third level in Microsoft Access training introduces the use of Visual Basic for Applications (VBA), the programming side of Microsoft Office. As this programming language is very powerful, this course only seeks to introduce the delegates to the environment and programming structure. We are able to offer tailored training further to this course if required.

Programming computers is not a skill that can be learned overnight and so delegates must be aware that the level of this course may be quite high. An in-depth knowledge of Microsoft Access is required before attempting this course. Please refer to our level 1 and 2 courses in Access or phone for a talk to one of our trainers if you are in any doubt.

The course seeks to cover the following areas of programming with Visual Basic, specifically in the Microsoft Access environment:

  • Initiate code by use of the event procedure wizards
  • Introduce modules and module types, form/class modules and stand alone modules
  • Introduction of subroutines and functions
  • To be able to dimension data types and data/record sets
  • To be able to import/export project data
  • To be able to use conditional functions and looping techniques
  • Introduction to error trapping within a program
  • To be able to debug an Access module

Product Versions Covered
All versions since Office 2000

1 Day

£300.00 + vat