MOS Access: Queries, Forms and Reports 5

Question 1

You need to group a report by Category and add a subtotal for each category. Which tool do you use to add the grouping?

Accepted Answer

Group, Sort, and Total pane

Answer

The Group, Sort, and Total pane adds groups, sorts, and totals to a report.

Question 2

Where should a =Sum([Amount]) text box go to show a subtotal for each group?

Accepted Answer

Group Footer

Answer

A Group Footer calculates and displays totals for each group's records.

Question 3

Which report section prints only once, at the very beginning of the report?

Accepted Answer

Report Header

Answer

The Report Header appears once on the first page of the report.

Question 4

Where are page numbers typically placed so they appear at the bottom of every printed page?

Accepted Answer

Page Footer

Answer

The Page Footer prints at the bottom of every page.

Question 5

A group is split across two pages. Which setting keeps each group on a single page when possible?

Accepted Answer

Keep whole group together on one page

Answer

The Keep Together option in the Group, Sort, and Total pane prevents groups from splitting across pages.

MOS - Microsoft Office Specialist Certification Practice Test