Exam 8: Analyzing Data With Reports Question

One feature of a report is that it gives you flexibility in presenting summary information.

Kelsey uses Access to track the sales by category for each tour. Referring to the figure above, what is the name of the field she should use in an expression to total the sales?

In the figure above, the expression =Sum([Revenue])is contained in a text box in both the Category Footer as well as Report Footer sections.Explain the difference between these two controls.

How are lines used in a typical Access report?

Conditional formatting in Access 2010 allows you to compare the values of one column to another with small data bars.

Report section properties cannot be modified to improve report printouts.

Report Design View gives you full control of all aspects of a report.

The Format ____________________  is a handy tool used to copy formatting properties from one control to another.

What type of line under a value indicates grand totals?

In the figure above, what kind of control is not found in the Report Footer section?

Discuss two reasons you might want to modify section properties in a report.

A parameter report is based on a parameter query by setting the report's ____ property.

Which section prints at the top of the first page of the report?

You can print data from forms, datasheets, or reports.

Report section ____________________  are the characteristics that define each section.

Themes can include font, color, and alignment choices.

In the figure above, what is the grouping field?

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

The ____________________  object gives you more control over how data is printed than forms and datasheets.

In the figure above, which section does not contain any controls?