Question 1

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

Accepted Answer

A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total 
A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total

Question 2

SQL statements start with the FROM keyword. _________________________

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

A(n) ____ character is used in criteria to represent any combination of characters.

Accepted Answer

A)  Wildcard 
B)  Default 
C)  Criteria 
D)  Expression 
A)  Wildcard 
B)  Default 
C)  Criteria 
D)  Expression

Question 5

Which query wizard helps you build a crosstab query?

Accepted Answer

A)  Select Query Wizard 
B)  Crosstab Query Wizard 
C)  Simple Query Wizard 
D)  Find Aggregates Query Wizard 
A)  Select Query Wizard 
B)  Crosstab Query Wizard 
C)  Simple Query Wizard 
D)  Find Aggregates Query Wizard

Question 6

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

In a query, the operator means not equal.

Accepted Answer

A) True 
 B)False

Question 10

An SQL statement determines what fields are selected after the ____ keyword.

Accepted Answer

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

Question 11

Queries evaluate sort orders from left to right . _________________________

Accepted Answer

A) True 
 B)False

Question 12

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 13

Which function should 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 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which arithmetic operator signifies division?

Accepted Answer

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

Question 16

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 17

Which 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

The >= comparison operator means ____.

Accepted Answer

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

Question 19

The > comparison 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 20

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

Accepted Answer

A) True 
 B)False

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

SQL statements start with the FROM keyword. _________________________

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

A(n) ____ character is used in criteria to represent any combination of characters.

Which query wizard helps you build a crosstab query?

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

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

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

In a query, the operator means not equal.

An SQL statement determines what fields are selected after the ____ keyword.

Queries evaluate sort orders from left to right . _________________________

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

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

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

Which arithmetic operator signifies division?

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

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

The >= comparison operator means ____.

The > comparison operator means ____.

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

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 total of values in a field?

SQL statements start with the FROM keyword. _________________________

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

A(n) ____ character is used in criteria to represent any combination of characters.

Which query wizard helps you build a crosstab query?

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

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

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

In a query, the operator means not equal.

An SQL statement determines what fields are selected after the ____ keyword.

Queries evaluate sort orders from left to right . _________________________

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

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

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

Which arithmetic operator signifies division?

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

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

The >= comparison operator means ____.

The > comparison operator means ____.

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

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