Question 1

Identify the letter of the choice that best matches the phrase or definition.
-A type of query in which you specify the fields and records you want Access to select.

Accepted Answer

The term "select query" specifically refers to a type of query in which you specify the fields and records you want Access to select.

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Accepted Answer

Ctrl + End is a keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Question 3

Identify the letter of the choice that best matches the phrase or definition.
-A criterion or rule that determines which records are selected when a query is run.

Accepted Answer

A condition is a criterion or rule that determines which records are selected when a query is run.

Question 4

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Accepted Answer

The answer of The arrangement of records sorted in a...

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

Accepted Answer

A theme is a predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

Question 6

Identify the letter of the choice that best matches the phrase or definition.
-A dialog box used to enter text,expressions,or other values.

Accepted Answer

A zoom box allows users to enter text or values. A dialog box is a type of window that can be used to display various types of information or prompts for user input, but it is not necessarily specific to entering text or values. The other answer choices are not relevant to the given definition.

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

Accepted Answer

The comparison operator is used to compare the value in a field to the condition value and selects all records for which the condition is true.

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-Functions that perform arithmetic operations on selected records in a database.

Accepted Answer

Aggregate functions are used to perform arithmetic operations (such as sum, average, min, max, etc.) on selected records in a database.

Question 9

The ascending sort order for the Date/Time data type sorts dates from ____________________.

Accepted Answer

The answer of The ascending sort order for the Date/Time...

Question 10

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

Accepted Answer

The answer of A set of restrictions placed on records...

Question 11

Identify the letter of the choice that best matches the phrase or definition.
-The field used to determine the order of records in a datasheet.

Accepted Answer

The sort field is used to determine the order of records in a datasheet.

Question 12

Identify the letter of the choice that best matches the phrase or definition.
-The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Accepted Answer

The Home button moves the insertion point left to the first field value in a record when in navigation mode.

Question 13

A ____________________ is a set of records that answers the question resulting from a query.

Accepted Answer

The answer of A ____________________ is a set of records...

Question 14

The first field specified in the sorting process is called the ____________________ field.

Accepted Answer

The answer of The first field specified in the sorting...

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-Operators that allow two or more conditions to be combined such as And.

Accepted Answer

Logical operators, such as And, allow for the combination of multiple conditions to form a more complex query.

Quiz 3: Maintaining and Querying a Database

Identify the letter of the choice that best matches the phrase or definition. -A type of query in which you specify the fields and records you want Access to select.

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Identify the letter of the choice that best matches the phrase or definition. -A criterion or rule that determines which records are selected when a query is run.

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Identify the letter of the choice that best matches the phrase or definition. -A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.

Identify the letter of the choice that best matches the phrase or definition. -A dialog box used to enter text,expressions,or other values.

Identify the letter of the choice that best matches the phrase or definition. -The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

Identify the letter of the choice that best matches the phrase or definition. -Functions that perform arithmetic operations on selected records in a database.

The ascending sort order for the Date/Time data type sorts dates from ____________________.

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

Identify the letter of the choice that best matches the phrase or definition. -The field used to determine the order of records in a datasheet.

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

A ____________________ is a set of records that answers the question resulting from a query.

The first field specified in the sorting process is called the ____________________ field.

Identify the letter of the choice that best matches the phrase or definition. -Operators that allow two or more conditions to be combined such as And.