Exam 3: Access Lesson 3: Creating Queries

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.

A(n) AutoFilter is a menu that opens when you click the arrow on the right side of a field selector. The menu contains options for sorting data and clearing any filters that you have already applied.

You can run the query by clicking the Run button in the ____ group on the Query Tools Design tab.

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

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

When you open a query object, you ____ the query.

After you add two related tables to the query design, a ____ shows the relationship between the tables.

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.

An easy way to create a query is to use the ____, which asks you what data you want to see by letting you select options in dialog boxes.

Case AC 3-2 Eric is learning how to create calculated fields. Eric is typing one of his expressions and notices that Excel only displays the first 20 characters. What can Eric do to display the entire field?

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

The Query window is divided into three parts. The middle part of the window contains a navigation pane that allows you to specify the fields to include in the query datasheet.

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

____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.

To create a(n) ____________________ between two tables, you must design the tables so they contain a common field.

In the Query Design window, you build and change the query using the query design grid.

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

To create a relationship between tables, click the ____ tab on the Ribbon. In the Relationships group, click the Relationships button.

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

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