Exam 8: Advanced Report Techniques

To add command buttons to a form, use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

The form in the accompanying figure includes command buttons and a combo box. As you type a name to find in a combo box, Access will display automatically the name that begins with the letters you have typed.

The ____ macro action will move the focus to a specific control.

A(n) ____ is a series of actions that Access performs when a particular event occurs.

To assign a conditional value, use the ____________________ function.

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 change the name for a control, change the ____ property on the property sheet.

You can use either Report view or Print Preview to get an accurate picture of how a final printed report will look.

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 add a Form Header section and a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

You can change titles, legends, and labels for a chart by using the Graph Properties command.

Modified Multiple Choice You can create a report using _____.

To assign a conditional value, use the ____ function.

The On Current event property ensures that the combo box remains current with the rest of the form and is a property of the combo box control.

To delete a control from a report, tap or click the control and then press the ____ key(s).

To ensure that the combo box is kept current with the rest of the form; that is, it contains the name of the customer whose number currently appears in the Customer Number field, modify the ____________________ event property of the entire form.

To change the order of tab controls, press and hold or right-click any tab control and tap or click ____ on the shortcut menu.

The process of converting an unbound control to a bound control is called binding.

The SubForm Wizard displays in the accompanying figure. To add a subform to a form, you use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.