Training Course: Microsoft Access 2003 - VBA

Pre-Requisites:

Delegates should have attended the appropriate introductory and advanced courses plus have several weeks of practice. No programming experience is required.

Training Course Overview/Content:

Module 1

· Getting Started
· Introduction to Programming in Access
· Why Program in Access?
· Understanding the Development Environment
· Using Visual Basic Help

Module 2

· Working with Procedures and Functions
· Understanding Modules
· Creating a Standard Module
· Understanding Procedures
· Creating a Sub Procedure
· Calling Procedures
· Using the Immediate Window to Call Procedures
· Creating a Function Procedure
· Naming Procedures
· Organizing Code and Procedures
· Working with the Code Editor

Module 3

· Understanding Objects
· Understanding Classes and Objects
· Navigating the Access Object Hierarchy
· Understanding Collections
· Using the Object Browser
· Working with the Application Object
· Understanding the Form Object
· Working with Properties
· Using the With Statement
· Working with Methods
· Understanding the DoCmd Object
· Working with Events
· Understanding the Order of Events

Module 4

· Using Expressions, Variables, and Intrinsic Functions
· Understanding Expressions and Statements
· Declaring Variables
· Understanding Data Types
· Working with Variable Scope
· Working with Variable Lifetime
· Considering Variable Scope and Lifetime Together
· Using Intrinsic Functions
· Understanding Constants
· Using Intrinsic Constants
· Using Message Boxes
· Using Input Boxes

Module 5

· Controlling Program Execution
· Understanding Control-of-Flow Structures
· Working with Boolean Expressions
· Using the If...End If Decision Structures
· Using the Select Case...End Select Structure
· Using the For...Next Structure
· Using the For Each...Next Structure
· Using the Do...Loop Structure
· Guidelines for use of Branching Structures

Module 6

· Working with Recordsets
· Declaring and Creating Object Variables
· Working with the ADODB Recordset Object
· Specifying a Recordset Cursor Type
· Locking Records for Updating
· Specifying a Recordset Cursor Location - Optional
· Using the CacheSize Property - Optional
· Understanding Recordset Cursor Properties - Optional

Module 7

· Debugging Code
· Understanding Errors
· Using Debugging Tools
· Setting Breakpoints
· Setting Break Expressions
· Using Break Mode during Run Mode
· Stepping through Code
· Determining the Value of Expressions

Module 8

· Handling Errors
· Understanding Error Handling
· Understanding VBA's Error Trapping Options
· Trapping Errors with the On Error Statement
· Understanding the Err Object
· Writing an Error-Handling Routine
· Working with Inline Error Handling