Question 1

The ________ command removes all filters from a report.

Accepted Answer

Clear All Filters

Question 2

Report controls can be formatted using the commands on the ________ tab.

Accepted Answer

Format

Question 3

In a report, if you click on a date control and then click the Filter button, Date Filters will be available to you from the Filter list.

Accepted Answer

A) True 
 B)False  True

Question 4

A selected control in a report displays a(n) ________ border.

Accepted Answer

A)  orange 
B)  green 
C)  blue 
D)  purple 
A)  orange 
B)  green 
C)  blue 
D)  purple

Question 5

A filter helps you display only those records in a report that match one or more ________.

Accepted Answer

The answer of A filter helps you display only those...

Question 6

The Query Wizard button is found in the ________ group under the Create tab.

Accepted Answer

A)  Templates 
B)  Queries 
C)  Tables 
D)  Reports 
A)  Templates 
B)  Queries 
C)  Tables 
D)  Reports

Question 7

On the ________ is an alternative to using the View button in the Ribbon to switch views.

Accepted Answer

The answer of On the ________ is an alternative to...

Question 8

Reports can be created quickly by selecting a table or query in the Navigation Pane, and then clicking the Report button.

Accepted Answer

A) True 
 B)False

Question 9

In a report, text boxes display data.

Accepted Answer

A) True 
 B)False

Question 10

You can change the color of the banded rows in a report.

Accepted Answer

A) True 
 B)False

Question 11

Each manufacturer identifies its label sheets by using a ________.

Accepted Answer

A)  factory icon 
B)  product name 
C)  product number 
D)  zone label 
A)  factory icon 
B)  product name 
C)  product number 
D)  zone label

Question 12

A picture CANNOT be inserted into the header of a report.

Accepted Answer

A) True 
 B)False

Question 13

The Labels button is found in the ________ group on the Create tab.

Accepted Answer

A)  Reports 
B)  Forms 
C)  Queries 
D)  Tables 
A)  Reports 
B)  Forms 
C)  Queries 
D)  Tables

Question 14

The Group, Sort, and Total pane appears when the Group & Sort button is selected.

Accepted Answer

A) True 
 B)False

Question 15

Report controls can be formatted using the commands on the ________ tab.

Accepted Answer

A)  Home 
B)  Format 
C)  Database Tools 
D)  File 
A)  Home 
B)  Format 
C)  Database Tools 
D)  File

Question 16

The Label Wizard shows you a prototype of the selected fields and their placement.

Accepted Answer

A) True 
 B)False

Question 17

________ view can be used to format a report while viewing the report's data.

Accepted Answer

A)  Layout 
B)  Design 
C)  Report 
D)  Normal 
A)  Layout 
B)  Design 
C)  Report 
D)  Normal

Question 18

Labels CANNOT be created from tables or queries.

Accepted Answer

A) True 
 B)False

Question 19

The Blank Report tool does NOT make it easy to arrange and format text controls.

Accepted Answer

A) True 
 B)False

Question 20

Reports are often based on ________.

Accepted Answer

The answer of Reports are often based on ________....

The ________ command removes all filters from a report.

Report controls can be formatted using the commands on the ________ tab.

In a report, if you click on a date control and then click the Filter button, Date Filters will be available to you from the Filter list.

A selected control in a report displays a(n) ________ border.

A filter helps you display only those records in a report that match one or more ________.

The Query Wizard button is found in the ________ group under the Create tab.

On the ________ is an alternative to using the View button in the Ribbon to switch views.

Reports can be created quickly by selecting a table or query in the Navigation Pane, and then clicking the Report button.

In a report, text boxes display data.

You can change the color of the banded rows in a report.

Each manufacturer identifies its label sheets by using a ________.

A picture CANNOT be inserted into the header of a report.

The Labels button is found in the ________ group on the Create tab.

The Group, Sort, and Total pane appears when the Group & Sort button is selected.

Report controls can be formatted using the commands on the ________ tab.

The Label Wizard shows you a prototype of the selected fields and their placement.

________ view can be used to format a report while viewing the report's data.

Labels CANNOT be created from tables or queries.

The Blank Report tool does NOT make it easy to arrange and format text controls.

Reports are often based on ________.

Create Database Tables

Create Select Queries

Create Forms

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters

Exam 4: Create Reports

The ________ command removes all filters from a report.

Report controls can be formatted using the commands on the ________ tab.

In a report, if you click on a date control and then click the Filter button, Date Filters will be available to you from the Filter list.

A selected control in a report displays a(n) ________ border.

A filter helps you display only those records in a report that match one or more ________.

The Query Wizard button is found in the ________ group under the Create tab.

On the ________ is an alternative to using the View button in the Ribbon to switch views.

Reports can be created quickly by selecting a table or query in the Navigation Pane, and then clicking the Report button.

In a report, text boxes display data.

You can change the color of the banded rows in a report.

Each manufacturer identifies its label sheets by using a ________.

A picture CANNOT be inserted into the header of a report.

The Labels button is found in the ________ group on the Create tab.

The Group, Sort, and Total pane appears when the Group & Sort button is selected.

Report controls can be formatted using the commands on the ________ tab.

The Label Wizard shows you a prototype of the selected fields and their placement.

________ view can be used to format a report while viewing the report's data.

Labels CANNOT be created from tables or queries.

The Blank Report tool does NOT make it easy to arrange and format text controls.

Reports are often based on ________.

Create Database Tables

Create Select Queries

Create Forms

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters