Question 1

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 2

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 3

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 4

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

Accepted Answer

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

Question 5

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 6

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 answer of Identify the letter of the choice that...

Question 7

Which view must be used to delete an entire record?

Accepted Answer

A)  Design 
B)  Query 
C)  Navigation 
D)  Datasheet

Question 8

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

Accepted Answer

The answer of  To locate a specific field value or...

Question 9

Changes made to a field in a query datasheet updates the same field in the table on which the query is based. ____________________

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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 13

A calculated field is formatted using the ____ for the field.

Accepted Answer

A)  Property Sheet 
B)  Criteria 
C)  Expression Builder 
D)  Operator

Question 14

In the criterion,<=250,the operator will return values for the specified field that are ____.

Accepted Answer

A)  less than 250 
B)  equal to 250 
C)  less than or equal to 250 
D)  greater than or equal to 250

Question 15

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

Exam 3: Maintaining and Querying a Database