Exam 7: Advanced Report Techniques

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

The Business Analyst 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.

To add page numbers to a report, click the _____ button on the Design tab.

To ungroup controls, click any of the controls in the group, and click the Ungroup button on the _____ tab.

To import a text file, click the _____ button on the External Data tab.

Modified Multiple Choice The Sizing & Ordering group on the Arrange tab includes the _____ buttons relevant to aligning and adjusting controls.

To change the report margins, use the Margins button on the Page Setup tab.

The process of combining two or more text data items into a single expression is called concatenation.

To add a page number to a report, use the Report Footer button.

Modified Multiple Choice The property sheet includes the _____ tabs.

To add a text box to a report, click the _____ tool in the Tools group on the Design tab.

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

To sort records within a group, click the ___________________ button in the Group, Sort, and Total pane.

The report needs a title. How can the employee add a title?

To copy a control, click the Copy button on the _____ tab.

To display the Expression Builder dialog box, click the Build Expression button on the Design tab.

To assign a conditional value, use the ____________________ function.

The ____ aggregate function finds the smallest value.

To cause the contents of the Group Header section to appear at the top of each page, change the value of the _____ property.