Microsoft Access VBA – Programming

VBA is the programming Interface for Access.

This Microsoft Access VBA training course will teach you how to manipulate your Access database using VBA (Visual Basic for Applications) code, automating the database.  Access VBA extends the features of the database, providing you with the full power of Visual Basic programming to manipulate Access objects.

What You'll Learn

·       Understand the Access Object Hierarchy

·       Use Variables Arrays and Constants

·       Use Functions Message Boxes and Input Boxes

·       Control Program Execution

·       Debug Code

The VBA Code Editor

Two ways to create modules

Using Project Explorer

Basic subroutines and comments


Understanding the Access Object Hierarchy

Understanding Access Objects

Using the Object Browser

Controlling the Application Object

Understanding the Forms Collection and Form Object

Understanding the Controls Collection and Control Object

Using the With Statement

Understanding the Reports Collection and Report Object

Understanding the DoCmd Object

Using the Screen Object


Using Variables Arrays and Constants

Declaring Variables

Declaring Arrays

Declaring Constants

Declaring Object 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 IfThenEnd If Structure

Using the IfThenElseEnd If Structure

Using the Select CaseEnd Select Structure

Using the DoLoop Structure

Using the For Next Structure


Debugging ans Error handling

Understanding Errors

Using Debugging Tools

Stepping Through Code and Setting Break Points

Understanding Error Events

Understanding the Error Object

Using the On Error Statement

Writing an Error Handling Routine

Compiling All Procedures

Program Details
Duration 3 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom

Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.