Exam 3: Access: Creating Custom Reports

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

The Page Numbers button, used to add a page number expression to a report, is found in the ____ group on the DESIGN tab.

A report sort field that includes a Group Header section and a Group Footer section is a grouping field.

The Line tool is accessed using the More button in the ____ group on the DESIGN tab.

In the accompanying figure, which numbered arrow indicates the Layout view button?

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

Spacing and punctuation for mailing labels is determined by spacing and punctuation inserted in the ____ box.

Case Based Critical Thinking Questions Case 7- 2 Janise often has requests for specific pet sitters when clients request services. She has created a report that shows the sitter preferred by each client as well as the pet names, pet type, and special requests by the clients. Janise will keep the report handy in digital and printed form for reference when clients call so that she can offer personalized service to her clients. To make the report more user-friendly, Janise needs to make some adjustments. Options for Janise to choose when adding the page number to the bottom of her report pages may be selected from the ____, available from the Page Numbers button in the Header/Footer group on the DESIGN tab.

Options for modifying a report's grouping fields, sorting fields, and report calculations for the groups are available using the ____.

Case Based Critical Thinking Questions Case 7- 2 Janise often has requests for specific pet sitters when clients request services. She has created a report that shows the sitter preferred by each client as well as the pet names, pet type, and special requests by the clients. Janise will keep the report handy in digital and printed form for reference when clients call so that she can offer personalized service to her clients. To make the report more user-friendly, Janise needs to make some adjustments. After printing the report, Janise notices that there is no page number on her report. She would like to add the page number at the bottom of the report. She may add the page number to the bottom of her report in the ____ section of the report.

Which report view is the best to use to see what a report will look like when it is printed?

Case Based Critical Thinking Questions Case 7-1 Carlos is not familiar with creating Access reports and has asked his friend Nina to help him create some useful reports from his organic produce farm data. The organic farm currently has three tables, as illustrated below. Using the information provided, determine the best answers for the questions below. Carlos has asked Nina to create a report that will list all of his customers by last name with their email addresses. To begin creating the custom report after opening the database, Nina will choose the ____ from the CREATE tab on the Ribbon.

The Currency control format adds comma separators and a maximum of two decimal places.

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

In the accompanying figure, which section of the report has a Height property set to zero?

When the Title button on the DESIGN tab is used to insert a title on a report, the title is added to the ___________________ section by default.

A ____________________ report prints the same collection of field values in two or more sets across a page.

To zoom in or out when viewing a report, use ____________________ to view the report.

A typical Group Footer section will include which type of data?

Which section contains content that will appear at the top of every page of a report?