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

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

Importing the data from the Excel spreadsheet into the Participants table would be the most expedient way to add these participants and their paid status to the table. This would save time and reduce errors compared to manually typing each participant's information into the table. Similarly, linking the Excel spreadsheet to the Access database or dragging the spreadsheet over the Participants table may also work, but importing is the best choice. Typing the ParticipantID in the Participants table and linking to the Excel spreadsheet is not a viable solution as this would require manual data entry for each participant's information.

Interns Leah and Santana Are Organizing a Summer Camp for Children