Multiple Choice
Case-Based Critical Thinking Questions Case 2-2
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
Correct Answer:

Verified
Correct Answer:
Verified
Q2: Field names in a table may only
Q3: The F6 key toggles the Access table
Q18: In the Database Design grid,press the Enter
Q20: List six guidelines for designing databases.
Q37: One rule of _ is that Access
Q40: The data type that allows both sequential
Q52: The _ property allows the database designer
Q66: In a single table,all _ must be
Q75: A database system determines how to store,display,and
Q98: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9148/.jpg" alt=" The accompanying figure