Introduction to VBA for MS Access

The objective of the course is to introduce the candidates to the language and commnads use to  programme or automate functions with MS Access.

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