Case-Based Critical Thinking Questions Case 2-2

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

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