Exam 8: Using Advanced Queries

You double-click ____ in the New Query dialog box to display the Crosstab Query Wizard dialog box.

When you run a parameter query, it displays a ____.

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for ____ data.

When creating an append query, you place the mouse pointer over the first field in the highlighted fields, press and hold down the mouse button, and drag them to ____ in the query design grid.

When you save a parameter query, you can add ____ before the query name to easily recognize it as a query in a list.

Using parallel tables that have a common field allows you to display information from more than one table.

You can undo changes made with an update action query.

Typically records in a table appear in rows, and the columns display the information for the field.

You can run a query by ____.

Figure AC 8-1 In Figure AC 8-1 above, item 1 points to the area illustrating ____.

Each time you run a parameter query, you can type a different criterion in the text box.

You run a query by right-clicking the query in the Navigation pane.

The word append means to ____.

Case Access 8-2 Betty is an assistant at the local pet shelter. She uses an Access database to store information about people who have adopted a pet, dropped off pets, or those who have contributed money and supplies to the shelter. While preparing for a fundraising event for the shelter, she recalls a donor whom she would like to contact but cannot recall the donor's name. However, she is certain it ends in the letters "son". By using ____, Betty will be able to enter only the criterion that she is certain of in a provided message box.

A(n) ____________________ character is a character, such as an asterisk, that you can use to represent incomplete or unknown information.

You ____ the empty field to the right of the Description field in the design grid to display the shortcut menu.

To display the Query Design window, click the ____ tab and then click the Query Design button in the Queries group.

You use a query to ask Access a question.

____________________ refers to the specific information you are searching for.

Parameter queries provide a single query that you may use many times .