Question 1

In the accompanying figure, 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 D

Question 2

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

Accepted Answer

Crosstab

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 D

Question 4

Which arithmetic operator signifies division?

Accepted Answer

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

Question 5

How many calculated fields are shown in the accompanying figure?

Accepted Answer

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

Question 6

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 7

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

The > operator means less than in a query.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

The wildcard character that represents one character 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 14

In Query Design View, primary key fields in a field list are ____.

Accepted Answer

A)  underlined 
B)  the first field listed 
C)  the last field listed 
D)  indicated with a key icon 
A)  underlined 
B)  the first field listed 
C)  the last field listed 
D)  indicated with a key icon

Question 15

In the accompanying figure, item 3 points to ____.

Accepted Answer

A)  a field from the Payments table 
B)  a field from the Tours table 
C)  the Payments field list 
D)  the Sales field list 
A)  a field from the Payments table 
B)  a field from the Tours table 
C)  the Payments field list 
D)  the Sales field list

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

You can view the SQL code for any query by switching to Code View.

Accepted Answer

A) True 
 B)False

Question 18

In the query design grid, what characters surround text criteria?

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

Which function should you use to calculate today's current date?

Accepted Answer

A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY 
A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY

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

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

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

Which arithmetic operator signifies division?

How many calculated fields are shown in the accompanying figure?

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.

The > operator means less than in a query.

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

In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

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

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

The wildcard character that represents one character in query criteria is the ____.

In Query Design View, primary key fields in a field list are ____.

In the accompanying figure, item 3 points to ____.

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

You can view the SQL code for any query by switching to Code View.

In the query design grid, what characters surround text criteria?

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

Which function should you use to calculate today's current date?

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 6: Modifying the Database Structure

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

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

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

Which arithmetic operator signifies division?

How many calculated fields are shown in the accompanying figure?

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.

The > operator means less than in a query.

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

In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

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

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

The wildcard character that represents one character in query criteria is the ____.

In Query Design View, primary key fields in a field list are ____.

In the accompanying figure, item 3 points to ____.

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

You can view the SQL code for any query by switching to Code View.

In the query design grid, what characters surround text criteria?

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

Which function should you use to calculate today's current date?

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters