Advanced Database Design in Access 2002 (non-audio)

Overview/Description
To provide an overview of advanced database design in Access 2002

Target Audience
Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level

Prerequisites
The Microsoft Office XP: Beginning Access 2002 learning path; familiarity with any Windows user environment

Expected Duration
345 Minutes

Objectives:

Advanced Database Design in Access 2002 (non-audio)

  • validate data in Access 2002.
  • insert a validation rule and validation text in Access 2002.
  • describe how to optimize data types in Access 2002.
  • validate and restrict data entered into a table in Access 2002.
  • create and modify a form in Access 2002.
  • customize a form in Access 2002.
  • create and customize a form in Access 2002.
  • use subforms in Access 2002.
  • use the subform control in Access 2002.
  • use switchboards in Access 2002.
  • create and modify reports in Access 2002.
  • use Design view to modify reports in Access 2002.
  • manipulate report control and section properties in Access 2002.
  • modify report properties in Access 2002.
  • use subreports in Access 2002.
  • create a subreport in Access 2002.
  • filter queries and modify query properties in Access 2002.
  • apply filters in a query in Access 2002.
  • specify join properties in Access 2002.
  • use totals and parameter queries in Access 2002.
  • create totals and parameter queries in Access 2002.
  • use action queries in Access 2002.
  • optimize query performance in Access 2002.
  • use queries in Access 2002.


    • Course Number: 37597_eng