Microsoft® Access 2003 Forms, Reports and Queries

Chapter 1. Creating a Basic Query

IN THIS CHAPTER

• Sorting Records

• Filtering Table Data

• Working with Queries

• Creating a Query

• Querying Notes for Business Users

• Case Study

• Creating Queries with the Query Wizards

• Working with a Query Dynaset

• Working with Query Properties

If you have a large amount of data in a table, it's not often that you'll want or need to work directly with the raw data. Instead, you'll usually work with data that has been massaged in one or both of the following ways:

• The data has been sorted on one or more fields.

• The data has been filtered to show only a relevant subset of the records.

The combination of sorting and filtering is at the heart of one of the most powerful concepts in all of Access: queries. Queries are no great mystery, really. ...