Question 1

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 A

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

In SQL, the FROM keyword determines how records are sorted. _________________________

Accepted Answer

A) True 
 B)False  False

Question 4

A select query is the most common type of query.

Accepted Answer

A) True 
 B)False

Question 5

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 
A)  Group By row 
B)  Total row 
C)  Values row 
D)  Crosstab row

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

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 8

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 9

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

Accepted Answer

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

Question 10

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 11

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 12

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 13

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

Accepted Answer

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

Question 14

Which arithmetic operator signifies exponentiation?

Accepted Answer

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

Question 15

In the query shown in the accompanying figure, what sort orders have been specified?

Accepted Answer

The answer of   In the query shown in...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

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

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

In SQL, the FROM keyword determines how records are sorted. _________________________

A select query is the most common type of query.

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

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

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

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

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

How many calculated fields are shown in the accompanying figure?

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

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

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

Which arithmetic operator signifies exponentiation?

In the query shown in the accompanying figure, what sort orders have been specified?

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

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

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

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 6: Improving Queries

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

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

In SQL, the FROM keyword determines how records are sorted. _________________________

A select query is the most common type of query.

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

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

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

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

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

How many calculated fields are shown in the accompanying figure?

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

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

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

Which arithmetic operator signifies exponentiation?

In the query shown in the accompanying figure, what sort orders have been specified?

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

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

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

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters