How To Take This Class

Course Overview

In this Microsoft Access 2010 VBA Training course, students will learn how to automate their Access database application through the use of VBA code. Students will learn how to use the VBA development environment, write code in response to events, use functions and subprocedures, work with data in code and debug VBA code.

Course Prerequisites

Students should have attended or be familiar with the topics in the Microsoft Access Introduction and Advanced classes.

Course Audience

This Microsoft Access VBA Training course is designed for students who have experience in creating Access forms, queries and reports but now want to further automate their database application through the use of VBA code.

What You'll Learn

Upon successful completion of this class, students will be able to:
  • Navigate the VBA Development Environment
  • Use Sub and Function Procedures
  • Use the Object Browser
  • Work with common objects in VBA code
  • Declare variables and understand VBA data types
  • Control program flow based on conditions
  • Work with the Access recordset object
  • Debug VBA code and handle 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
  9. Appendix - Working with the ADO Recordset Object

What Students Receive

Each student will receive:
  • A printed courseware manual for use during and after class.
  • Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2010 VBA Training Class
  • A course completion certificate upon successful completion of your course
  • Six months of post-class live, online chat support from a Microsoft Access Instructor