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

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
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

Quizplus · Accepted Answer

The most expedient way to add the participants and their paid status to the Participants table is to import the data from the Excel spreadsheet into the table. This will save time and effort compared to typing the information for each participant, linking to the spreadsheet, or dragging the spreadsheet over the table.