Queries

In Access 2000 queries may seem confusing at first. This free lesson offers step-by-step instructions on how to run them.

What is a query?

In previous lessons, you learned to work with database objects such as tables and forms. A query is another type of database object.

A query is data resulting from questions you ask of one or more tables. For example, let's say you want to find out how many male students are in Mr. Emerson's class.

Students in Mr. Emerson's class

Male students in Mr. Emerson's class