Course Code: 5596

Advanced Access VBA

Class Dates:
2 Days
Class Time:


  • Course Overview
  • This 2-day instructor led course is for advanced Access VBA students. Students will work with Data, Create Schema, Data Manipulation, Other Data files and Other Applications

    With Microsoft Access VBA you will learn Visual Basic for Applications (VBA). VBA is a superset of the Visual Basic command syntax and a rich assortment of functions with the capability to control objects in your application.

    With the information provided you will explore commands, functions, properties, and methods and how to use them.

    You will learn the two main ways to get at data: Data Access Objects (DAO) and ActiveX Data Objects (ADO). You will learn object models as they apply to the Access Connectivity Engine (ACE), the database engine under the hood of Access. You will learn advanced topics of database analysis, such as retrieving a list of all relationships in your database or discovering all the computers that are connected to your database.

  • Audience
  • Access Database Users and Analysis.


  • Students who took Access Programming with VBA Introduction.

Course Details

  • Menus, Navigation, and Ribbon
  • Introduction to Menus
  • Creating Form-Based Menus
  • Managing the Navigation Pane
  • Using Custom Ribbons
  • Application Collections
  • Understanding application Collections
  • Retrieving Lists of Objects
  • Working with Object Properties
  • Programmatically Determining Dependencies
  • Case Study-Version Control
  • Working with Data / Object Models for Working with Data
  • What they Are and Why We Need Them
  • Data Access Objects
  • ActiveX Data Objects
  • ActiveX Data Objects Extensions for Data Definition
  • Object Model Selection
  • Creating Schema
  • Overview
  • Creating Databases Using DAO & ADOX Object Model
  • Creating Tables
  • Creating Fields
  • Creating Indexes
  • Creating Relationships
  • Creating Queries
  • Case Study - Updating an Existing Database Installation
  • Data Manipulation
  • Connecting to a Data Source
  • Opening a Recordset
  • Inserting Data
  • Finding Data
  • Updating Data
  • Deleting Data
  • Case Study / Backing Up Data
  • Advanced Data Operations
  • Creating Linked Tables
  • Data Definition Language
  • Schema Recordsets
  • Subqueries
  • Working with Other Data Files
  • Understanding File I/O
  • Opening Files
  • Reading from Files
  • Writing to Files
  • Printing to Files
  • Case Study - Using ini Files
  • Working with Other Applications
  • Understanding Automation
  • Setting Object References
  • Creating Objects
  • Working with Automation Servers
  • Case Study - Using Excel Charts
  • Working with XML Files
  • Understanding XML
  • Using Export XML
  • Using Import XML
  • Using the Windows API
  • Declaring API Calls
  • Using API Calls
  • API Calls You Can Use from Access
  • Knowing When to Use the Windows API
  • Case Study - Capturing a Filename to Use for Processing
  • A Review of Access SQL
  • Introduction to SQL
  • SQL Structure and Syntax
  • The Select Statement
  • The Insert Statement
  • The Update Statement
  • The Select Into Statement
  • The Delete Statement
  • Crosstabs