Introduction to VBA for MS Access

2 Days

Topics:

The Access Object Model
What are objects?
Properties
Methods
Events

Visual Basic Editor
The Project Window
The Main Window
The Object Browser

Events
What does an event look like?
Using the button wizard
Creating our own events

Interacting with our Form
Reading properties
Writing properties
Interpreting form inputs
Pop-ups

Variables
Data types
Declaring variables
What is 'Option explicit'
Assigning variables
Variable manipulation

VB Techniques
Conditional statements
If..then
If..then..else
Select..case
Loops
Do..while
Do..until
While..loop
For..loop
For..each

Functions and Procedures
What is a function
What is a procedure
Declaring a function
Declaring a procedure
Passing data

Modules
What is a module
Creating/editing a module

Scope
What is scope?
Using appropriate scope

Debugging
The Immediate window
Using breakpoints
Stepping through code

Error Handling
Why is error handling important?
How to use 'on error'
The err object

Application Programming Interfaces
Communicating with other software
What is an API?
References

Questions and Answers