Exam 3: Creating Queries

A(n) mirror field is a field that appears in both tables, has the same data type, and contains the same values.

A query is a database object that lets you ask the database about the data it contains.

The ____ operator selects records that match all of two or more conditions in a query.

When you need to sort data first based on the values in one field, and then by the values in a second field, you can set the sort orders for the two fields using the ____ in the design grid.

Case AC 3-2 Eric is learning how to create calculated fields. Eric notices that Access named the first expression in his query "Expr" and a number (in this case, 1) to indicate the first expression in the query. What can Eric do to change this name?

Queries that are based on more than one table are sometimes called ____ queries.

A summary query shows every field in each record.

In a one-to-many relationship, one record in the first table (called the ____ table) can match many records in the second table (called the related table).

FIGURE AC 3-1 To access the dialog box shown in Figure AC 3-1 above, you first have to access the ____.

After applying any filter to a field, clicking the ____ button in the Sort & Filter group on the Home tab removes it and displays all records again.

A filter temporarily displays records in a datasheet based on the condition that you specify.

When you relate tables, Access uses a set of rules to ensure that there are matching values in the common field used to form the relationship, both at the time you create the relationship and as you enter data in the tables after you create the relationship. This set of rules is called ____.

Case AC 3-1 Danielle is a Sales Manager and is troubleshooting why profits are down. Danielle leaves for lunch and when she gets back she has forgotten what her last sort was. She notices a small down arrow in the Pricing field of her product datasheet which indicates a ____ sort order.

When the condition has two or more parts to it, such as customers who have ordered a specific part and live in a certain zip code, the two conditions are called ____________________.

To use____, click the Advanced button in the Sort & Filter group on the Home tab. In the menu that opens, click Filter By Form.

A relationship is a way of telling the query which data you are interested in seeing.

To add a condition to a field, click in the field's Criteria box, and then type the condition.

A matching field is also called a mirror field because it is common in both tables involved in the relationship.

You must add fields in a certain order to the design grid.

FIGURE AC 3-1 You use the Tables/Queries arrow in the dialog box shown in Figure AC 3-1 above to select the ____ that contains the data you want your new query to display.