Programming Microsoft Access 2002 Training Class

Lesson 1: Introduction to Programming

Using Visual Basic Help
Writing Procedures
Working with Variables
Controlling Program Flow
Calling Procedures

Lesson 2: Responding to User Actions

Overview of the Class Application
Adding Event Procedures
Working with Events
Using Objects, Properties, and Methods
Using the DoCmd Object

Lesson 3: Validating Data

Overview of Data Validation
Validating Data Without Using Code
Validating Data by Using Code

Lesson 4: Using Functions and Understanding Scope

Using Functions
Understanding Scope

Lesson 5: Using Debugging Tools

Stepping Through Code
Viewing Variables

Lesson 6: Handling Run-Time Errors

Types of Errors
Adding Error Handlers

Lesson 7: Looping Through Code

Overview of Looping Structures
For Loops
Do Loops

Lesson 8: Working with Records

Overview of Recordsets
Retrieving Data
Structured Query Language (SQL)
Manipulating Data

Lesson 9: Working with XML

About XML
Importing XML
Exporting XML
Transforming XML
Modifying XML using the DOM

Lesson 10: Finalizing Your Application

Reviewing Your Application
Enhancing the User Interface
Packaging for Delivery