Microsoft Access VBA Training

This course is designed for students who want to go beyond macros in Microsoft Access to automate actions in their database.

Upon successful completion of this course, students will be able to:

• Create Sub Procedures and Functions
• Attach code to user-initiated or application-initiated events
• Control program flow by using If/Then and Looping structures
• Access and modify data in the database directly using code
• Debug code to find and fix programming errors
• Implement error-handling code to catch and resolve run-time errors

1. Getting Started with VBA
   • Introduction to Programming with VBA in Access
   • Why Use VBA in Access?
   • Understanding the Development Environment
   • Using Visual Basic Help
2. Understanding Procedures and Functions
   • What is a Module
   • Using Standard Modules
   • What is a Procedure
   • Using Sub Procedures
   • How to Call Procedures
   • Using the Immediate Window
   • What is a Function Procedure
   • Naming Guidelines for Procedures
   • Organizing Your Code
   • Using the Code Editor
3. Defining Objects in VBA
   • Understanding Classes and Objects
   • Understanding the Access Object Hierarchy
   • Using Collections
   • Using the Object Browser
   • Using the Application Object
   • Using the Form Object
   • Working with Object Properties
   • Using the With Statement
   • Working with Object Methods
   • Using the DoCmd Object
   • Working with Object Events
   • Understanding the Order of Events
4. Using Expressions, Variables, and Built-In Functions
   • Using Expressions and Statements
   • How to Declare Variables
   • Understanding Available Data Types
   • Understanding Variable Scope
   • Understanding Variable Lifetime
   • Variable Visibility in Code
   • Using Built-In Functions
   • What is a Constant
   • Using Intrinsic Constants
   • Using Message Boxes for User Input
   • Using Input Boxes for User Input
5. Controlling Program Execution
   • Using Control-of-Flow Structures
   • Understanding Boolean Expressions
   • Using If...End If
   • Using Select Case...End Select
   • Using For...Next
   • Using For Each...Next
   • Using Do...Loop
   • Guidelines for use of Branching Structures
6. Working with Recordsets in VBA
   • Declaring and Creating DAO Variables
   • Working with the DAO Recordset Object
7. How to Debug VBA Code
   • Identifying VBA Error Types
   • Using VBA Debugging Tools
   • How to Set a Breakpoint
   • Using Break Expressions
   • Using Break Mode
   • How to Step Through Code
   • Watch the Value of Expressions
8. How to Handle Errors in VBA Code
   • Understanding Error Handling
   • Understanding Error Trapping Options in VBA
   • Using the On Error Statement
   • Using the Err Object
   • Writing an Error-Handling Routine
   • Using Inline Error Handling

Students should have basic experience in creating and using tables, forms, reports and queries in Microsoft Access. No programming experience is necessary.