Exam 13: Creating Advanced Reports

-In the figure above, which chart would you most likely use to show cumulative totals in a stacked arrangement?

Which chart type would best illustrate the contribution of three products to total company sales for a given year?

The Page Numbers button is found on the VIEW tab of the ribbon. _________________________

Match the report problems with the probable solution. -Numbers should be formatted with a Currency format.

-The chart in the figure above is an example of a 3-D chart.

To change the color of the bars on a chart you must work in Report View. _________________________

-Three-dimensional charts are always more effective than two-dimensional charts.

The domain in a domain aggregate function is the ____ that contains the field used in the calculation.

-In the figure above, which chart would you most likely use to show comparisons of values, such as annual sales for a different product for several sales representatives?

-In the figure above, item 6 points to the ____.

Explain the purpose of grouping controls together in a report table layout.

What is the second argument in the DLookup function?

Match the report problems with the probable solution. -Switch to Report Design View to open more report sections and add controls.

The Stacked layout is most often used in reports.

The text in a form or report tab is determined by the form or report's Title property. _________________________

The ____ layout is most often used in forms.

Match the report problems with the probable solution. -Create an expression in a text box to combine the first and last names, needs to be entered in one text box.

Charts can be added to forms or queries. _________________________

-In the figure above, which property is being modified?

The first step in creating a chart is to ____.