Access 2010 - VBA (Visual Basic for Applications)

ACC-10-11

Duration

2 days

Who should attend?

Anyone who finds that macros are not enough to perform the tasks that they require out of their database.

Pre-requisites

Familiarity with topics covered in modules:

Objectives

To gain an understanding of how to use VBA and what can be accomplished by it in Access.

Course Content

Overview

What is VBA? Explanation of subroutines and functions.

Visual Basic Editor

The VB Editor screen. VB Editor options. VBA syntax. VBA help when typing. Insert comment text.

Variables

Declare variables and variable scope. Variable data types.

Control Structures

Control the branching / flow of a subroutine using IF statements, Do...Loops, For...Next Loops, For...Each Loops, Case Statements.

Event Procedures

Understand 'events' and the sequence of various events. Write a routine that runs when a particular event occurs.

Error Handling

Write error trapping code to make the routine more robust.

DAO

What is DAO? The Object Hierarchy. Using Recordsets. Using Querydefs.

OLE

What is OLE? Communicating with OLE compliant applications.