After completing Access 2002: Relationships & Queries, the user should be able to:

	Define table relationships
	Manage table relationships
	Display related records
	Specify query criteria
	Create calculated fields
	Create and modify multi-table queries

Establishing Table Relationships

	Creating table relationships
	Applying relationships
	Defining relationship types
	Using joins

Managing Table Relationships

	Enforcing referential integrity
	Using cascading options
	Printing database relationships

Displaying Related Records

	Displaying records in a subdatasheet
	Expanding and collapsing subdatasheets

Specifying Query Criteria

	Defining a query
	Establishing a query
	Using expressions
	Applying a query

Creating Calculated Fields

	Calculating statistical information
	Adding summary information
	Defining formulas

Using Multi-Table Queries

	Creating a multi-table select query
	Using the Simple Query Wizard

This course has the following features:

	Exercises that allow users to practice in Access 2002
	A file containing the text of the exercises
	Simulations that allow users to practice course skills, even if they don't have access to Access 2002
	A glossary
	A Skill Assessment

	Office 2000: Getting Started (O2KC01)
	Office 2000: Editing Text and Printing (O2KC02)
	Office 2000: Text and Document Formats (O2KC03)
	Office 2000: Introduction to Access (O2KC08)
	Access 2002: Creating Databases (AXPM01)
	Access 2002: Building Tables (AXPM02)
	Access 2002: Modifying Tables (AXPM03)
	Access 2002: Sorting and Filtering (AXPM04)

	Access 2002: Building Forms (AXPM06)
	Access 2002: Producing Reports (AXPM07)
	Access 2002: Advanced Tasks (AXPM08)

Microsoft® is a registered trademark of Microsoft Corporation.

Access® is a registered trademark of Microsoft Corporation.