Special Edition Using Microsoft® Access 2000

Chapter 8. Designing Access Queries

In this chapter

• Introducing Queries

• Trying the Simple Query Wizard

• Using the Query Design Window

• Selecting Fields for Your Query

• Selecting Records by Criteria and Sorting the Display

• Creating More Complex Queries

• Changing the Names of Query Column Headers

• Printing Your Query as a Report

• Using the Data from Your Query

• Creating and Using a Simple Make-Table Action Query

• Adding a Parameter to Your Make-Table Query

• Troubleshooting

• In the Real World—Query Design Optimization

Introducing Queries

Queries are an essential tool in any database management system. You use queries to select records, update tables, and add new records to tables. Most often you use queries to select specific groups of records that meet criteria you specify. ...