FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Access: Creating Custom Reports

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) a count or subtotal for records in that group
B) the date and time the report was generated
C) the report page number
D) detail fields for all records included in the group

E) A) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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 numbered arrow indicates the Layout view button?

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

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

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.

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

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

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

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

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

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 Line tool is accessed using the More button in the ____ group on the DESIGN tab.

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.

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

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

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

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.

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