Question 1

You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

Accepted Answer

The answer of  You want to add the PaymentDate...

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

The >= comparison operator means ____.

Accepted Answer

A)  less than or greater than 
B)  within 
C)  in 
D)  greater than or equal to

Question 4

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

Question 5

The data displayed in a query is sometimes called a(n) ____ view of the data.

Accepted Answer

The answer of The data displayed in a query is...

Question 6

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

Accepted Answer

The answer of Use the ____ check box in the...

Question 7

Match between columns
                        Premises: An asterisk or question mark used in a query
A predefined Access formula that returns a value such as a subtotal or count
A statistic such as a subtotal or count is determined on a given field in a group of records
A datasheet's records are placed in a determined order
A field of data that is created based on values of other fields
A combination of field names, operators and functions

Accepted Answer

The Answer of Aggregate function and Sort and Wildcard character is...

Question 8

In the accompanying figure, how many fields will display on the resulting datasheet?

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6

Question 9

____ 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

Question 10

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

Accepted Answer

A)  Group By row 
B)  Total row 
C)  Values row 
D)  Crosstab row

Question 11

Deleting a field from the query design grid deletes it from the database table that contains that field.

Accepted Answer

A) True 
 B)False

Question 12

A summary query calculates statistics about ____.

Accepted Answer

A)  one record 
B)  groups of records 
C)  one field 
D)  groups of fields

Question 13

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 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

The answer of Explain the position and purpose for the...

Question 16

In the accompanying figure, what is the primary key field of the Tours table?

Accepted Answer

A)  TourNo 
B)  Customers 
C)  Sales 
D)  Tours

Question 17

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 18

An SQL statement determines how the resulting records are sorted after the ____ keyword.

Accepted Answer

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

Question 19

Each criteria row of the query design grid is evaluated separately.

Accepted Answer

A) True 
 B)False

Question 20

In the accompanying figure, fields from how many tables will display on the datasheet?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4

Exam 6: Modifying the Database Structure

You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

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

The >= comparison operator means ____.

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.

The data displayed in a query is sometimes called a(n) ____ view of the data.

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

Match each of the following with the correct definition or statement.

In the accompanying figure, how many fields will display on the resulting datasheet?

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

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

Deleting a field from the query design grid deletes it from the database table that contains that field.

A summary query calculates statistics about ____.

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

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

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

In the accompanying figure, what is the primary key field of the Tours table?

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

An SQL statement determines how the resulting records are sorted after the ____ keyword.

Each criteria row of the query design grid is evaluated separately.

In the accompanying figure, fields from how many tables will display on the datasheet?