Microsoft Office training - Access VBA macros

Access Training

Access VBA macros (2 days)

£625 + VAT for most venues (£750 + VAT for London)

Access supports two different programming languages:

The painting-by-numbers macros, which you can use to perform basic functions;
The far more powerful VBA (Visual Basic for Applicatons) programming language.

If you're going to be using Access, we think you should be learning VBA - it's far more powerful, and is compatible with the programming languages used by other MS Office applications such as Excel and Word. On this two-day course you'll learn about the DoCmd object, variables, handling form events, linking to recordsets and much more!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking (or consider an onsite Access training course).

Course Contents - PDF

Course Contents

The VBA code editor

Two ways to create modules
Using Project Explorer
Basic subroutines and comments

Messages and variables

The all-powerful DoCmd object
Displaying messages
Getting input from users
Using variables

Creating functions

Passing arguments
Returning values

Visual Basic explained

Objects and collections
Methods and properties
The Access object model
Getting help in VBA

Attaching code to forms

Attaching code to buttons
Attaching code to events
Manipulating form/control properties
Making code not form-specific

Looping

The four types of loop
Looping over all open forms
Looping over controls
Looping over Access Objects

Recordsets

Choosing ADO or DAO
Adding data
Editing data
Deleting data

Debugging and error handling

Stepping through macros
Setting breakpoints
Trapping for errors

Case studies

Navigation buttons
Creating a simple menu
Validating forms
Criteria forms

Covered if time allows If time

Linking to Excel and Word

Referencing other applications
Manipulating Excel from Access

Covered if time allows If time

Modifying queries

Basic SQL statements
Amending queries' SQL

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
492 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"Course admin good with helpful maps and hotel suggestions appreciated. Love the course manual - good details and much better materials than other courses I've been on. Useful materials and USB stick to help consolidate. I was impressed with the resources on the Wise Owl website - in particular the videos are excellent."

Mary-Ann Forrest (Cotswold District Council)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Delegates should only attend this course if they have a good working knowledge of Access basics, and if they are proficient computer users. Experience of programming, while useful, is not essential.