Question 1

Access helps you with criteria syntax in the query design grid.

Accepted Answer

A) True 
 B)False

Question 2

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

Accepted Answer

A) True 
 B)False

Question 3

When you create a summary query, which row is added to the query design grid?

Accepted Answer

A)  Criteria 
B)  Table 
C)  Field 
D)  Total 
A)  Criteria 
B)  Table 
C)  Field 
D)  Total

Question 4

Sort orders defined in Query Design View are not saved with the query object.

Accepted Answer

A) True 
 B)False

Question 5

A query can display fields from one or more tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 6

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Accepted Answer

A) True 
 B)False

Question 7

The wildcard character that represents any combination of characters in query criteria is the ____.

Accepted Answer

A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (˜) 
D)  question mark (?) 
A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (˜) 
D)  question mark (?)

Question 8

You want to add the PaymentDate field from the Payments table to the query grid. Describe how you can do this.

Accepted Answer

Drag the PaymentDate field in the Paymen

Question 9

In Query Design View, one-to-many join lines identify linking fields between related tables.

Accepted Answer

A) True 
 B)False

Question 10

Which aggregate function would NOT work well on a Short Text field?

Accepted Answer

A)  Sum 
B)  Min 
C)  Max 
D)  Count 
A)  Sum 
B)  Min 
C)  Max 
D)  Count

Question 11

The > operator means less than in a query. _________________________

Accepted Answer

A) True 
 B)False

Question 12

SQL statements start with the FROM keyword. _________________________

Accepted Answer

A) True 
 B)False

Question 13

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

Accepted Answer

A) True 
 B)False

Question 14

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

Accepted Answer

The answer of ____ queries summarize data in which one...

Question 15

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

Accepted Answer

1.  One field would be used fo

Question 16

Queries evaluate sort orders from left to right . _________________________

Accepted Answer

A) True 
 B)False

Question 17

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Accepted Answer

The criteria for the CompanyName field w

Question 20

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Accepted Answer

A) True 
 B)False

Access helps you with criteria syntax in the query design grid.

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

When you create a summary query, which row is added to the query design grid?

Sort orders defined in Query Design View are not saved with the query object.

A query can display fields from one or more tables in a relational database.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

The wildcard character that represents any combination of characters in query criteria is the ____.

You want to add the PaymentDate field from the Payments table to the query grid. Describe how you can do this.

In Query Design View, one-to-many join lines identify linking fields between related tables.

Which aggregate function would NOT work well on a Short Text field?

The > operator means less than in a query. _________________________

SQL statements start with the FROM keyword. _________________________

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

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

Queries evaluate sort orders from left to right . _________________________

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.

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

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

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

Access helps you with criteria syntax in the query design grid.

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

When you create a summary query, which row is added to the query design grid?

Sort orders defined in Query Design View are not saved with the query object.

A query can display fields from one or more tables in a relational database.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

The wildcard character that represents any combination of characters in query criteria is the ____.

You want to add the PaymentDate field from the Payments table to the query grid. Describe how you can do this.

In Query Design View, one-to-many join lines identify linking fields between related tables.

Which aggregate function would NOT work well on a Short Text field?

The > operator means less than in a query. _________________________

SQL statements start with the FROM keyword. _________________________

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

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

Queries evaluate sort orders from left to right . _________________________

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.

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

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

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