Question 1

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 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.
- 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 arithmetic operations on selected records in a database, such as finding the average, minimum, or maximum value in a set of data.

Question 4

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 are used to combine two or more conditions in queries or programming languages. Examples of logical operators include AND, OR, and NOT.

Question 5

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 used to enter text or values would be the Zoom box, as it allows the user to zoom in and enter information in a specific area of the screen. The other choices are not related to this definition.

Question 6

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 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 condition value and select records for which the condition is true.

Question 8

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 9

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 10

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 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

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 12

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 13

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 14

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 15

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

Accepted Answer

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

Quiz 3: Maintaining and Querying a Database

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

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

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.

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.

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 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. - 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. - 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

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 first field specified in the sorting process is called the ____________________ field.