MS Access VBA
This MS Access VBA 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, Object Oriented Programming, error handling and much more.
VBA remains the same across different versions of Microsoft Access so whether you use Access 2003 or 2007, the course materials are applicable to both.
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 Now and Activate This Access VBA Training Course Instantly
MS Access VBA Training Course
Free sample tutorial: Using docmd
Introduction
Chapter1 - Getting Started With Access VBA
What is VBA?
The VBA editor
The VBA editor interface
Writing VBA code
VBA help
Chapter 2 - Access VBA Variables
Defining & creating variables
Data types
Constants
Static variables
Option explicit & option compare
Variable scope
Chapter 3 - VBA Procedures and Modules
Exploring procedures
Exploring modules
Using arguments
Function procedures
Code readability
Chapter 4 - The Concept of 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 - Multiple Forms
Using docmd
Forms collection
Managing multiple forms
Chapter 7 - Data Validation
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 Programming
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 - Access VBA Error Handling and Debugging
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 - Completing Your Access Application
Testing
Creating a splash screen
Packaging the application
Splitting the database
