access VBA programming course

This is a course for Access developers who want an appreciation of the Access version of VBA (Visual Basic for Applications) and its use in enhancing database operability.

course duration

Two days on-site.

course pre-requisites

Practice in those database development skills covered by our Basic Introduction, Intermediate and Advanced courses.

course content

Topics may include the following and you can specify others to suit your objectives.

macros and visual basic for applications (VBA)

Why use, and when to use, VBA
Why not use macros
New macro performance in Access 2007.

access programming environment

Modules
Using the VB Editor
Using VB Help.

procedures and functions

Sub procedures
Function procedures
Calling procedures
Use of Immediate Window to test code
Organizing code and procedures.

references

Relevance of References
Managing References.

objects

Object model
Object classes
Object hierarchy
Object collections
Using the Object Browser
The Application Object
The Form Object.

working on properties

Distinguishing Properties
Using the With...End With statements
Working with Events.

working with methods

Distinguishing Methods
Understanding the DoCmd Object.

coding

Expressions
Statements.

variables and constants

Declaring variables
Variable data types
Variable scope and lifetime
Local and global constants.

functions

Intrinsic functions
Message boxes
Input boxes
Custom functions.

program execution control

Program flow
Boolean expressions
If...Else...End statements
Select Case...End Select statements
For...Next statements
For Each...Next statements
Do...Loop statements.

recordsets

DAO and ADO
Managing object variables
ADODB Recordset Object
Specifying a Recordset Cursor Type
Processing data sets programmatically.

debugging code

Understanding Errors
Using debugging tools
Testing and evaluating expressions.

error handling

Purpose of error handling
Essential error handling
VBA error object
Trapping and responding to errors
General-purpose error-handling code.

applying code to forms

Event code
Controls code
Form code.

applying code to reports

Controls code
Report code.

london, kent, surrey and sussex

We regularly travel to clients in London and the South East. Based near Tonbridge, we are particularly well placed to visit clients throughout Kent, East and West Sussex, Surrey and London.

As we have done in Ashford, Aylesford, Brighton, Canterbury, Chatham, Chiddingstone, East Grinstead, Edenbridge, Heathfield, Lightwater, London, Maidstone, Maresfield, Orpington, Paddock Wood, Richmond, Rochester, Sevenoaks, Sittingbourne, Tadworth, Ticehurst, Tonbridge, Tunbridge Wells and Westerham.