Question 1

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 2

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 3

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 key on the keyboard is the shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Question 4

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 5

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

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

Question 6

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

The answer of Identify the letter of the choice that...

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

Comparison operators are used to compare the value in a field to a specific condition value and select all records for which the condition is true. The most common comparison operators are = (equal to), < (less than), > (greater than), <= (less than or equal to), >= (greater than or equal to), and <> (not equal to).

Question 8

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 9

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 option that best matches the given phrase or definition is "sort field." This field is used to determine the order of records in a datasheet. The other options listed are unrelated to this concept.

Question 10

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 perform operations such as sum, average, minimum, and maximum on selected records in a database.

Question 11

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

A select query is a type of query in which you specify the fields and records you want Access to select.

Question 12

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 13

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 14

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 dialog box that allows one to enter text, expressions, or other values is commonly known as an Input Box, not Zoom Box.

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 two or more conditions in a query or formula.

Quiz 3: Maintaining and Querying a Database

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 ____________________ is a set of records that answers the question resulting from a query.

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.

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

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.

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.

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. -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. -Functions that perform arithmetic operations on selected records in 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.

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

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. -A dialog box used to enter text,expressions,or other values.

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.