Great Canadian Training Company color logo

Microsoft Access VBA Complete

What You'll Learn in Microsoft Access VBA Complete

Course Length:

18 hours (3 days)

Learning Objectives

In this course, you will learn how to use Access VBA. You will:

  • Understand how the Visual Basic editor works in Access
  • Learn to work with the VBA object model
  • Learn to work with VBA object variables
  • Learn to work with string variables
  • Learn to work with date variables
  • Learn to work with numeric variables
  • Learn to use the selection structure
  • Learn to use the Select Case statement and the MsgBox function
  • Learn to work with the repetition structure
  • Learn to work with option button, check box, and list box controls
  • Learn to use Automation
  • Learn to trap errors

Target Student

Users who need to use the added functionality of Access Visual Basic for Applications to build, maintain, manipulate and automate databases.

Course Outline

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

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Microsoft Access VBA Complete

Upcoming Classes

All Public classes are held online
with a live instructor

No dates have been scheduled for this class. Please contact us for more information or request a private class.

I want to talk to someone about private or customized training

Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference