Advanced Database Design in Access 2002

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

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 (hours)
5.8

Lesson Objectives

Advanced Database Design in Access 2002

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:
116022_eng