Exam 8: Advanced Report Techniques

Describe three ways that you can create a calculated field in a query.

To place a rectangle around a combo box, use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

You can align controls in the Report Design window using the Align button on the REPORT DESIGN TOOLS ____ tab.

To import a text file, tap or click the ____ button on the EXTERNAL DATA tab.

In the accompanying figure, the Seminar Offerings table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

To change the appearance of a control so that it appears sunken, change the ____ property for the control.

To display a field list, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group.

The Book Rep Master List shown in the accompanying figure includes an unbound control. The process of converting an unbound control to a bound control is called ____________________.

To find the largest value, use the LARGE aggregate function.

To modify a macro associated with a command button, press and hold or right-click the command button and tap or click ____ on the shortcut menu.

The Book Rep Master List shown in the accompanying figure includes an unbound control. You could enter an expression in this control to combine two or more text data items. The process of combining these items is called ____________________.

The form in the accompanying figure includes command buttons and a combo box. When you create an Add Record command button using the Command Button Wizard, the button automatically places an insertion point in the first field on the form.

When the Control Wizard is used to create a combo box, the values in the combo box are sorted in alphabetical order automatically.

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

The contents of the ____ section are printed after the records in a particular group.

To change the On Current property for a form, tap or click the form selector for the form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group, and then tap or click the On Current property.

To add a concatenated field to a form, use the ____________________ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.

The form in the accompanying figure includes command buttons and a combo box. To select an entry from a combo box, press the TAB key.