Microsoft Access 2010 VBA Training

How To Take This Class

Live Instructor-Led Online Class

Cost: $650.00

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

2 Days

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

Course Description

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 Objectives

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 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.

Course Prerequisites

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

Course Syllabus

  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