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

Considering the table in the figure above, which data type is best suited for the ActivityStartTime and the ActivityEndTime fields?
A) Date/Time
B) Number
C) Memo
D) Short Text

Question

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

Considering the table in the figure above, which data type is best suited for the ActivityStartTime and the ActivityEndTime fields?
A) Date/Time 
B) Number 
C) Memo 
D) Short Text

Quizplus · Accepted Answer

The ActivityStartTime and ActivityEndTime fields both involve time values, so the most appropriate data type for these fields would be Date/Time. This allows for easy sorting and manipulation of the time data.