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 1

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

To emphasize a particular value, use con...

View Answer

Show Answer

Question 3

True/False

Review LaterAdd Note

You can print all the records, a range of pages, or a selected record of a form by selecting the appropriate print range.

When working with a form in Access, there are three ways you can view a form. What are these three ways and what does each view allow you to do?

When you create reports and forms, you should follow some general guidelines for report and form design. What are these eight guidelines?

To add a date to a form, tap or click the ____ button on the DESIGN tab.

To add totals or other statistics to a report, use the ____ button on the DESIGN tab.

The body of the form is in the ____ section.

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

You can use the filter buttons in the Sort & Filter group on the Home tab to filter records in a report.

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

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 customize the group title.

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

The ____ aggregate function finds the smallest value.

The various objects on a report are called tools.

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

The ____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

You can use forms to add records, delete records, or change records.

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

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