CAT Grade 12 Module 5 AMA Quiz

Guides you through a series of questions and then generates a report based on your answers.

• Find command
• Sort
• Report Wizard
• Report

True or False

You can only add grouping to a report when you create a report in the Report Wizard.

• True

• False

Which Tab menu should you navigate to if you want to add grouping to an existing report?

• Database Tools

• Report Design

• Arrange

• Page Setup

To insert text in a report header or footer which control should you use?

• Text box

• Label

• Button

• Field

To insert a calculated field in a report which control should you use?

• Text box

• Label

• Button

• Field

Which calculation is correct if you want to determine the total payments amount in a report?

• =TOTAL([Payments])

• =TOTAL(Payments)

• =SUM(Payments)

• =SUM([Payments])

When you want to add calculations to your report in the Report Wizard which option must you select?

• Summary

• Grouping

• Functions

• Calculations

Which calculation is NOT an option you will find in the Summary Options in the Report Wizard?

• SUM

• COUNT

• MAX

• AVG