Access 2000

Planning and Designing Databases
Determine appropriate data inputs/outputs for your database
Create table structure
Establish table relationships

Working with Access
Use the Microsoft Office Assistant
Select an object using the Objects Bar
Print database objects (tables, forms, reports, and queries)
Navigate through records in a table, query, or form
Create a database (using a wizard or in-design view)

Building and Modifying Tables
Create tables by using the Table Wizard
Set primary keys
Modify field properties
Use multiple data types
Use multiple data types
Use the Lookup Wizard
Use the Input Mask Wizard

Building and Modifying Forms
Create a form with the Form Wizard
Use the Control Toolbox to add controls
Modify Format Properties (font, style, font size, color, caption, etc.) of controls
Use form sections (headers, footers, and detail)
Use a Calculated Control on a form

Viewing and Organizing Information
Use the Office Clipboard
Switch between object views
Enter records using a datasheet
Enter records using a form
Delete records from a table
Find a record
Sort records
Apply and remove filters (filter by form and filter by selection
Specify criteria in a query
Display related records in a subdatasheet
Create a calculated field
Create and modify a multitable select query

Defining Relationships
Establish relationships
Enforce referential integrity

Producing Reports
Create a report with the Report Wizard
Preview and print a report
Move and resize a control
Modify Format Properties (font, style, font size, color, caption, etc.)
Use the Control Toolbox to add controls
Use report sections (headers, footers, and detail)
Use a Calculated Control in a report

Integrating with Other Applications
Import data to a new table
Save a table, query, or form as a Web page
Add Hyperlinks

Using Access Tools
Print database relationships
Back-up and restore a database
Compact and repair a database