Exam 8: Advanced Report Techniques

To copy a control, tap or click the Copy button on the ____ tab.

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

To ensure the data is sorted in the correct order, you change the Row Sourc e property for the combo box.

To open a form, press and hold or right-click the form in the Navigation Pane, and tap or click ____ on the shortcut menu.

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

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.

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 copy the formatting of one control to other controls, use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

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

To display the Group, Sort, and Total pane, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

If you link an Excel workbook to an Access database, you can edit the linked table in Access.

With a(n) ____, you can enter a value either by typing the value or by selecting it from a list.

To display the property sheet for grouped controls, tap or click the ____________________ button on the REPORT DESIGN TOOLS DESIGN tab.

The ____ aggregate function finds the smallest value.

You can convert macros that are attached to forms to VBA (Visual Basic for Applications) code.

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

To activate a wizard to help in creating combo boxes and command buttons, make sure the ____ button is selected.

The form in the accompanying figure includes command buttons and a combo box. If a form includes an Add Record button, tapping or clicking the button will clear the contents of the form so you can add a new record.