Question 1

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 (*) represents any group of characters in wildcards.

Question 2

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 that must be followed when inputting criteria in a query. It includes the use of keywords, operators, and punctuation in the correct order and format. Formatting, sorting, and Filter by Form do not specifically relate to the rules for entering criteria in a query.

Question 3

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

"Is Not Null" will find all records where the field has any entry, even if it's 0. The other options will not necessarily include records with a 0 in the field.

Question 4

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

When you double-click a field in a field list in Query Design View, it is added to the next available position in the query design grid.

Question 5

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 is a temporary view of the data in a datasheet that is removed when the datasheet is closed or when the filter is removed. A query creates a new datasheet based on specific criteria, a grid is another term for a datasheet, and a sort rearranges the data in a specific order but does not create a temporary view.

Question 6

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

The field selector is the small grey box located to the left of the field name in the query design grid, clicking and dragging it left or right allows you to move the field to the desired position in your query.

Question 7

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 the wildcard character that stands for any single character in most computer systems and programming languages. This means that if you use the question mark as part of a search query, it will match any single character.

Question 8

To sort records based on the selected field in the order Z to A, use the _____ button.
A) Down
B) Descending
C) Z to A
D) Reverse Sort

Accepted Answer

The Descending button will sort the records based on the selected field in reverse alphabetical order (Z to A). The Down button only moves the cursor down to the next record, while the Z to A and Reverse Sort options do not exist in common sorting functions.

Question 9

Which of the following comparison operators means "greater than"?
A) >
B) >=
C) >>
D) <=

Accepted Answer

The ">" symbol means "greater than" in comparison operations.

Question 10

Which of the following comparison operators means "not equal to"?
A) +=+
B) =/=
C) >
D)<>

Accepted Answer

The operator "<>" is used to indicate "not equal to" in most programming languages, including SQL and VBA.

Question 11

Access saves ____ automatically as you move from record to record.
A) data
B) queries
C) tables
D) all of the above

Accepted Answer

Access saves data automatically as you move from record to record. It does not automatically save queries or tables.

Question 12

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 question is referring to the filter button in a database or spreadsheet program. This button allows the user to filter records based on certain criteria, such as only showing records that equal a certain value or do not equal a certain value. This button is commonly referred to as the "Selection" button as it allows the user to select which records to display based on certain criteria. The other choices (A, C, and D) do not accurately describe this functionality.

Question 13

To find numbers greater than or equal to 500, use which comparison operator?
A) =
B) =/=
C) >>
D) >=

Accepted Answer

The comparison operator >= means "greater than or equal to", so using it will include numbers that are equal to 500 as well as those that are greater than 500.

Question 14

____ 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

"Is Not Null" will find all records where there is any entry in the field, regardless of whether the entry is a number, text or even zero.

Question 15

Query Design View presents the fields you can use for a query in small windows called field ____.
A) glossaries
B) lists
C) links
D) catalogs

Accepted Answer

Query Design View presents the fields you can use for a query in small windows called field lists.

Question 16

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

Accepted Answer

A join line is commonly referred to as a link line as it connects two tables or data sources together.

Question 17

____ 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 that you set to define which records will be chosen in a filter or query. Filters are the mechanism that enables you to implement those criteria, and queries are higher-level expressions that allow you to perform more complicated operations.

Question 18

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 19

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 allows you to save a copy of the current object with a new name, while keeping the original object intact. This can be useful for creating similar objects with minor modifications, without having to recreate the entire object from scratch.

Question 20

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 a datasheet that can be used to search for specific information within the data. A filter is a temporary view of a subset of data, not a saved object. "Find" is a feature within a program to search for specific information. "Union" is a database operation that combines the results of two or more SELECT statements into a single result set. Therefore, A) Query is the best choice for the given question.

Quiz 2: Building and Using Queries

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

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

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

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

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

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

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

To sort records based on the selected field in the order Z to A, use the _____ button.

Which of the following comparison operators means "greater than"?

Which of the following comparison operators means "not equal to"?

Access saves ____ automatically as you move from record to record.

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

To find numbers greater than or equal to 500, use which comparison operator?

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

Query Design View presents the fields you can use for a query in small windows called field ____.

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

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

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

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

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