After completing Access 2000 MOUS: Relationships & Queries the user should be able to:

	Define 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
	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 2000
	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 2000
	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 2000 MOUS: Creating Databases (A2KM01)
	Access 2000 MOUS: Building Tables (A2KM02)
	Access 2000 MOUS: Modifying Tables (A2KM03)
	Access 2000 MOUS: Sorting and Filtering (A2KM04)

Microsoft® is a registered trademark of Microsoft Corporation.

Access® is a registered trademark of Microsoft Corporation.

Microsoft and the Microsoft Office User Specialist logo are registered trademarks of Microsoft Corporation in the United States and other countries.