Microsoft Access VBA - Programming

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 For Next Structure

Debugging Code

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

Students will learn how to:

• Understand the Access Object Hierarchy
• Use Variables Arrays and Constants
• Use Functions Message Boxes and Input Boxes
• Control Program Execution
• Debug Code

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.

Students who have an advanced familiarity with Microsoft Access but have never done any VBA programming should attend.