Exam 3: Access: Creating Custom Reports

Discuss four report design guidelines that should be followed when planning a report design.

The combination of the keys ____________________on the keyboard will select all items in a report when viewing a report in Report view.

A label control must be used when a report requires a specific date that is not the current date.

The Group, Sort, and Total pane is used to select sort fields and grouping fields for a report.

What is the maximum number of sort fields that can be included in a report?

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. Some of Janise's clients have more than one pet. The current version of the report shows the client's information for each pet the client has listed with Janise's pet sitting service. Janise would like for the client information to appear only once on the report but still see each pet and the pet's information listed. The report is sorted on the Client's last name. Which property should Janise set to YES for the client information fields to obtain the results she wants?

The default theme for Access database objects uses the ____________________ font.

Page numbers must be added to a report in Design view.

Which of the following is an advantage of using a query as a record source for a report?

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. Janise notices, after viewing the report in Report view, that the Special Requests field does not show all of the data she needs to view. Which property should she change for the text box containing the Special Requests field information?

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view.

Placing the report title, date, and page number on the same line in the ____ is a common report standard.

List 3 reasons to create a custom report.

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

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. Next, Nina needs to add the fields FirstName, LastName, and EmailAddress to the report. She must select ____ from the DESIGN tab while in the Report Layout Tools section of the Ribbon.

Yes/no and true/false fields are represented with check boxes in a report.

In the accompanying figure, which numbered arrow indicates a number formatted in the Standard format?

In the accompanying figure, the page number control is set to display the page number in which manner?

A custom report may be created using Layout view or Design view.