Using a Select Query in Access 2002

Objectives

Generally To create different views of data using a select query.

Specifically On completion of this lesson, you will be able to:
• Understand the differences between a query and a sort
or filter
• Create a query using the Simple Query Wizard
• Add and remove query fields in design view
• Sort query results
• Specify criteria in a query