Exam 8: Advanced Report Techniques

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

The form in the accompanying figure has no title. When you add a title to a form using the Title button, Access uses the name of the object instead of the caption as the title.

If the label for a combo box is Name to Find: and the N is underlined, the user can select the combo box by pressing ____________________+N.

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.

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

To remove the Group, Sort, and Total pane when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

To change the appearance of a control so that text in the control displays in a different color, change the ____ property for the control.

To ensure that a combo box will appear within a rectangle, change the ____ property to Transparent.

The accompanying figure shows command buttons on a form. The action for the Delete Record button is Delete Record, which is in the ____________________ category.

The Form Wizard and the Form button are two of several tools that you can use to create a form.

To ensure that the data in a combo box is sorted correctly, tap or click the combo box control, tap or click the Property Sheet on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____________________ property.

To insert a chart, use the Chart tool on the FORM DESIGN TOOLS DESIGN tab.

Modified Multiple Choice The Record Navigation category includes the ____ actions.

To insert a chart, use the Graph Object tool on the FORM DESIGN TOOLS DESIGN tab.

To periodically view a report to gauge how it will look containing data, tap or click _____ on the View menu.

To change the background color of a form, use the Background Color button on the FORM DESIGN TOOLS FORMAT tab.

A(n) ____________________ form is a form that contains more than one page of information.

To modify the query that Access creates for a combo box, tap or click the Row Source property for the combo box and then tap or click the ____ button.

If a Security Warning appears when you open a database, tap or click the ____ button.