Access 2003: VBA Programming Training Class

Course Outline: Access 2003: VBA Programming

Learning Method: Instructor-led Classroom Learning

Duration: 1.00 Day(s)

Overview:
The course is designed for experienced Access users who want to learn activex data objects, control structures, and the basics of VBA programming.

At Course Completion:
- Work with objects, use Object Browser, identify collection objects, and use the Controls collection. - Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another. - Use decision structures and use loop structures. - Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.

Lesson 1: Visual Basic Editor

Objects
Object Browser
Collections

Lesson 2: Programming basics

Data
Scope

Lesson 3: Control structures

Decision structures
Loop structures

Lesson 4: ActiveX Data Objects

Getting started with ActiveX Data Objects
Working with ActiveX Data Objects

Lesson 5: VBA debugging tools

Errors in code
Debugging techniques
Handling run-time errors

Lesson 6: Appendix A: Office integration

Automating Office 2003
Working with Word from Access
Working with Excel from Access