Question 1

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.

Accepted Answer

To display the entire field when Excel shows only the first 20 characters, Eric can click the empty Field box in the design grid and then click Zoom on the shortcut menu. This action enlarges the view so he can see the entire expression. Option B is incorrect because there is no "Show All" option on the Ribbon for this purpose in Excel.

Question 2

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

Accepted Answer

The sort boxes in the design grid allow you to set the sort order for each field in the query. By selecting the appropriate sort boxes, you can ensure that the data is organized first by one field and then by a second field, if necessary. The other choices listed (grid boxes, field boxes, and text boxes) do not specifically relate to setting sort orders in a query.

Question 3

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

Accepted Answer

The key symbol is commonly used to indicate the primary key in database field lists.

Question 4

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

Accepted Answer

Clicking the "Toggle Filter" button in the Sort & Filter group on the Home tab removes any applied filter and displays all records again.

Question 5

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

Accepted Answer

The answer of When the condition has two or more...

Question 6

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

Accepted Answer

The Or operator is used in SQL to select records that meet at least one of two or more conditions. This allows for more flexibility in querying the database and retrieving the necessary data.

Question 7

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

Accepted Answer

The New Query dialog box allows you to create a query and access the dialog box shown in Figure AC 3-1. The Simple Query menu and gallery are options within the dialog box. The New Query Datasheet is not relevant to accessing the dialog box in Figure AC 3-1.

Question 8

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

Accepted Answer

Referential integrity ensures that each record in the related table has a matching value in the common field with at least one record in the primary table, preventing orphaned records and maintaining data consistency. It is a key feature of database design and helps ensure accurate query results and reports. The other choices are not accurate in describing this set of rules.

Question 9

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

Accepted Answer

In a one-to-many relationship, the first table is referred to as the "primary" table because one record in the primary table can be associated with one or more records in the related table.

Question 10

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.

Accepted Answer

The Tables/Queries arrow in the dialog box allows you to select either a table or a query to use as the data source for your new query. It gives you the flexibility to choose either option depending on your needs.

Question 11

A query can contain ____ of the fields in the table.
A) one
B) some
C) all
D) all of the above

Accepted Answer

A query can be designed to include one, some, or all of the fields in a table, depending on the specific requirements of the query.

Question 12

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

Accepted Answer

The down arrow indicates a descending sort order, which means the highest values in the Pricing field are displayed first. This could be a possible reason for the lower profits if the higher priced products are not selling well.

Question 13

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

Accepted Answer

When two related tables are added to the query design, a join line shows the relationship between the tables. The join line indicates which fields in each table are being used to link the data together.

Question 14

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

Accepted Answer

A range-of-values condition (also known as a Between condition) is used to display records that fall within a specified range of values, such as a range of dates or a range of prices. It is a type of simple condition.

Question 15

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

Accepted Answer

The Run button is located in the Results group on the Query Tools Design tab in Microsoft Access.

Question 16

The ____ operator selects records that match all of two or more conditions in a query.
A) Or
B) And
C) Either
D) Plus

Accepted Answer

The "And" operator is used to select records that match all conditions specified in a query. The "Or" operator is used to select records that match any one of multiple conditions. "Either" and "Plus" are not appropriate operators in this context.

Question 17

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

Accepted Answer

The correct choice is "Database Tools" because in Microsoft Access, to create or manage relationships between tables, you use the Database Tools tab on the Ribbon. From there, you can access the Relationships group and click the Relationships button to view, create, or modify relationships.

Question 18

Queries that are based on more than one table are sometimes called ____ queries.
A) multitable
B) many table
C) subtable
D) double table

Accepted Answer

Multitable queries involve combining data from multiple tables in a database to extract information or make changes to the data. This can be done using JOIN statements in SQL.

Question 19

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

Accepted Answer

To find the least profitable items, sorting the Profitability field in ascending order will display the items with the lowest profit first, making it easier to identify them.

Question 20

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

Accepted Answer

Eric can change the name of the calculated field by double-clicking on the name (in this case, Expr1) and typing in the desired name, then pressing the Tab key to confirm the change. This will also update the name in the formula bar.

Quiz 3: Access Lesson 3: Creating Queries

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

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.

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 ____ operator selects records that match at least one of two or more conditions in a query.

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

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

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 query can contain ____ of the fields in the table.

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.

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

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

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

The ____ operator selects records that match all 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.

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

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.

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?