Access 2002

Creating Databases

	Identify appropriate input and output for a database
	Plan a database
	Create a database with and without the wizard
	Select and print database objects

Building Tables

	Explain the structure of a table the data types used in the table and the function of primary keys
	Create a table using the wizard
	Enter records into the table through a form or datasheet

Modifying Tables

	Insert and delete records and fields
	Modify the appearance and structure of the table in Design View
	Change the size format and default value of fields
	Use the Lookup and Input Mask wizards

Sorting and Filtering

	Sort records
	Create advanced sorts
	Search for records
	Apply and remove filters

Relationships & Queries

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

Building Forms

	Create a form
	Edit the form in design view
	Add and modify controls
	Create and use calculated controls

Producing Reports

	Describe the components of reports
	Create a report using the Report Wizard
	Edit the report in design view
	Add and modify controls in a report
	Create and use calculated controls in a report

Advanced Tasks

	Import data into a table
	Save an Access object as a Web page
	Add hyperlinks to an Access object
	Back up restore and compact a database