Deck 3: Access Lesson 3: Creating Queries

Question 1

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.

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

Answer 1

A

Question 2

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) Filter By Selection
B) Filter By Form
C) Filter By Query
D) Filter By Value

Answer 2

B

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

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

Question 7

A summary query shows every field in each record.

Question 8

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

Question 9

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

Question 10

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) Data
B) Formulas
C) Query
D) Sort & Filter

Question 11

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

Question 12

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.

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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.

Question 17

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

Question 18

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.

Question 19

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.

Question 20

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.

Question 21

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?

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 22

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.

A) Grid boxes
B) Field boxes
C) Sort boxes
D) Text boxes

Question 23

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

A) plus sign
B) lock
C) number 1
D) key

Question 24

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) Move Filter
B) Toggle Filter
C) Query Filter
D) Select Filter

Question 25

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

Question 26

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

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

Question 27

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

A) Simple Query menu
B) New Query dialog box
C) Simple Query gallery
D) New Query Datasheet

Question 28

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

A) referential integrity
B) security rules
C) match conditions
D) field rules

Question 29

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) main
B) primary
C) first
D) match

Question 30

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) table
B) query
C) either a. or b.
D) neither a. nor b.

Question 31

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

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

Question 32

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.

A) Ascending
B) Descending
C) Random
D) Multivalued

Question 33

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

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

Question 34

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

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

Question 35

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

A) Query
B) Results
C) Total
D) Data

Question 36

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

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

Question 37

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

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

Question 38

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

A) multitable
B) many table
C) subtable
D) double table

Question 39

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.

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

Question 40

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?

A) Eric cannot change the name.
B) In the calculated field, double-click the text Expr1, type the new text, and press the Tab key.
C) In the formula bar, double-click the text Expr1, type the new text, and enter Ctrl+Enter to replace the text.
D) None of the above

Question 42

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

Question 43

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.

Question 44

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

Question 45

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

Question 46

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