Publisher: Microsoft

Version: 2002 (XP)
Length: 2 day s
Course-ID: 084403x

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