Chapter 34. Using Queries
When you run a query, you are asking the database for specific information that you’d like to view and/or edit. The query is the question. Access responds by showing the data you’ve asked for in a datasheet (Figure 34.1), where you can view, sort, or filter the data. If you edit the data in the datasheet, the table on which it is based will also be modified. Each query you create can be saved so that you can reuse the query.
Figure 34.1. A query result in a datasheet.
Although the most common type of query is a select query, which displays the results of the query in a datasheet, you can also use action queries, which enable ...
Get Microsoft Office XP for Windows: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
