Exam 1: Access: Creating Reports and Forms

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

In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to choose values to be totaled and where they are to appear.

When you assign a theme to any object in the database, the theme immediately applies to all reports and forms in the same database, unless you specifically indicate otherwise.

The contents of the ___________________ section print once for each record in the table.

When working with a form, such as that shown in the accompanying figure, there are three different ways to view the form. They are Layout view, Form view, and ____________________ view.

You can emphasize values in a column that satisfy some criterion by formatting them differently from other values. This emphasis is called ___________________.

Modified Multiple Choice Available aggregate functions for use in a report include ____.

Modified Multiple Choice When working with a report in Access, the different ways you can view the report include ____.

To add a title to a report, tap or click CREATE on the ribbon and then tap or click the ____ button on the DESIGN tab.

To create a report in Layout view, tap or click the ___________________ button in the Reports group on the CREATE tab.

The ____ aggregate function finds the largest value.

To clear a filter, click the ____________________ command on the Advanced menu.

A control layout is a guide that aligns the controls to give the form a uniform appearance.

Design view is most useful when the changes you need to make to a report are complex.

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

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, tap or click the CREATE tab, and then tap or click the ____ button.

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

To add more space between groups, enlarge the group header or group footer.