Access VBA Training Course

Last updated

Course Code



21 hours (usually 3 days including breaks)

Course Outline

Introduction to VBA

  • Storing information
  • Data types
  • Variables
  • Terminology, characteristics, scope, visibility of variables
  • Control structures  if, select case, do, for
  • Loops
  • Built-in functions
  • Types, finding and removing errors
  • Comments


  • Definition
  • Properties
  • Methods
  • Collections of objects
  • Viewing
  • Tables, queries, indexes
  • Object-oriented data access
  • Custom Class
  • Object Error Handling


  • Constructing queries with VBA
  • Use of SQL syntax
  • Transactions
  • DAO and ADO
  • Records
  • Importing data from other systems


  • Plan
  • Interface
  • Menus
  • Reports
  • Controls available from code
  • Forms
  • Integration and support for other applications
  • Library functions

Best Practices

  • Tips and trics



Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

This site in other countries/regions