Microsoft Office Tutorials and References
In Depth Information
Finally, you’ll test the query and enter S in the dialog box.
7. Switch to Design view, run the query, type S , and then press the Enter key. The
recordset displays the 10 records for customers in Saint Joseph, Saugatuck, and
8. Close the query.
9. If you are not continuing on to the next session, close the Panorama database, and
then exit Access, clicking the Yes button if you are prompted to confirm that you
want to exit Access and to empty the Clipboard.
The queries you created will make the Panorama database easier to use. In the next
session, you will create a top values query and use query wizards to create three addi-
Session 5.1 Quick Check
1. You use the property to specify how a field name appears in
datasheet column headings and in form and report labels.
2. Which comparison operator selects records based on a specific pattern?
3. What is the purpose of the asterisk (*) in a pattern match query?
4. When do you use the In comparison operator?
5. How do you negate a selection criterion?
6. The function returns one of two values based on whether the
condition being tested is true or false.
7. When do you use a parameter query?
Creating a Crosstab Query
Oren wants to analyze his company’s invoices by city, so he can view the paid and
unpaid contract amounts for all customers located in each city. He asks you to create a
crosstab query using the Crosstab Query Wizard to provide the information he needs.
A crosstab query performs aggregate function calculations on the values of one data-
base field and displays the results in a spreadsheet format. Recall that an aggregate func-
tion performs an arithmetic operation on selected records in a database. Figure 5-19 lists
the aggregate functions you can use in a crosstab query. A crosstab query can also dis-
play one additional aggregate function value that summarizes the set of values in each
row. The crosstab query uses one or more fields for the row headings on the left and one
field for the column headings at the top.