Question 1

The results of a query display in ____________________ view.

Accepted Answer

The answer of The results of a query display in...

Question 2

To enter a criterion for a particular field without displaying the field in the results of the query,include the field in the design grid,enter the criterion,and remove the check mark from its Show check box.

Accepted Answer

A) True 
 B)False

Question 3

Case 2-1
Bavant needs to gather some additional statistics on its customers.An employee at Bavant has created an initial query as shown in the accompanying figure that calculates the average amount paid.The employee is unsure what aggregate functions to use for additional calculations.  
-Which aggregate function will find the standard deviation?

Accepted Answer

The answer of Case 2-1
Bavant needs to gather some additional...

Question 4

-In the accompanying figure,you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

Accepted Answer

A)  Delete Table 
B)  Hide Table 
C)  Remove Table 
D)  Erase Table 
A)  Delete Table 
B)  Hide Table 
C)  Remove Table 
D)  Erase Table

Question 5

The special criteria that can be used in queries are ____.

Accepted Answer

A)  AND 
B)  INCLUSIVE 
C)  BETWEEN 
D)  IN 
A)  AND 
B)  INCLUSIVE 
C)  BETWEEN 
D)  IN

Question 6

-In the accompanying figure,you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

Accepted Answer

A)  Sort 
B)  Show 
C)  or 
D)  Criteria 
A)  Sort 
B)  Show 
C)  or 
D)  Criteria

Question 7

A summary function is a function that performs some mathematical function against a group of records.____________________

Accepted Answer

A) True 
 B)False

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-An aggregate function.

Accepted Answer

A) (*) 
B) (?) 
C) / 
D) Total 
E) AND criterion
F)NOT
G)BETWEEN
H)OR criterion
I)IN
J)FIRST 
A) (*) 
B) (?) 
C) / 
D) Total 
E) AND criterion
F)NOT
G)BETWEEN
H)OR criterion
I)IN
J)FIRST

Question 9

When you sort data,duplicates are not included.

Accepted Answer

A) True 
 B)False

The results of a query display in ____________________ view.

To enter a criterion for a particular field without displaying the field in the results of the query,include the field in the design grid,enter the criterion,and remove the check mark from its Show check box.

-In the accompanying figure,you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

The special criteria that can be used in queries are ____.

-In the accompanying figure,you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

A summary function is a function that performs some mathematical function against a group of records.____________________

Identify the letter of the choice that best matches the phrase or definition. -An aggregate function.

When you sort data,duplicates are not included.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Maintaining a Database

Filters

Exam 16: Access: Querying a Database

The results of a query display in ____________________ view.

To enter a criterion for a particular field without displaying the field in the results of the query,include the field in the design grid,enter the criterion,and remove the check mark from its Show check box.

-In the accompanying figure,you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

The special criteria that can be used in queries are ____.

-In the accompanying figure,you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

A summary function is a function that performs some mathematical function against a group of records.____________________

Identify the letter of the choice that best matches the phrase or definition. -An aggregate function.

When you sort data,duplicates are not included.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Maintaining a Database

Filters