Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

A summary query calculates statistics about ____.

Accepted Answer

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

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

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

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

A summary query calculates statistics about ____.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 7: Improving Queries

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

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

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

A summary query calculates statistics about ____.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters