VBA Access Training Course Online

Free sample lesson: Using VBA to Update Database Records

Microsoft Visual Basic for Applications (VBA) is part of the Microsoft Visual Basic family that is used to program and extend the capabilities of applications such as Microsoft Access. This online VBA for Access training course contains a series of video-based training tutorials designed for users who want to use VBA to program Microsoft Access database, or those wanting to improve and consolidate their programming skills in the context of Microsoft Access. The course begins with the basics of VBA including macros and quickly advances to cover the more advanced features, including Data Access technologies, Object Oriented Programming, error handling and much more.

Although there are significant changes in MS Access 2007, VBA remains the same whether you use Access 2003 or 2007. Consequently, even though the course materials are based on MS Access 2003, the VBA concepts, principles and examples can also be applied to MS Access 2007.

Excercise files can be downloaded by subscribed users who want to follow along each tutorials.

Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials. All tutorials will be activated immediately when you subscribe.

Register and Start Learning Today

VBA for MS Access Training Course

Click the links below to view the video tutorials

Introduction

Chapter1 - Getting Started
What is VBA?
Accessing the VBA editor
The VBA interface
VBA code writing
VBA help

Chapter 2 - Working with VBA Variables
Defining & creating variables
Data types
Constants
Static variables
Option explicit & option compare
Variable scope

Chapter 3 - Working with Procedures and Modules
Exploring procedures
Exploring modules
Using arguments
Function procedures
Code readability

Chapter 4 - Object Oriented Programming
Creating a class & object I
Creating a class & object II
The object browser
Using system classes

Chapter 5 - Event Programming
Events & event handler
Using events
Using form events

Chapter 6 - Working with Multiple Forms
Using docmd
Forms collection
Managing multiple forms

Chapter 7 - Validating Data
Validating levels
Data validation I
Data validation II

Chapter 8 - Control Structures: Decision Making
If...Then...Else
Select case statements
Choose function
With statement

Chapter 9 - Control Structures: Looping
For ... Next statement
For each statement
Do while statement
Do until statement
Do loop while & do loop until

Chapter 10 - Data Access
Introduction to data access
Creating ADO objects
Binding data
Using queries
Updating records
Adding records
Archiving records
Deleting records
Data Access Objects (ADO)

Chapter 11 - Error Handling and Debuggin
Errors & error handling I
Errors & error handling II
The resume statement
Obtaining error information
Debugging & navigating your code
Working in break mode
The immediate window
The locals window
The watch window

Chapter 12 - Application Completion
Testing
Creating a splash screen
Packaging the application
Splitting the database