Access 2002 VBA Programming

2 days

Overview

Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code.

Prerequisites

Access 2002 Advanced, or equivalent knowledge.

Benefits

Students will learn how to build an application by designing and creating the database objects and a graphical user interface.

Target student

Students should understand table, query, form, report, and macro design and function, as well as data normalization and table relationships.

Designing an application

Examining an application
Planning an application
Automating forms

Automating forms

Working with dialog boxes
Working with macro groups
Automating navigation across forms

Working with Switchboard and Splash Screen forms

Working with Switchboard forms
Working with Splash Screen forms
Automating Splash Screen forms

Creating custom toolbars and menu bars

Working with toolbars
Creating custom and shortcut menus

Working with VBA code

Discussing VBA programming elements
Working with modules
Creating procedures

Advanced VBA programming

Using control structures
Handling events
Resolving errors
Displaying a Web site
Working with MDE files