Datasheet

Using queries to enhance
forms and reports
Because you can use a query as the basis for an Access form or report, you
now have a powerful tool that enables you to do otherwise impossible things
with those forms and reports. Consider these possibilities:
 You can create a form that’s based on a query that selects records that
fall within specific date ranges. For example, say you want to follow up
with customers who placed an order last year but who haven’t ordered
in several months. Use a query.
Figure 1-6:
Running a
query
results in a
filtered
display that
matches the
specified
criteria.
The table that is the source of the data
The fields that will be included in the results
The criteria used to filter the results
Figure 1-5:
A query
enables you
to choose
records that
meet
specific
criteria.
19
Chapter 1: Getting to Know Forms and Reports
05_046593 ch01.qxp 11/27/06 1:23 PM Page 19