Exam 5: Access Lesson 5: Creating and Modifying Reports

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

The different options for creating reports are located in the Reports group on the Design tab.

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?

FIGURE AC 5-1 Referring to the figure above, in this report, ____ appear in controls.

Controls in reports are not grouped in control layouts like they are in forms.

To change the style of a selected line, click the ____ Outline button, point to Line Type, and then click one of the line styles.

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

You can add new controls to a report by using the tools in the Query group.

What steps do you take to add a picture to a report? Name a situation where you would want to add a picture to a report.

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

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

You can use the horizontal and vertical rulers at the top and left side of the report in Report Design view to place controls in the report.

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. Monica wants to insert a space between the first and last name. What should she do before double-clicking the Last Name in the Available fields box?

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.

To add a picture to a report, click the Insert ____ button in the Controls group on the Design tab.

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 close a report in Print Preview, Access displays the report in Design view.

Just like when used in forms, you can add text to a report by adding it in the ____ control.

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

To create labels, select the record source in the ____, click the Create tab on the Ribbon, and then click the Labels button in the Reports group on the Create tab.