How To Take This Class

Course Overview

In this Microsoft Access 2016 VBA Training course, students will learn how to use the VBA (Visual Basic for Applications) programming language to automate their database applications. They will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. Students will be introduced to the Microsoft Access Object Model, which will allow them to control all aspects of the application, including things like closing or opening forms, printing reports or validating user data entry. Students will also be introduced to accessing data in the database through code by using Data Access Objects (DAO,) allowing the manipulation of data behind the scenes - with no user action needed. Finally, students will see how to debug their code and add error handling to ensure that unexpected errors don't force an application shutdown. Although a programming environment, VBA is fun and easy to learn - even for students who have no programming experience!

Course Prerequisites

Students should have basic experience in creating and using tables, forms, reports and queries in Microsoft Access. No programming experience is necessary.

Course Audience

This course is designed for students who want to go beyond macros in Microsoft Access to automate actions in their database.

What You'll Learn

Upon successful completion of this course, students will be able to:
  • Create Sub Procedures and Functions
  • Attach code to user-initiated or application-initiated events
  • Control program flow by using If/Then and Looping structures
  • Access and modify data in the database directly using code
  • Debug code to find and fix programming errors
  • Implement error-handling code to catch and resolve run-time errors

Course Duration

2 Days

Course Outline

  1. Getting Started
    • Introduction to Programming in Access
    • Why Program in Access?
    • Understanding the Development Environment
    • Using Visual Basic Help
  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
  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
  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
  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
  6. Working with Recordsets
    • Declaring and Creating Object Variables
    • Working with the DAO Recordset Object
  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
  8. Handling Errors
    • Understanding Error Handling
    • Understanding VBA's Error Trapping Options
    • Trapping Errors with the On Error Statement
    • Understanding the Err Object
    • Writing an Error-Handling Routine
    • Working with Inline Error Handling

What Students Receive

Each student will receive:
  • A printed courseware manual with examples and hands-on exercises for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2016 Training Class
  • A course completion certificate upon successful completion of your Microsoft Access 2016 Training course
  • Six months of post-class live, online chat support from a Microsoft Access Instructor