Access: Queries, Forms and Reports Flashcards

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

Answer: Group, Sort, and Total pane

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

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

Answer: Group Footer

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

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

Answer: Report Header

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

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

Answer: Page Footer

The Page Footer prints at the bottom of every page.

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

Answer: Keep whole group together on one page

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

You want a text box to show a cumulative total that restarts for each group. Which property should you set?

Answer: Running Sum to Over Group

Running Sum set to Over Group accumulates values and resets at each new group.

Where can you change a report's orientation to landscape before printing?

Answer: Page Setup tab or Print Preview

Orientation and margins are set from the Page Setup tab or the Print Preview tab.