Reasons for using VBA rather than Macros

Understanding the Development Environment

The Visual Basic Editor

Parts of the Screen

Code colours

Using Visual Basic Help

Modules, Procedures

Creating a Sub Procedure

Call Sub Procedures

Creating a Function Procedures

Using a Function Procedure

Declaring Variables

Understanding Data Types

Working with Variable Scope

Using Intrinsic Functions

Understanding Constants

Using Message Boxes, Using Input Boxes

Understanding Classes and Objects

Navigating the Access Object Hierarchy

Understanding Collections

Using the Object Browser

Working with the Application Object

Using Properties, Using Methods

Using the With Statement

Working with Events

Order of Events

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...To Next Structure

Using the For Each Next Structure

Using the Do...Loop Structure

Declaring and Creating Object Variables

Working with the Recordset Object

Error Types, Minimising Errors

Setting Breakpoints

Stepping through Code

Understanding Error Handling

On Error Statement

Understanding the Err Object

Writing an Error-Handling Routine

Working with Inline Error Handling