Microsoft® Office 2007 On Demand

15. 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

Introduction

Once you’ve created a database, you’ll want to be able to manage the records and information within that database. Microsoft Office Access 2007 gives you numerous ways to manage the records and information stored within the database.

Some of the techniques ...