Computer and Business Skills training

Sign Up
Home / Access / VBA

Microsoft Access VBA Training Course

Course Description

This hands-on course is aimed at experienced Access users looking to automate many of the repetitive tasks that are part of database development by applying the Visual Basic for Applications (VBA) programming.

Live face-to-face instructor. No minimum class size - all classes guaranteed to run!

Students should have completed our Advanced class or have the equivalent knowledge prior to attending. Suitable for Access 2010/2013/2016 users.

View our full range of Microsoft Access training classes, or see below for the detailed outline for Access VBA.

2 Days | $850.00

Register button

Detailed course outline

  • Visual Basic Editor
    • Visual Basic Terminology
    • Work with Objects, their properties, methods, and events
    • Use Object Browser to get information about Objects
    • Identify Collection Objects and use Collection Control
  • Programming Basics
    • Manipulate and Combine Data to get User input
    • Declare Variables and Procedures
    • Create Sub and Function Procedures
    • Call one Procedure from other
  • Control Structures
    • Use Decision Structures to create procedures that execute code
    • Use Loop structures to execute code repeatedly
  • ActiveX Data Objects
    • Examine ActiveX Data Objects architecture and collections
    • Connect to a Database
    • Work with a Recordset and Parameter query
  • VBA Debugging Tools
    • Identify compile-time, run-time and logical errors
    • Use the Debugging Tools
    • Write Error-handling code to trap errors

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.



230 W Monroe St
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Peet's Coffee brewed every day FREE Class Repeat with each course