Exam 3: Access: Advanced Report Techniques

To add a subreport to a report, use the Text Box tool on the REPORT DESIGN TOOLS DESIGN tab.

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

To spread data over two lines, change the value of the ____ property.

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

If the primary key of the Seminar Offerings table contains the primary key for both the Customer table and Seminar table, there is a ____ relationship between customers and seminars.

To include a name for a calculated field in a query, type the name in the ____________________ property box in the property sheet.

To concatenate text data, you use the asterisk (*) operator.

The Book Rep Master List shown in the accompanying figure includes an unbound control. To place this control on a report, tap or click the ____________________ tool on the REPORT DESIGN TOOLS DESIGN tab.

When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.

To preview a report when you are working in Design view, click Print Preview on the Report button menu.

To select a smaller font size for a control, use the ____________________ property.

The expression =[First Name]&' '&[Last Name] is entered in a text box on the Book Rep Master List. What is the result of this expression?

To ensure that a calculated control displays as currency, change the ____ property.

To change the format for a control, press and hold or right-click the control and then tap or click Format on the shortcut menu.

To display the Expression Builder dialog box and enter an expression in a text box, tap or click the Build button in the ____________________ property box on the property sheet.

To extend a heading over two lines, tap or click in the appropriate position to produce an insertion point and then press the ____ key(s).

If a name is too long to fit in the available space, change the Can Grow property to Yes so that the name will extend to additional lines.

To create an initial report in Design view, tap or click the ____________________ button on the CREATE tab.

To reverse the most recent change to a report, tap or click the ____ button on the Quick Access Toolbar.