Question 1

Match between columns
                        Premises: When a field displays a value that is calculated using other fields in the query, it is called a(n) ____.
Menu that opens when you click the arrow on the right side of a field selector.
When you are viewing a table or query datasheet, you can use the ____ to count the number of values in a column.
A calculation of more than one field is called a(n) ____.
The common field in the related table is called a(n) ____ when it is used in a relationship.

Accepted Answer

The Answer of Calculated field and Total row and Foreign is...

Question 2

A query can contain ____ of the fields in the table.

Accepted Answer

A)  one 
B)  some 
C)  all 
D)  all of the above

Question 3

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

Accepted Answer

The answer of A(n) ____________________ query lets you summarize relevant...

Question 4

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.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of Sorting a field in ____________________ order arranges...

Question 6

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?

Accepted Answer

A)  Click the empty Field box in the design grid, and then click Zoom on the shortcut menu. 
B)  Click the empty Field box in the design grid, and then click Show All on the Ribbon. 
C)  Either a. or b. 
D)  Neither a. nor b.

Question 7

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

Accepted Answer

A)  Or 
B)  And 
C)  Plus 
D)  Either

Question 8

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

Accepted Answer

A)  relationship line 
B)  help line 
C)  join line 
D)  match line

Question 9

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.

Accepted Answer

A)  Data 
B)  Formulas 
C)  Query 
D)  Sort & Filter

Question 10

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.

Accepted Answer

The answer of Briefly describe Filter by Selection and Filter...

Question 11

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.

Accepted Answer

A)  Filter By Selection 
B)  Filter By Form 
C)  Filter by Query 
D)  Filter by Value

Question 12

Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.

Accepted Answer

A)  complex condition 
B)  multi-field condition 
C)  simple condition 
D)  range-of-values condition

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of To create a(n) ____________________ between two tables,...

Question 15

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.

Accepted Answer

A)  Ascending 
B)  Descending 
C)  Selection 
D)  Advanced

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  save 
B)  run 
C)  move 
D)  engage

Question 18

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

Accepted Answer

A)  Database Tools 
B)  Relationship 
C)  Data 
D)  Format

Question 19

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.

Accepted Answer

A) True 
 B)False

Question 20

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.

Accepted Answer

A)  Create Query Wizard 
B)  Easy Query Wizard 
C)  Simple Query Wizard 
D)  Complex Query Wizard

Exam 3: Creating Queries

Identify the letter of the choice that best matches the phrase or definition.

A query can contain ____ of the fields in the table.

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

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.

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

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?

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

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

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.

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.

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.

Another type of condition that you can create causes a record to be displayed in the query datasheet when the record matches a range of values. This is called a ____.

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

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

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.

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

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

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

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.

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.