Exam 9: Workshop 9: Advanced Reports and Mailing Labels

Reports have a grouping feature allowing records to be presented in sets.

When reports are built from parameter queries,running the report yields different results depending on the parameter value entered.

A ________ is a value that can be changed each time you run the query.

The default information contained in the Report Header is the column headers,which are taken from the captions from the table design.If no captions were defined,the values are field names.

The ________ lets you control how information is sorted and grouped in a report.

The duplicate values can be hidden using the ________.

If you add a logo or date and time,they appear in the ________.

The default information contained in the ________ is the column headers,which are taken from the captions from the table design.

Layout view is ideal for making changes where seeing the data as you make the change would be useful.

The Report Header contains the information printed at the top of every page of a report.

Reports provide ways to report on data by groups,such as by each customer or product.

In the Report Wizard,the one-to-many grouping is the first grouping suggested to you.

Which of the following is NOT true about conditional formatting?

You can create a report with an embedded graph or image.

The ________ tool creates a blank report in Design view.You add fields or other controls to the design.

The ________ contains the information printed at the beginning of every group of records.

The ________ selects the fields you want and formats the report with headers and footers for grouping.

Access has a Group & Sort feature that simplifies the addition of groups and totals.It can be used in Report view.