Interns Leah and Santana Are Organizing a Summer Camp for Children

question 5

Multiple Choice

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

---

Definitions:

Pension Plans

Financial programs provided by employers, offering income to employees following retirement based on their earnings and years of service.

Privately Held Organizations

Companies owned by private individuals or groups and not traded publicly on the stock market.

Contributory

Involving or denoting a pension, insurance plan, or other benefit scheme where both employers and employees make payments towards the cost.

CPP/QPP

Refers to Canada Pension Plan/Quebec Pension Plan, which are public pension plans in Canada designed to provide income for workers upon retirement.