Special Edition Using Microsoft® Office Access 2003

Chapter 9. Designing Queries for Jet Databases

In this chapter

• Introducing Jet Queries

• Trying the Simple Query Wizard

• Using the Query Design Window

• Creating Other Types of Queries

• Troubleshooting

• In the Real World—Optimizing Query Design

Introducing Jet Queries

Queries are an essential tool in any database management system. You use queries to select records, and add, update, and delete records in tables. Most often you use queries to select specific groups of records that meet criteria you specify. You can also use queries to combine information from different tables, providing a unified view of related data items. In this chapter, you learn the basics of creating your own select queries, including specifying selection criteria and using the results ...