Exam 3: Access: Creating Custom Reports

As you select fields from the Available fields list box or type text for a label the ____ label box shows the format for the label.

The item marked 6 in the accompanying figure is the ____ section.

All of the following are Totals menu options EXCEPT ____.

Which of the following is a possible source of data for a report?

The report title in the accompanying figure is ____________________.

In the ____ section of the Page Setup dialog box you specify the number of column sets and the row and column spacing between the column sets.

You can use the Drawing tool to add lines to a report.

In the Reports group on the ____ tab click the Blank Report button to open a blank report in Layout view.

When you design your report you determine which sections to include and what information to place in each section.

The ____ property when set to Yes expands a text box vertically to fit the field value when the report is printed.

You place the Total function in a Group Footer section to print each group's total.

You use the Group Sort and Total pane to select sort fields and grouping fields for a report.

Eight aggregate functions including the Sum function are available on the Totals menu for summarizing values in the selected column.

You usually determine page setup properties when you design a report or after you have placed the controls in the Detail section.

For properties in the property sheet that offer a list of choices you can ____ the property name to cycle through the options in the list.

When you design or create your own report from scratch you produce a(n)____ report.

Just as you do in Layout and Design views for forms you can use the ____ button as you perform operations.

Each report can have up to 17 sort fields and any of its sort fields can also be grouping fields.

Double-clicking a report name in the Navigation Pane opens the report in ____.

The ____ section is used for report totals.