Question 1

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" allow you to set the sort order for each field in the design grid. By selecting a field and then choosing either "Ascending" or "Descending" in the "Sort boxes," you can specify how data should be sorted in that field. By setting the sort order for multiple fields, you can sort data based on multiple criteria.

Question 2

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 3

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 4

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 answer of You can run the query by clicking...

Question 5

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 next to a field name in a field list indicates the table's primary key.

Question 6

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 allows you to select either a table or a query that contains the data you want to display in your new query. Therefore, the best choice is either a table or a query (choice C).

Question 7

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 8

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 9

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 the filter applied to a field and displays all records. The other options listed (Move Filter, Query Filter, Select Filter) do not describe this action.

Question 10

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 when we want to retrieve all records that meet at least one of the conditions specified in the query.

Question 11

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 small down arrow in the Pricing field of her product datasheet indicates a descending sort order, meaning the products are sorted with the highest prices at the top and the lowest prices at the bottom.

Question 12

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 dialog box shown in Figure AC 3-1 is the New Query dialog box, which is accessed before creating a new query. The Simple Query menu and gallery are parts of the Query Design interface, while the New Query Datasheet is a view option within an already created query.

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

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 15

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 selects records that match all of two or more conditions in a query. The Or operator, on the other hand, selects records that match any of two or more conditions in a query. The Either and Plus operators are not recognized query operators.

Question 16

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 17

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

The set of rules used to ensure matching values in a common field is called referential integrity. This ensures that data relationships are maintained and that any changes made to related data are consistent across all related tables.

Question 18

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 allows a record to be displayed in the query datasheet when the record matches a range of values. This is achieved by setting criteria using comparison operators such as "between" or ">= and <=".

Question 19

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 more than one table and are used to retrieve data from related tables in a database. This type of query helps to provide more comprehensive data and allows for more complex analysis. The other options (B, C, D) are not commonly used terms to refer to queries involving multiple tables.

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 expression by simply double-clicking the "Expr1" and typing the desired name. Pressing the Tab key will save the new name.

Quiz 1: Microsoft Access Basics

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.

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

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

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

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

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 wants to see which items are the least profitable. She chooses the Profitability field of her product datasheet and clicks the ____ button.

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.

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

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.

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

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

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

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

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

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

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?