O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exploring Queries

One way you can locate information in an Access database is to create queries. You use queries to locate information so that you can view, change, or analyze it in various ways. You can also use the results of queries as the basis for other Access objects.

A query is essentially a question. For example, you might ask, "Which records in the Customer table have the value 98052 in the Postal Code field?" When you run a query (the equivalent of asking a question), Access looks at all the records in the table or tables you have specified, finds those that match the criteria you have defined, and displays them in a datasheet.

For Access to be able to answer your questions, you have to structure queries in a specific way. Each type of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required