Introduction
This intensive course is designed to introduce new Access programmers to features and facilities of the VBA programming language. It takes a structured look at Microsoft Access VBA helping developers plan their applications systematically, efficiently and economically and promote good design and development techniques.

Course Benefits
In this hands-on course, you build on your existing knowledge of Access vastly extending the power, functionality and scope of applications.

Who should attend
This course is valuable for every new, recent or intending Access programmer who needs a good understanding of the features available in the Microsoft Access VBA language.

Course Outline

Introduction to Programming
What is Visual Basic for Applications?
Event -driven procedures
Modules and code behind forms

Modules and Procedures
Modules
The module toolbar
Sub and function procedures
Databases and projects

User Defined Functions
Creating user defined functions
Arguments and returned values
Access built in functions
Using user defined functions in queries and forms

Event Procedures
The code builder
Form, report, control, and section events
Referring to form and report controls
Incorporating macro actions

Variables, Constants and Arrays
Implicit and explicit declaration
Scope of variables
VBA data types
Arrays and user defined data types

Branching and Looping Structures
Branching - If.End If and Select Case Looping - Do Loop and For Next

User Interaction
The input box and message box
The common dialog control

Debugging VBA
Types of Error
Using the immediate window setting
Break points
Correcting errors

Error Handling
On error statement
Trapping error code

ActiveXData Objects
DAO or ADO?
Microsoft Access Architecture
Open objects and collections
Database engine objects
Setting object variables
Handling recordsets
Locating and editing data
Handling queries
Adding and deleting objects to collections
Using transactions

Creating Libraries
Add in manager