Exam 3: Access 3: Creating Custom Reports

A label control must be used when a report requires a specific date that is not the current date. ____________________

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools.

The expression =Date(), inserted in a text box in a report design, will return the ____________________ value.

Properties of a multiple-column report may be changed using the ____________________ section of the Page Setup dialog box.

The Page Numbers button, used to add a page number expression to a report, is found in the ____ group on the Design tab.

To begin the process of removing the default alternate row color in a report, select the ____ Border Style after selecting all sections of the report from the Format tab.

The ____________________ option from the Size/Space button on the ARRANGE tab creates equal spacing between horizontal controls.

A filter may be applied to data when a report is viewed using the Layout view . ____________________

The Line tool is accessed using the More button in the ____ group on the Design tab.

Placing the report title, date, and page number on the same line in the ____ is a common report standard.

The Keep Together property, which determines how group data will be printed, is set using the  ____________________.

Reports may only be viewed in Print Preview.

A report sort field that includes a Group Header section and a Group Footer section is a grouping field. ____________________

Values in a selected column may be summarized using any of eight ____________________ functions on the Totals menu from the DESIGN tab.

The text box property that allows the box to expand vertically to fit the field value is the ____ property.

Which report view is the best to use to see what a report will look like when it is printed?

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

What is the maximum number of sort fields that can be included in a report?

Page numbers must be added to a report in Design view.

Design view should be used to modify a report when the user wants to add lines, rectangles, and other controls only available in Design view . ____________________