Microsoft Access VBA – Programming


Course Description

VBA is the programming Interface for Access. It allows you to automate tasks and even control other applications such as PowerPoint and Word.


In order to take this course, students must possess an advanced level of Access skills, and knowledge. Also, the student must have a fair amount of practical experience with the program.

Understanding the Access Object Hierarchy
Understanding Access Objects
Using the Object Browser
Controlling the Application Object
Understanding the Forms Collection and Form Object
Understanding the Controls Collection and Control Object
Using the With Statement
Understanding the Reports Collection and Report Object
Understanding the DoCmd Object
Using the Screen Object

Using Variables Arrays and Constants
Declaring Variables
Declaring Arrays
Declaring Constants
Declaring Object Variables

Using Functions Message Boxes and Input Boxes
Using Intrinsic Functions
Using Message Boxes
Using Input Boxes

Controlling Program Execution
Using Control Structures
Working with Conditional Expressions
Using the IfThenEnd If Structure
Using the IfThenElseEnd If Structure
Using the Select CaseEnd Select Structure
Using the DoLoop Structure
Using the ForNext Stucture

Debugging Code
Understanding Errors
Using Debugging Tools
Stepping Through Code and Setting Break Points
Understanding Error Events
Understanding the Err Object
Using the On Error Statement
Writing an Error Handling Routine
Compiling All Procedures