Question 1

The ________ control is the area of a report that repeats for each record.

Accepted Answer

A)  Detail 
B)  Header 
C)  Footer 
D)  Date 
A)  Detail 
B)  Header 
C)  Footer 
D)  Date

Question 2

A theme applies ________ to the report.

Accepted Answer

A)  a font only 
B)  a set of colors only 
C)  a font color only 
D)  a set of fonts and a set of colors 
A)  a font only 
B)  a set of colors only 
C)  a font color only 
D)  a set of fonts and a set of colors

Question 3

Click the ________ button to reapply a filter created previously.

Accepted Answer

A)  Filter 
B)  Refresh 
C)  View 
D)  Toggle Filter 
A)  Filter 
B)  Refresh 
C)  View 
D)  Toggle Filter

Question 4

An Access report CANNOT be used to print mailing labels.

Accepted Answer

A) True 
 B)False

Question 5

If the entire page of a report does not display in Print Preview view, click the ________ button.

Accepted Answer

A)  Columns 
B)  One Page 
C)  Text File 
D)  More 
A)  Columns 
B)  One Page 
C)  Text File 
D)  More

Question 6

A(n) ________ report is formatted so it can be printed on mailing labels.

Accepted Answer

A)  mail merge 
B)  label 
C)  address 
D)  contact list 
A)  mail merge 
B)  label 
C)  address 
D)  contact list

Question 7

In a tabular layout, labels are below each column.

Accepted Answer

A) True 
 B)False

Question 8

When you add filters to an open report, any previous filters do NOT remain in effect.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is the correct order of steps for creating a report based on a query?

Accepted Answer

A)  Add fields to the query, add criteria, and build the report using the query. 
B)  Add criteria, add fields to the query, and build the report using the query. 
C)  Build the report using the query, add criteria, and add fields to the query. 
D)  Add fields to the query, build the report using the query, and add criteria. 
A)  Add fields to the query, add criteria, and build the report using the query. 
B)  Add criteria, add fields to the query, and build the report using the query. 
C)  Build the report using the query, add criteria, and add fields to the query. 
D)  Add fields to the query, build the report using the query, and add criteria.

Question 10

A report formatted so that the data can be printed on a sheet of labels is called an address report.

Accepted Answer

A) True 
 B)False

Question 11

Users CANNOT make any changes to a theme's set of fonts or colors.

Accepted Answer

A) True 
 B)False

Question 12

Access formats a label report to match the dimensions of the label size.

Accepted Answer

A) True 
 B)False

Question 13

________ statistics allow the user to group records and analyze data.

Accepted Answer

The answer of ________ statistics allow the user to group...

Question 14

The average control is available when the Totals button is clicked in the ________ group on the Design tab.

Accepted Answer

A)  Grouping & Totals 
B)  Views 
C)  Controls 
D)  Tools 
A)  Grouping & Totals 
B)  Views 
C)  Controls 
D)  Tools

Question 15

By default, a report is set to the width of a printed sheet of ________.

Accepted Answer

The answer of By default, a report is set to...

Question 16

Match each definition with the appropriate term.
-Contains buttons for displaying pages of the report

Accepted Answer

A) Page Layout group 
B) Report view 
C) Zoom group 
D) Data group 
E) Label Wizard
F)Report Wizard
G)Page Size group
H)Print Preview
I)Report Tool
J)Blank Report tool 
A) Page Layout group 
B) Report view 
C) Zoom group 
D) Data group 
E) Label Wizard
F)Report Wizard
G)Page Size group
H)Print Preview
I)Report Tool
J)Blank Report tool

Question 17

If you do not see the entire contents of a field, you can adjust the column width to ________.

Accepted Answer

The answer of If you do not see the entire...

Question 18

Because the results you get after applying a filter contain records only with values you selected, the rest of the data remains hidden.

Accepted Answer

A) True 
 B)False

Question 19

To copy all the formatting of one control to other controls, use the Format Painter.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ________ report is formatted so it can be printed on mailing labels.

Accepted Answer

The answer of A(n) ________ report is formatted so it...

The ________ control is the area of a report that repeats for each record.

A theme applies ________ to the report.

Click the ________ button to reapply a filter created previously.

An Access report CANNOT be used to print mailing labels.

If the entire page of a report does not display in Print Preview view, click the ________ button.

A(n) ________ report is formatted so it can be printed on mailing labels.

In a tabular layout, labels are below each column.

When you add filters to an open report, any previous filters do NOT remain in effect.

Which of the following is the correct order of steps for creating a report based on a query?

A report formatted so that the data can be printed on a sheet of labels is called an address report.

Users CANNOT make any changes to a theme's set of fonts or colors.

Access formats a label report to match the dimensions of the label size.

________ statistics allow the user to group records and analyze data.

The average control is available when the Totals button is clicked in the ________ group on the Design tab.

By default, a report is set to the width of a printed sheet of ________.

Match each definition with the appropriate term. -Contains buttons for displaying pages of the report

If you do not see the entire contents of a field, you can adjust the column width to ________.

Because the results you get after applying a filter contain records only with values you selected, the rest of the data remains hidden.

To copy all the formatting of one control to other controls, use the Format Painter.

A(n) ________ report is formatted so it can be printed on mailing labels.

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 ________ control is the area of a report that repeats for each record.

A theme applies ________ to the report.

Click the ________ button to reapply a filter created previously.

An Access report CANNOT be used to print mailing labels.

If the entire page of a report does not display in Print Preview view, click the ________ button.

A(n) ________ report is formatted so it can be printed on mailing labels.

In a tabular layout, labels are below each column.

When you add filters to an open report, any previous filters do NOT remain in effect.

Which of the following is the correct order of steps for creating a report based on a query?

A report formatted so that the data can be printed on a sheet of labels is called an address report.

Users CANNOT make any changes to a theme's set of fonts or colors.

Access formats a label report to match the dimensions of the label size.

________ statistics allow the user to group records and analyze data.

The average control is available when the Totals button is clicked in the ________ group on the Design tab.

By default, a report is set to the width of a printed sheet of ________.

Match each definition with the appropriate term. -Contains buttons for displaying pages of the report

If you do not see the entire contents of a field, you can adjust the column width to ________.

Because the results you get after applying a filter contain records only with values you selected, the rest of the data remains hidden.

To copy all the formatting of one control to other controls, use the Format Painter.

A(n) ________ report is formatted so it can be printed on mailing labels.

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