FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Access: Creating Reports and Forms

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

conditiona...

View Answer

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

Identify the letter of the choice that best matches the phrase or definition.

The ____ aggregate function finds the largest value.

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

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

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

Identify the letter of the choice that best matches the phrase or definition.

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.

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 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.

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.

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

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

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

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