Exam 8: Advanced Report Techniques

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

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

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

To select a table as the basis for a form, display the property sheet and tap or click the ____ arrow.

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.

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

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

To cause the contents of the Group Header section to appear at the top of each page, change the value of the ____ property.

Critical Thinking Questions Case 6-1 An employee at Bavant Publishing needs to make some changes to the report shown in the accompanying figure. The total amount should display as currency with two decimal places. How can the employee make this change?

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

When you change the caption for a form, the name on the tab changes to the new caption in both Form view and Design view.

A report contains three types of controls: bound controls, unbound controls, and formatted controls.

To create a new form in Design view, tap or click the ____________________ button on the CREATE tab.

A combo box combines the properties of a text box and a(n) ____________________ box, which is a box you can use to display a list.

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

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

To display the Group, Sort, and Total pane, click the Group Report button.

When you combine two or more text data items into a single expression, the process is called concatenation .

To change a chart type, press and hold or right-click the chart in Design view, point to Chart Object on the shortcut menu, and then tap or click ____ on the Chart Object submenu.

To sort records within a group, tap or click the ___________________ button in the Group, Sort, and Total pane.