Exam 5: Creating and Modifying Reports

Explore all topics

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. The first thing Monica does is to double-click First Name in the Available fields box. The First Name field is added to the Prototype label section. If the First Name field is enclosed in curly brackets, what does this mean?

(Multiple Choice)

4.9/5

(36)

Question 21

The ____________________ tool lets you add a line to a report.

(Short Answer)

4.8/5

(27)

Question 22

To draw a straight line, press and hold down the Tab key while drawing the line.

(True/False)

4.7/5

(32)

Question 23

FIGURE AC 5-1 In the header of the report shown above, the date of January 29, 2013 is listed. This is the ____.

(Multiple Choice)

4.8/5

(36)

Question 24

Identify the letter of the choice that best matches the phrase or definition.

Section is printed at the beginning of each new group of records.

Group Header

Section is printed at the top of every page of the report.

Page Header

Section is printed once for each row in the record source and contains the main body of the report.

Report Header

Correct Answer:

Verified

Section is printed at the beginning of each new group of records.

Section is printed at the top of every page of the report.

Section is printed once for each row in the record source and contains the main body of the report.

Section is printed once at the bottom of the last page of the report, and usually includes summary information for the entire report.

Section is printed once at the top of the first page of the report, and usually includes the report title.

(Matching)

4.9/5

(40)

Question 25

When you click a control in ____ view, an orange border appears around the text box and a dotted border appears around its attached label to indicate that the control is selected.

(Multiple Choice)

4.9/5

(40)

Question 26

If the report's controls all fit on the page, with the exception of the control in the Page Footer section, you can drag the control to the left so it fits on the printed page.

(True/False)

4.8/5

(42)

Question 27

If the Field List pane opens when you change to Layout view, click the Add Existing Fields button in the Tools group on the ____ tab to close it.

(Multiple Choice)

4.9/5

(32)

Question 28

The layout options for reports do NOT include ____.

(Multiple Choice)

4.9/5

(42)

Question 29

You cannot sort data in a report using a field that is already used to group records.

(True/False)

4.7/5

(34)

Question 30

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie wants to see the control's width in characters and size the control exactly. This information appears ____.

(Multiple Choice)

4.9/5

(35)

Question 31

When you create a report using the Report Wizard, you might need to adjust the report's width to eliminate blank pages. You know that you need to make this change when you see ____ in the report.

(Multiple Choice)

4.9/5

(28)

Question 32

Just as with forms, the tables or queries that contain the data used in a report are called the ____.

(Multiple Choice)

4.8/5

(34)

Question 33

When a report contains more than one page, you can click the buttons on the ____ bar at the bottom of the Print Preview window to view additional pages in the report.

(Multiple Choice)

4.8/5

(39)

Question 34

When you use the Report tool to create a report, the report opens initially in Design view.

(True/False)

4.8/5

(37)

Question 35

Just like in Form Design view, you can adjust the height of a section by dragging its bottom edge up or down, and you can select a section in a report by clicking its ____.

(Multiple Choice)

4.9/5

(33)

Question 36

A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report

(Short Answer)

4.9/5

(28)

Question 37

To add a control to a report, click the button in the Controls group.

(True/False)

4.9/5

(26)

Question 38

Point to a button in the Controls group to display its name in a ____.

(Multiple Choice)

4.7/5

(39)

Question 39

Just as with forms, the tables or queries that contain the data used in a report are called the controls .

(True/False)

4.9/5

(36)

Question 40

Showing 21 - 40 of 46

Exam 5: Creating and Modifying Reports

The ____________________ tool lets you add a line to a report.

To draw a straight line, press and hold down the Tab key while drawing the line.

FIGURE AC 5-1 In the header of the report shown above, the date of January 29, 2013 is listed. This is the ____.

When you click a control in ____ view, an orange border appears around the text box and a dotted border appears around its attached label to indicate that the control is selected.

If the report's controls all fit on the page, with the exception of the control in the Page Footer section, you can drag the control to the left so it fits on the printed page.

If the Field List pane opens when you change to Layout view, click the Add Existing Fields button in the Tools group on the ____ tab to close it.

The layout options for reports do NOT include ____.

You cannot sort data in a report using a field that is already used to group records.

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie wants to see the control's width in characters and size the control exactly. This information appears ____.

When you create a report using the Report Wizard, you might need to adjust the report's width to eliminate blank pages. You know that you need to make this change when you see ____ in the report.

Just as with forms, the tables or queries that contain the data used in a report are called the ____.

When a report contains more than one page, you can click the buttons on the ____ bar at the bottom of the Print Preview window to view additional pages in the report.

When you use the Report tool to create a report, the report opens initially in Design view.

Just like in Form Design view, you can adjust the height of a section by dragging its bottom edge up or down, and you can select a section in a report by clicking its ____.

A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report

To add a control to a report, click the button in the Controls group.

Point to a button in the Controls group to display its name in a ____.

Just as with forms, the tables or queries that contain the data used in a report are called the controls .

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters