Exam 3: Access Lesson 3: Creating Queries

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

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

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

A(n) ____________________ query lets you summarize relevant data, such as adding the field values in a column that stores price data.

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

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

Case AC 3-1 Danielle is a Sales Manager and is troubleshooting why profits are down. Danielle wants to see which items are the least profitable. She chooses the Profitability field of her product datasheet and clicks the ____ button.

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.

The ____ symbol next to a field name in a field list indicates the table's primary key.

A summary query shows every field in each record.

When you run a query, the data in the table on which the query is based no longer exists in the table.

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.

You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.

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 ____.

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).

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

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

Sorting a field in ascending order arranges records from Z to A, or largest to smallest.

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

Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.