Microsoft Access VBA Complete

In this introductory Visual Basic for Applications (VBA) training course, you will learn how to manipulate objects in Access with VBA. Specifically, you will learn how to use the Visual Basic editor, work with the object model, create and use variables, and use the selection structure. You will learn to use flow control, create custom dialogs, automate processes, and handle errors.

Section 1: Getting Started

Introduction to Programming in Access

Why Program in Access?

Understanding the Development Environment

Using Visual Basic Help

Section 2: Working with Procedures and Functions

Understanding Modules

Creating a Standard Module

Understanding Procedures

Creating a Sub Procedure

Calling Procedures

Using the Immediate Window to Call Procedures

Creating a Function Procedure

Naming Procedures

Organizing Code and Procedures

Working with the Code Editor

Section 3: Understanding Objects

Understanding Classes and Objects

Navigating the Access Object Hierarchy

Understanding Collections

Using the Object Browser

Working with the Application Object

Understanding the Form Object

Working with Properties

Using the With Statement

Working with Methods

Understanding the DoCmd Object

Working with Events

Understanding the Order of Events

Section 4: Using Expressions, Variables, and Intrinsic Functions

Understanding Expressions and Statements

Declaring Variables

Understanding Data Types

Working with Variable Scope

Working with Variable Lifetime

Considering Variable Scope and Lifetime Together

Using Intrinsic Functions

Understanding Constants

Using Intrinsic Constants

Using Message Boxes

Using Input Boxes

Section 5: Controlling Program Execution

Understanding Control-of-Flow Structures

Working with Boolean Expressions

Using the If...End If Decision Structures

Using the Select Case...End Select Structure

Using the For...Next Structure

Using the For Each...Next Structure

Using the Do...Loop Structure

Guidelines for Use of Branching Structures

Section 6: Working with Recordsets

Declaring and Creating Object Variables

Working with the DAO Recordset Object

Section 7: Debugging Code

Understanding Errors

Using Debugging Tools

Setting Breakpoints

Setting Break Expressions

Using Break Mode During Run Mode

Stepping through Code

Determining the Value of Expressions

Section 8: Handling Errors

Understanding Error Handling

Understanding VBA's Error Trapping Options

Trapping Errors with the On Error Statement

Understanding the Error Object

Writing an Error-Handling Routine

Working with Inline Error Handling