Question 1

The default name for a new Access query is ____________________.

Accepted Answer

The answer of The default name for a new Access...

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

The condition "Seattle" for the field City in a student database is an example of what type of value?

Accepted Answer

A) text value 
B) field value 
C) comparison value 
D) criteria value

Question 4

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Accepted Answer

A) Tab 
B) Home + Up Arrow 
C) Up Arrow 
D) Ctrl+Home

Question 5

Which comparison operator matches a pattern that includes wildcards?

Accepted Answer

A) Between...And... 
B) Or 
C) Not 
D) Like

Question 6

The ____ command removes the display of one or more fields in Datasheet view.

Accepted Answer

A) Hide Fields 
B) Unhide Fields 
C) Remove Fields 
D) Display Fields

Question 7

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Accepted Answer

The answer of Typing a value in a highlighted field...

Question 8

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

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

Question 9

The most simple technique to use for filtering records is Filter By Form.____________________

Accepted Answer

A) True 
 B)False

Question 10

Data may be sorted in a table datasheet,a form,and a ____.

Accepted Answer

A) report 
B) query datasheet 
C) record 
D) related table

Question 11

When the sort field data for each record in a database is different,the sort field is ____.

Accepted Answer

A) ascending 
B) unique 
C) nonunique 
D) descending

Question 12

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

Accepted Answer

A) leftmost 
B) rightmost 
C) adjacent to the leftmost field 
D) adjacent to the rightmost field

Question 13

Date criteria are automatically enclosed in ____ when entered in a query design.

Accepted Answer

A) quotes 
B) parenthesis 
C) brackets 
D) number signs

Question 14

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

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

Question 15

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

Exam 3: Maintaining and Querying a Database

The default name for a new Access query is ____________________.

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

The condition "Seattle" for the field City in a student database is an example of what type of value?

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Which comparison operator matches a pattern that includes wildcards?

The ____ command removes the display of one or more fields in Datasheet view.

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

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 most simple technique to use for filtering records is Filter By Form.____________________

Data may be sorted in a table datasheet,a form,and a ____.

When the sort field data for each record in a database is different,the sort field is ____.

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

Date criteria are automatically enclosed in ____ when entered in a query design.

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 predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.