Exam 5: Creating Reports and Forms

To create labels using the Label Wizard, click the ____________________ button in the Reports group on the Create tab.

In _____ you cannot update the data, but you can make changes to the layout of the form.

You use the _____ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.

Critical Thinking Questions Case 4-1 An employee at Camashaly Design has created the report shown in the accompanying figure but needs some assistance in adding subtotals and grand totals. Camashaly also would like some way to identify clients easily who have a current due amount of zero. How can the employee add subtotals and totals for the Amount Paid column?

To find themes that are not listed in Access but are available for download, click the _____ command.

The Form Footer section appears at the bottom of the form and usually contains a date.

The _____ section appears at the bottom of the form and often is empty.

In Access, mailing labels are a special type of ____________________.

The contents of the ___________________ section print once at the bottom of each page and often contain a date and page number.

To add a date to a form, use the Date and Time button in the Header/Footer group on the Design tab.

Critical Thinking Questions Case 4-1 An employee at Camashaly Design has created the report shown in the accompanying figure but needs some assistance in adding subtotals and grand totals. Camashaly also would like some way to identify clients easily who have a current due amount of zero. How can the employee emphasize those records where the current amount due is $0.00?

Once you decide on a general report style, you should stick with it throughout your database.

When the data in a report is grouped, the contents of the ___________________ section are printed before the records in a particular group.

The Form Header section appears at the top of the form and usually contains the form title.

A form is the appropriate choice if it is necessary to print data.

On a custom form, such as that shown in the accompanying figure, you could add a field by clicking the  ____________________ button on the Design tab.

To filter records on a form, click the Advanced button on the _____ tab to display the Advanced menu.