Access: VBA Programming Training (ACC301)

This VBA Programming for Access training course is designed for experienced Access users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.

Our public classes use the most current version of the software, but if you’re on an earlier version, our instructor will point out any differences. For private classes, we will use the version of the software you use in your office.

1. Visual Basic Editor
   1. Visual Basic for Applications
   2. Using the Visual Basic Editor
      1. The Visual Basic Interface
      2. Working in Visual Basic Editor
      3. Using the Visual Basic Editor in Access
      4. Close Event Procedure
      5. Save and Run a Procedure
   3. Object Programming
      1. The Object Model
      2. Getting Help in the Object Browser
   4. Event Procedures and Macros
   5. Using the Object Model in Access
      1. The Access Object Model
2. Programming Basics
   1. Data Basics
   2. Scope of Variables
   3. Naming Variables
   4. Using Variables to Accept User Input
3. Control Structures
   1. Decision Structures
   2. Loop Structures
4. Custom Dialog Boxes
   1. User Forms
   2. Events
5. Debugging and Error Handling
   1. Errors
   2. Debugging
   3. Error Handling

Each student receives a comprehensive set of materials, including course notes and all class examples.

Experience in the following is required for this Microsoft Access class: