Question 1

Which function would you use to calculate the monthly payment on a loan?

Accepted Answer

A) PMT 
B) LOAN 
C) PAY 
D) RATE 
A) PMT 
B) LOAN 
C) PAY 
D) RATE

Question 2

In the figure above, item 1 refers to a(n)____.

Accepted Answer

A) Table name 
B) Field list 
C) Query design grid 
D) One-to-many join line 
A) Table name 
B) Field list 
C) Query design grid 
D) One-to-many join line

Question 3

Explain the position and purpose for the three typical field positions used in a crosstab query.

Accepted Answer

1.One field would be used for

Question 4

____ 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 5

Changes you make to PivotChart View are automatically reflected in PivotTable View and vice versa.

Accepted Answer

A) True 
 B)False

Question 6

In Query Design View, a table's name displays in the field list title bar.

Accepted Answer

A) True 
 B)False

Question 7

Describe the one-to-many relationships of the tables in the figure above.

Accepted Answer

The Customers and Sales tables are relat

Question 8

The operator > means ____.

Accepted Answer

A) Greater than 
B) Greater than or equal to 
C) Less than 
D) Less than or equal to 
A) Greater than 
B) Greater than or equal to 
C) Less than 
D) Less than or equal to

Question 9

An SQL statement determines how the tables are joined after the ____ keyword

Accepted Answer

A) SELECT 
B) RELATE 
C) FROM 
D) ORDER BY 
A) SELECT 
B) RELATE 
C) FROM 
D) ORDER BY

Question 10

In Query Design View, you can drag the edge of a field list to resize it.

Accepted Answer

A) True 
 B)False

Question 11

Compare the field drop areas between a PivotTable and PivotChart.

Accepted Answer

1.The Filter Field is called the Filter

Question 12

The > operator means less than in a query.

Accepted Answer

A) True 
 B)False

Question 13

The operator means not equal to in a query.

Accepted Answer

A) True 
 B)False

Question 14

Which character signifies the division operator?

Accepted Answer

A) ^ 
B) * 
C) / 
D) \ 
A) ^ 
B) * 
C) / 
D) \

Question 15

Text criteria are surrounded by these characters in the query design grid.

Accepted Answer

A) Pound signs (#) 
B) Dollar signs ($) 
C) Percent signs (%) 
D) Quotation marks ("") 
A) Pound signs (#) 
B) Dollar signs ($) 
C) Percent signs (%) 
D) Quotation marks ("")

Question 16

You decide you want to see the PaymentDate field in the query above. Describe how to do this.

Accepted Answer

Drag the PaymentDate field in the Tours

Question 17

This 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 18

What sort orders have been specified in the query above?

Accepted Answer

The answer of   What sort orders have been...

Question 19

Filtering refers to reordering records in either ascending or descending order based on the values in the field.

Accepted Answer

A) True 
 B)False

Question 20

Use the ____________________ Query Wizard to guide you through the steps of creating a crosstab query.

Accepted Answer

The answer of Use the ____________________ Query Wizard to guide...

Which function would you use to calculate the monthly payment on a loan?

In the figure above, item 1 refers to a(n)____.

Explain the position and purpose for the three typical field positions used in a crosstab query.

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

Changes you make to PivotChart View are automatically reflected in PivotTable View and vice versa.

In Query Design View, a table's name displays in the field list title bar.

Describe the one-to-many relationships of the tables in the figure above.

The operator > means ____.

An SQL statement determines how the tables are joined after the ____ keyword

In Query Design View, you can drag the edge of a field list to resize it.

Compare the field drop areas between a PivotTable and PivotChart.

The > operator means less than in a query.

The operator means not equal to in a query.

Which character signifies the division operator?

Text criteria are surrounded by these characters in the query design grid.

You decide you want to see the PaymentDate field in the query above. Describe how to do this.

This aggregate function is used to find the number of values in a field.

What sort orders have been specified in the query above?

Filtering refers to reordering records in either ascending or descending order based on the values in the field.

Use the ____________________ Query Wizard to guide you through the steps of creating a crosstab query.

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters

Exam 6: Improving Queries Question

Which function would you use to calculate the monthly payment on a loan?

In the figure above, item 1 refers to a(n)____.

Explain the position and purpose for the three typical field positions used in a crosstab query.

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

Changes you make to PivotChart View are automatically reflected in PivotTable View and vice versa.

In Query Design View, a table's name displays in the field list title bar.

Describe the one-to-many relationships of the tables in the figure above.

The operator > means ____.

An SQL statement determines how the tables are joined after the ____ keyword

In Query Design View, you can drag the edge of a field list to resize it.

Compare the field drop areas between a PivotTable and PivotChart.

The > operator means less than in a query.

The operator means not equal to in a query.

Which character signifies the division operator?

Text criteria are surrounded by these characters in the query design grid.

You decide you want to see the PaymentDate field in the query above. Describe how to do this.

This aggregate function is used to find the number of values in a field.

What sort orders have been specified in the query above?

Filtering refers to reordering records in either ascending or descending order based on the values in the field.

Use the ____________________ Query Wizard to guide you through the steps of creating a crosstab query.

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters