Case-Based Critical Thinking Questions Case 2-2

question 16

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
Several participants registered for activities late as other participants cancelled.  These participants need to be added to the Participants table.  What is the most expedient way to add these participants and their paid status to the Participants table?

• A) type the information for each participant in the Participants table in datasheet view
• B) import the data from the Excel spreadsheet into the Participants table
• C) type the ParticipantID in the Participants table and link to the Excel spreadsheet
• D) drag the Excel spreadsheet over the Participants table and the table will be updated