Access Programming with
Visual Basic for Applications (VBA) - 2 Days

Getting Started

• Introduction to Programming in Access

• Why Program in Access?

• Creating a Macro

• Understanding Modules

• Creating a Standard Module

• Understanding the Development Environment

• Using the Project Explorer

• Using the Properties Window

• Using the Code Window

Working with Procedures and Functions

• Understanding Procedures

•  Creating a Sub Procedure

•  Creating a Function Procedure

•  Calling Procedure and Functions

•  Using the Immediate Window

•  Working with Code

Understanding Objects, Properties, Methods and Events

• Understanding Objects and Collections

• Understanding Properties

• Understanding Methods

• Understanding Events

Understanding the Access Object Hierarchy

• Understanding Access Objects

•  Using the Object Browser

•  Controlling the Application Object

•  Understanding Forms Collection and Form Object

•  Understanding Controls Collection and Control Object

•  Using the With Statements

•  Understanding Reports Collection Report Object

• Understanding the DoCmd Object

•  Using the Screen Object 

Using Variables, Arrays, and Constants

• Declaring Variables

•  Declaring Arrays

•  Declaring Constants

•  Declaring Objects 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 If…Then…End If Statements

•  Using the If…Then…Else If Structure

•  Using the Select Case…End Select Structure

•  Using the Do…Loop 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 Err Object

•  Using the On Error Statement

•  Writing an Error Handling Routine

•  Compiling All Procedures