Access VBA

Creating modules
What is a module?
Declarations section
Sub and function procedures
The module window
The module toolbar
Edit and navigation keys
Managing modules and procedures
Global modules and code behind forms

Creating procedures
Naming rules and conventions
Incorporating macro actions
Using the express builder
Built-in functions

User defined functions
Function arguments
Returning values from functions
Using user defined functions in queries and forms

Event procedures
The code builder
Referring to form and report controls
Event sequences

Constants and Variables
Declaring constants
Declaring variables, arrays and data types
Scope of variables
Scope of procedures

Debugging Access Basic
Types of error
Compiling Access Basic
Setting break points
Stepping into and over
Using the immediate window

Error handling
On error statement
Trapping error codes
Reporting errors

Using database objects
Objects and collections
Setting object variables
Handling record sets
Adding and editing data
Handling and running queries

Developing applications
Event driven code
Using unbound forms
Setting properties and values on forms and reports
Setting configuration options from code
Linking Access Basic and Macros

Creating Add in Libraries
Configuring an add in
Restrictions and requirements