Question 1

The ___________________ command allows hidden fields to be redisplayed.

Accepted Answer

The answer of  The ___________________ command allows hidden fields to...

Question 2

The default group in the Navigation Pane is ____.

Accepted Answer

A)  Object Type 
B)  All Access Objects 
C)  Table 
D)  Design Grids

Question 3

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Accepted Answer

A)  crosstab 
B)  append 
C)  query by example (QB
E)  
D)  update

Question 4

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 5

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

Accepted Answer

A) True 
 B)False

Question 6

The default query type for Access is the Crosstab query. ____________________

Accepted Answer

A) True 
 B)False

Question 7

The contents of query datasheet are permanent.____________________

Accepted Answer

A) True 
 B)False

Question 8

Hiding a field in Datasheet view removes the field from the current table. ____________________

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

Accepted Answer

A)  Table Name 
B)  Custom 
C)  Query Name 
D)  Relationship

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

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

Question 15

The comparison operator,,is used to insert a condition that means ____.

Accepted Answer

A)  greater than 
B)  And 
C)  less than 
D)  not equal to

Question 16

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 17

Case-Based Critical Thinking Questions
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 18

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

Accepted Answer

A) True 
 B)False

Question 19

The + symbol is an example of a(n) ____ operator.

Accepted Answer

A)  arithmetic 
B)  logical 
C)  comparison 
D)  calculation

Question 20

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

Accepted Answer

A)  Query Type 
B)  Show/Hide 
C)  Query Setup 
D)  Results

Exam 3: Maintaining and Querying a Database

The ___________________ command allows hidden fields to be redisplayed.

The default group in the Navigation Pane is ____.

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

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

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

The default query type for Access is the Crosstab query. ____________________

The contents of query datasheet are permanent.____________________

Hiding a field in Datasheet view removes the field from the current table. ____________________

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

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

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

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

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

The comparison operator,< >,is used to insert a condition that means ____.

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

Arithmetic operations are performed on selected records in a database using Statistical functions.____________________

The + symbol is an example of a(n) ____ operator.

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?