Question 1

A join line is also called a(n) ____ line.
A) query
B) link
C) connection
D) objectivity

Accepted Answer

A join line is also referred to as a link line, as it represents the connection or relationship between tables in a database. A query refers to a specific request for information from a database, a connection refers to the means by which two systems or applications communicate with each other, and objectivity refers to the absence of bias or personal opinion.

Question 2

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?
A) 0
B) Is Not Null
C) *=*
D) * *

Accepted Answer

The criteria "Is Not Null" will find all records where there is any entry in the field, even if the entry is 0.

Question 3

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.
A) query
B) objectivity
C) connection
D) link

Accepted Answer

The line with the infinity sign at one end and the numeral 1 at the other is a link, as it represents a continuous connection between two objects or elements.

Question 4

To move a field in the query design grid, click its ____, and then drag it left or right.
A) field selector
B) field key
C) field string
D) field tag

Accepted Answer

To move a field in the query design grid, you need to click on its field selector which is the small gray box at the left of each field name and then drag it left or right to adjust its position within the query.

Question 5

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.
A) Criteria
B) Filters
C) Queries
D) none of the above

Accepted Answer

Criteria are the specific tests or limiting conditions set to determine which records will be selected in a filter or query. Filters and queries are broader terms that encompass the use of criteria to search and select records.

Question 6

The wildcard character that stands for any group of characters is the ____.
A) period (.)
B) semicolon (;)
C) asterisk (*)
D) plus sign (+)

Accepted Answer

The asterisk (*) is the wildcard character that stands for any group of characters, including zero characters.

Question 7

____ will find all records where there is any entry in the field, even if the entry is 0.
A) Like
B) Is Null
C) And
D) Is Not Null

Accepted Answer

The "Is Not Null" operator will find all records where there is any entry in the field, even if the entry is 0. The "Is Null" operator would exclude records with a value of 0. The "Like" and "And" operators are not relevant to this scenario.

Question 8

The accompanying figure shows the query in ____ View.
A) Criteria
B) Design
C) Field
D) None of the above

Accepted Answer

The Design view is used to build and modify queries in Access. It allows the user to specify the tables and fields to include in the query, set criteria, and define relationships between tables.

Question 9

When you double-click a field in a field list in Query Design View, it is ____.
A) deleted from the query
B) added to the next available position in the query design grid
C) used as the first sort order
D) set as the primary key field

Accepted Answer

Double-clicking a field in a field list in Query Design View adds the field to the next available position in the query design grid.

Question 10

In the accompanying figure, StateName and StateAbbreviation appear in the States ____ list.
A) title
B) field
C) category
D) entry

Accepted Answer

StateName and StateAbbreviation are fields within the States list.

Question 11

The ____ button provides a list of values in the selected field that can be used to customize a filter.
A) Values
B) Selection
C) Filter
D) Advanced

Accepted Answer

The answer of The ____ button provides a list of...

Question 12

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.
A) filter
B) query
C) grid
D) sort

Accepted Answer

A filter creates a temporary view of the data by hiding or showing certain records based on specific criteria. This temporary view is removed when the datasheet is closed. A query, on the other hand, is a saved set of instructions that can be used to retrieve specific data from one or more tables. A grid refers to the table or datasheet itself, and a sort rearranges the data in a specific order but does not create a temporary view.

Question 13

Use the ____ command to save the current object with a new name.
A) Datasheet
B) View
C) Save As
D) Save

Accepted Answer

The "Save As" command is used to save the current object with a new name, allowing the user to create a new version or copy of the object without modifying the original. The other options (Datasheet, View, Save) do not directly relate to renaming or creating copies of objects.

Question 14

The top button in the accompanying figure ____.
A) sorts records in descending order
B) sorts records in ascending order
C) helps you select a single record or all records in a datasheet
D) removes the current sort order

Accepted Answer

The answer of   The top button in the...

Question 15

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.
A) Comparative
B) Selection
C) Comparison
D) Advanced

Accepted Answer

The selection button is the most appropriate answer as it is commonly used to filter records based on a specific criterion, such as equal to, not equal to, greater than, or less than. The other options, such as comparative and comparison, can be confusing and may not adequately describe the function of the button. The advanced button may also be used for filtering, but it is not typically the primary option for basic filtering tasks.

Question 16

In the accompanying figure, StateName and Price are ____ names.
A) table
B) report
C) field
D) query

Accepted Answer

StateName and Price are individual pieces of data within the table, making them field names.

Question 17

Criteria ____ is the term for rules by which criteria must be entered in a query.
A) Syntax
B) Formatting
C) Sorting
D) Filter by Form

Accepted Answer

Syntax refers to the specific rules and structure required for entering criteria in a query. It includes proper formatting and punctuation, as well as the correct use of keywords and operators. Choosing the right syntax is essential for running a successful query.

Question 18

The bottom button in the accompanying figure ____.
A) sorts records in descending order
B) sorts records in ascending order
C) helps you navigate to the first, previous, next, last, or new record
D) removes the current sort order

Accepted Answer

The bottom button in the figure helps you navigate to the first, previous, next, last, or new record. The other options are not related to this particular button as they are related to sorting records.

Question 19

A(n) ____ is a saved object within the datasheet.
A) query
B) filter
C) find
D) union

Accepted Answer

A query is a saved object within the datasheet that allows for the execution of specific actions on the data, such as filtering, sorting, or calculating. Options B, C, and D are not saved objects within the datasheet, but rather refer to specific actions that can be taken on data within a datasheet.

Question 20

The wildcard character that stands for any single character is the ____.
A) ampersand (&)
B) question mark (?)
C) exclamation mark (!)
D) caret (^)

Accepted Answer

The question mark is used as a wildcard character to represent any single character in a search or pattern matching operation.

Quiz 2: Building and Using Queries

A join line is also called a(n) ____ line.

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

To move a field in the query design grid, click its ____, and then drag it left or right.

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

The wildcard character that stands for any group of characters is the ____.

____ will find all records where there is any entry in the field, even if the entry is 0.

The accompanying figure shows the query in ____ View.

When you double-click a field in a field list in Query Design View, it is ____.

In the accompanying figure, StateName and StateAbbreviation appear in the States ____ list.

The ____ button provides a list of values in the selected field that can be used to customize a filter.

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

Use the ____ command to save the current object with a new name.

The top button in the accompanying figure ____.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

In the accompanying figure, StateName and Price are ____ names.

Criteria ____ is the term for rules by which criteria must be entered in a query.

The bottom button in the accompanying figure ____.

A(n) ____ is a saved object within the datasheet.

The wildcard character that stands for any single character is the ____.