Plan a database

• Design a relational database

• Identify database purpose

• Review existing data

• Determine fields

• Group fields into tables

• Normalize the data

• Designate primary and foreign keys

Build the structure of a database

• Create a new database

• Create a table using a wizard

• Create tables in design view

• Create relationships between tables

Control data entry

• Restrict data entry with field properties

• Create an input mask

• Create a lookup field

Find and join data

• Find data with filters

• Create query joins

• Join unrelated tables

• Relate data within a table

Create flexible queries

• Set select query properties

• Create parameter queries

• Create action queries

Improve forms

• Enhance the appearance of a form

• Restrict data entry in forms

• Add command buttons

• Create a subform

Customize reports

• Organize report information

• Set report control properties

• Control report pagination

• Summarize information

• Add a subreport to an existing report

• Create mailing labels

Expand the reach of your data

• Publish Access data as a Word file

• Analyze Access data in Excel

• Export data to a text file

• Merge Access data with a Word document