Exam 3: Access: Advanced Report Techniques

To ungroup controls, tap or click any of the controls in the group and tap or click the Ungroup button on the REPORT DESIGN TOOLS ____ tab.

When working on a report in Design view, you can make adjustments to the alignment of the controls in your report by using the Adjustment button on the REPORT DESIGN TOOLS ARRANGE tab.

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

The ____ aggregate function finds the smallest value.

To add a text box to a report, tap or click the ____ tool in the Tools group on the REPORT DESIGN TOOLS DESIGN tab.

To use an item name that contains spaces, such as Amount Paid in a function, enclose the item name in ____.

To select more than one control, click one of the controls and then hold the SHIFT key down while selecting the others.

You can move a property sheet box but you cannot resize it.

To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

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

To cause each new group section to begin at the top of a page, change the value of the ____ property.

The Book Rep Master List shown in the accompanying figure includes an unbound control. When you enter an expression in the text box it becomes a(n) ____________________ control.