Exam 5: Access Lesson 5: Creating and Modifying Reports

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 ____.

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.

The data in a report is ____________________, which means that you can view it but you cannot change it.

The ____________________ creates a simple report that includes all the fields in the selected table or query, uses a simple columnar format, and includes a title with the same name as the record source.

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.

The Custom Print Wizard lets you create a report that you can use to print standard or custom labels.

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

Another way to resize a report is to use the report ____, which appears in the upper-left corner of the report, where the horizontal and vertical rulers intersect.

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

Click a control to select it, and then use the options in the Text Formatting group on the ____ tab to change the text's font, size, and style.

A red triangle report error indicator appears on the report selector when the report's width exceeds the width of a page.

You can add a(n) _____ to a report.

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 realizes he needs to change the width of the report. When resizing a control in ____ view, Eddie uses the outline of the control and drags it with the pointer to see the actual width of the control.

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.

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

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.

When you need to create a report quickly, you can use the Label Wizard , which asks you about the report you want to create and lets you select options in dialog boxes to specify the report's record source, layout, and style.

You can remove a control from a control layout in a report just like you can for a form. Display the report in ____ view, click the control to select it, right-click the control to open the shortcut menu, point to Layout, and then click Remove Layout.

The layout options for reports do NOT include ____.