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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

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.