Microsoft® Office Access 2007 on Demand

6. Locating Specific Information Using a Query

What You’ll Do

Understand Types of Queries

Create and Modify a Query in Design View

Get Information with a Query

Create a Query Using a Wizard

Change the Query Fields

Specify Criteria for a Single or Multiple Fields

Create Queries with Comparison and Logical Operators

Perform Calculations in Queries

Create a Parameter Query

Find Duplicate Fields and Unmatched Records

Create New Tables with a Query

Add Records with a Query

Delete Records with a Query

Update Records with a Query

Summarize Values with a Crosstab Query

Create SQL-Specific Queries

Introduction

A query is a description of the records you want to retrieve from a database. As the name implies, a query helps answer specific questions about ...