Back to Search Results

Training Course Summary:

Microsoft Access is the desktop database design product from the Microsoft Office professional suite. This course teaches experienced Access users about the greater advantages to be gained by combining the built-in features of Access with the programming capabilities of Visual Basic for Applications (VBA).

Pre-Requisites:

The course is aimed at those with no previous programming experience, who are looking to develop databases that go beyond what Access alone is capable of.
Delegates must have an excellent working knowledge of Microsoft Access. You must be able to create tables, queries, forms and reports.

Training Course Overview/Content:

Session 1 - Macros: Creating basic macros and attaching them to events

Session 2 - Advanced macros: Group and Conditional macros

Session 3 - Introduction to the Object Model

Session 4 - Using the VBA Integrated Development Environment

Session 5 - Collections, Variables and Notation

Session 6 - Message Boxes and Input Boxes

Session 7 - Control Structures I: Branching with ‘if’ and ‘select case’

Session 8 - Control Structures II: Looping with ‘for each’, ‘do while’ and ‘do until’

Session 9 - Using built-in VBA functions

Session 10 - Control Structures III: Jumping; creating your own Methods & Functions

Session 11 - Error trapping and debugging

Session 12 - Workshop and practise time