Skip to Main Content
Microsoft® Office Access 2003 Step by Step
book

Microsoft® Office Access 2003 Step by Step

by Online Training Solutions Inc.
August 2003
Beginner content levelBeginner
368 pages
10h 49m
English
Microsoft Press
Content preview from Microsoft® Office Access 2003 Step by Step

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Access 2003 Inside Out

Microsoft® Office Access 2003 Inside Out

John L. Viescas

Publisher Resources

ISBN: 0735615179Supplemental ContentCatalog PageErrata