Chapter 13. Locating and Managing Data with Access

What You'll Do

Sort Records

Filter Out Records

Create Complex Filters Using Forms

Understand the Different Types of Queries

Create a Query Using a Wizard

Create a Query in Design View

Get Information with a Query

Modify a Query in Design View

Perform Calculations in Queries

Summarize Values with a Crosstab Query

Create a Parameter Query

Find Duplicate Fields

Identify Object Dependencies

Back Up a Database

Compact and Repair a Database