Question 1

Which aggregate function is used to find the number of values in a field?

Accepted Answer

A)  Values 
B)  Num 
C)  Number 
D)  Count 
A)  Values 
B)  Num 
C)  Number 
D)  Count

Question 2

The operators, and NOT are equivalent.

Accepted Answer

A) True 
 B)False

Question 3

You can specify more than one sort field in Query Design View.

Accepted Answer

A) True 
 B)False

Question 4

Which aggregate function is used to find the average of values in a field?

Accepted Answer

A)  Avg 
B)  Average 
C)  Mean 
D)  Mode 
A)  Avg 
B)  Average 
C)  Mean 
D)  Mode

Question 5

A(n) ____ query is used to calculate statistics about a group of records.

Accepted Answer

The answer of A(n) ____ query is used to calculate...

Question 6

The ____ function returns a number of characters from the first part of a field.

Accepted Answer

The answer of The ____ function returns a number of...

Question 7

____ criteria are two or more criteria on the same Criteria row of the query design grid.

Accepted Answer

A)  OR 
B)  Expand 
C)  AND 
D)  Wildcard 
A)  OR 
B)  Expand 
C)  AND 
D)  Wildcard

Question 8

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.

Accepted Answer

A) True 
 B)False

Question 9

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Accepted Answer

The answer of The Find ____ Query Wizard is used...

Question 10

Which aggregate function is used to find the total of values in a field?

Accepted Answer

A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total 
A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total

Which aggregate function is used to find the number of values in a field?

The operators, and NOT are equivalent.

You can specify more than one sort field in Query Design View.

Which aggregate function is used to find the average of values in a field?

A(n) ____ query is used to calculate statistics about a group of records.

The ____ function returns a number of characters from the first part of a field.

____ criteria are two or more criteria on the same Criteria row of the query design grid.

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Which aggregate function is used to find the total of values in a field?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 6: Improving Queries

Which aggregate function is used to find the number of values in a field?

The operators, and NOT are equivalent.

You can specify more than one sort field in Query Design View.

Which aggregate function is used to find the average of values in a field?

A(n) ____ query is used to calculate statistics about a group of records.

The ____ function returns a number of characters from the first part of a field.

____ criteria are two or more criteria on the same Criteria row of the query design grid.

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Which aggregate function is used to find the total of values in a field?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters