Case-Based Critical Thinking Questions
Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
∙ Participant Information
∙ Parent Information
∙ Employees
∙ Activities
-Leah and Santana have been requested to print a daily report of scheduled activities. Their supervisor needs to know if each participant has paid for the activity. The ParticipantPD field will be included in the report. Which data type will allow the report to display a true/false condition for the ParticipantPD field?
A)Short Text
B)Number
C)Yes/No
D)Currency

Question

Case-Based Critical Thinking Questions
Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
∙ Participant Information
∙ Parent Information
∙ Employees
∙ Activities
-Leah and Santana have been requested to print a daily report of scheduled activities.  Their supervisor needs to know if each participant has paid for the activity.  The ParticipantPD field will be included in the report.  Which data type will allow the report to display a true/false condition for the ParticipantPD field?
A)Short Text
B)Number
C)Yes/No
D)Currency

Quizplus · Accepted Answer

The "Yes/No" data type is the most appropriate choice for the ParticipantPD field because it allows for a true/false condition to be displayed, indicating whether or not the participant has paid for the activity. The other data types (Short Text, Number, and Currency) do not have the necessary functionality to display a binary condition.