As you learned in the previous lesson, Access offers many ways to help you narrow down the information you're looking at, including sorting and filtering. The most flexible way to sort and filter data, however, is using a query.
A query is a question that you pose to a database table or tables. For example, you might want to know which of your customers live in a specific state or how many of your salespeople have reached a particular sales goal. The great thing about queries is that you can save queries and use them to create tables, delete records, or copy records to another table.
Queries enable you to specify
Query A query enables you to "question" your database using different criteria that can sort, filter, and summarize table data.
Queries are a powerful tool for analyzing and summarizing database information. In this lesson, you take a look at the queries you can create using a wizard. Creating queries in the Design view is covered in Lesson 18, "Creating Queries from Scratch."