Home » Training Courses » Microsoft Office Training » VBA For Access Training

VBA For Access Training

2 Days - please call for a quote

This VBA For Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.

VBA for Microsoft Access Course Objectives

Experienced Access users with previous programming experience may find a 1:1 intensive VBA for Access training course achievable in one day. Less experienced users, users without programming experience, or for training in groups, the two day VBA for Access course is recommended.

VBA for Access Training Course Content

Where Code is stored

Standard modules
Class modules

Development Environment

Adding Code to a Form or Report
Types of Procedures
Entering Code

Running Code

Run mode and Design mode
Running Code from the development environment
Running Code from the host application

Reusing Code

Exporting a file
Importing a file

Using VB for Applications Using Variables

Lifetime and scope of variables
Using and writing sub-procedures
Using and writing Function procedure

Controlling Programme flow

Conditional structures
Looping structures
Trapping errors

Debugging

Using the break mode
Using the VB Editor debug features

Using Standard VB

Input Boxes
Message Boxes
Standard VB Functions
Functions in your Code

Access Object Module Forms and Form Events

Reports and Report Events
Creating a Workspace Using the Microsoft Jet Engine
Retrieving a Recordset
Navigating Records
Updating Records
Adding Records
Querying Data

Using VB

Using VB Objects, Methods and Properties to manipulate, read, edit and update data in a Database

VBA for Access Course Prerequisites

Delegates should have a sound knowledge and experience of MS Access at Advanced level and preferably possess some experience in the use of Macros and Events within Access or other programming language.

What our clients think of our VBA training courses

Just a quick line to let you know how much Ilesh and myself gained from the excellent VBA course we recently attended at your offices. Your facilities are excellent and we were most impressed by the trainer's depth of knowledge and ability to restructure the course dynamically to ensure that we obtained the most relevant training.

The two days were not only very informative but also good fun!

Alan Hill - GlaxoSmithKline

VBA for Access Training Recommended Reading

Microsoft Office Access 2007 VBA (Business Solutions)

Access 2007 VBA Programming for Dummies

For full course content and pre-requisites download the VBA For Access Training Course PDF