Question 1

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

Accepted Answer

The answer of The _________________ prompts for information by asking...

Question 2

Statistical information such as totals and averages is calculated using ____.

Accepted Answer

A) comparison operators 
B) mathematical operators 
C) aggregate functions 
D) logical functions

Question 3

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 4

Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
-When creating a query to determine which plants need full sun,which fields must be included in the query?

Accepted Answer

A) Plant Name and When to Plant 
B) Amount of Sun and Annual 
C) Plant Name and Amount of Sun 
D) Amount of Sun and When to Plant

Question 5

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 6

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.____________________

Accepted Answer

A) True 
 B)False

Question 7

Fields included in a query may be modified after the query is saved.____________________

Accepted Answer

A) True 
 B)False

Question 8

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

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

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

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 10

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 11

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

Which aggregate function would be used to calculate the lowest field value for the selected records?

Accepted Answer

A) Average 
B) Minimum 
C) Maximum 
D) Count

Question 13

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 14

Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial.  He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
-After creating the query,Jorge must set criteria to have the query return only those plants that need full sun.Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun?

Accepted Answer

A) =>full sun 
B)  full sun 
D) "full sun"

Question 15

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

Accepted Answer

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

Question 16

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 17

A criterion,or rule,that determines which records are selected when a query is run is called a(n)____.

Accepted Answer

A) sort order 
B) condition 
C) operator 
D) match

Question 18

Results of a query are narrowed by using the Or logical operator.____________________

Accepted Answer

A) True 
 B)False

Question 19

A query based on more than one table is a(n)____query.

Accepted Answer

A) multiple 
B) advanced 
C) relationship 
D) multitable

Question 20

Which comparison operator matches a pattern that includes wildcards?

Accepted Answer

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

Exam 3: Maintaining and Querying a Database

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

Statistical information such as totals and averages is calculated using ____.

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

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.____________________

Fields included in a query may be modified after the query is saved.____________________

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. -A type of query in which you specify the fields and records you want Access to select.

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

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

Which aggregate function would be used to calculate the lowest field value for the selected records?

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

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

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

A criterion,or rule,that determines which records are selected when a query is run is called a(n) ____.

Results of a query are narrowed by using the Or logical operator.____________________

A query based on more than one table is a(n) ____query.

Which comparison operator matches a pattern that includes wildcards?