Programming Microsoft Access 2002

Knowledge workers and technologists who are familiar with using Access and other Microsoft Office applications but whose previous programming experience is limited

Any programmers who require an introduction to Office development using Visual Basic

Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Access 2002 applications to write custom functions and event-driven procedures.

Validate data.

Find and trap errors.

Gain access to and manipulate data in tables by using Microsoft ActiveX Data Objects (ADO) and the Structured Query Language (SQL).

Create a custom switchboard for an Access application.

Ability to design a relational database

Ability to use Microsoft Access to create a database with multiple tables, forms, and reports, and to create queries

Microsoft Windows XP

Microsoft Access 2002

Using Visual Basic Help

Writing Procedures

Working with Variables

Controlling Program Flow

Calling Procedures

Use Visual Basic Help.

Use the Visual Basic Editor to add code to applications.

Declare and use variables.

Use built-in functions to obtain values from users.

Create and call Sub procedures.

Use conditional statements to control the flow of programs.

Overview of the Class Application

Adding Event Procedures

Working with Events

Using Objects, Properties, and Methods

Using the DoCmd Object

Create an event procedure.

Add an event procedure to a form.

Respond to user actions programmatically.

Perform specific tasks by using the DoCmd object.

Overview of Data Validation

Validating Data Without Using Code

Validating Data by Using Code

Differentiate between data validation at the table level, form level, and code level.

Use the built-in validation tools in Microsoft Access.

Using Functions

Understanding Scope

Describe the appropriate use of functions.

Call built-in and custom functions in an application.

Create a custom function.

Describe the different levels of scope available to variables and procedures.

Define variables at the appropriate level of scope.

Define procedures at the appropriate level of scope.

Stepping Through Code

Viewing Variables

Set breakpoints to stop program execution.

Run selected portions of code.

Test data and procedures in the Immediate window.

Monitor variable values in the Locals window.

Add and edit watch expressions.

Types of Errors

Adding Error Handlers

Trap run-time errors.

Create error handlers.

Use the Err object.

Overview of Looping Structures

For Loops

Do Loops

List the different looping structures available in Visual Basic for Applications.

Write a For...Next loop to perform execution of code statements a fixed number of times.

Write a Do...While and a Do...Until loop to perform execution of code statements a variable number of times.

Describe the difference between beginning-of-loop and end-of-loop evaluation methods, and write code statements to accomplish each type of evaluation.

Overview of Recordsets

Retrieving Data

Structured Query Language (SQL)

Manipulating Data

Define recordsets.

Access data in tables by using ADO recordsets.

Retrieve data by using SQL and ADO recordsets.

Manipulate data by using SQL and ADO recordsets.

About XML

Importing XML

Exporting XML

Transforming XML

Modifying XML using the DOM

Describe XML and related technologies.

Import XML into Access.

Export XML from Access.

Transform XML by using the Extensible Stylesheet Language for Transformations (XSLT).

Modify XML by using the DOM.

Reviewing Your Application

Enhancing the User Interface

Packaging for Delivery

List four good coding practices and describe why you should use them.

Describe the testing criteria for an application.

Customize a switchboard.

Hide code by creating an MDE file.

Describe how to use the Compact and Repair utility to maintain your database application.

Describe why and how to use the Database Splitter utility.

Describe when and how to use the Packaging Wizard to prepare an application for distribution.