Exam 3: Access: Advanced Report Techniques

Explain the difference between the Control Source property and the Record Source property.

The subreport appears as a separate report in the Navigation Pane.

To add fields to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab to add a field list.

The Book Rep Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed after the records in a particular group.

To cause the contents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.

The Expression Builder dialog box displays in the accompanying figure. You also can display the ____ dialog box to type an expression.

To display a Report Footer section, press and hold or right-click any open area of the report and tap or click ____ on the shortcut menu.

To import a text file, tap or click the ____ button on the EXTERNAL DATA tab.

Modified Multiple Choice The property sheet includes the _____ tabs.

The Book Rep Master List shown in the accompanying figure includes an unbound control. The process of converting an unbound control to a bound control is called ____________________.

To remove blank lines that occur when a field is empty, change the value of the ____ property.

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

To display the Expression Builder dialog box, tap or click the Build Expression button on the QUERY TOOLS DESIGN tab.

The Book Rep Master List shown in the accompanying figure includes an unbound control. You could enter an expression in this control to combine two or more text data items. The process of combining these items is called ____________________.

If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.

When you use the Title button to add a title to a report, the title is the same as the name of the report object.