Free E-Books

The database query performed the work of assembling all the information
for you. Figure 4-3 shows the resulting datasheet.
125
Selecting Data with Queries 4
FIGURE 4-2
A more complex query returning customers that purchased more than one car in 2007.
FIGURE 4-3
The resulting datasheet of the query shown in Figure 4-2.
Types of queries
Access supports many different types of queries, grouped into six basic categories:
n Select: These are the most common types of query. As its name implies, the select query
selects information from one or more tables, creating a recordset. Generally speaking, the
data returned by select query is updatable and is often used to populate forms and
reports.
n Total: These are special type of select queries. Total queries provide sums or other calculations
(such as count) from the records returned by a select query. Selecting this type of
query adds a Total row in the QBE (Query by Example) grid.
n Action: These queries enable you to create new tables (Make Tables) or change data
(delete, update, and append) in existing tables.


Pages:
397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421