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?
A) Hide Duplicate Values
B) Special Effect
C) Display When
D) Sort

Question

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?
A) Hide Duplicate Values
B) Special Effect
C) Display When
D) Sort

Quizplus · Accepted Answer

Setting the "Hide Duplicate Values" property to YES will allow Janice to have the client information appear only once on the report while still showing each pet and the pet's information listed. This means that any duplicate client names will not be shown on the report, therefore achieving the desired outcome.