Case 1-1Lisel Is the Student Body President of Her College

question 16

Short Answer

Case 1-1Lisel is the Student Body President of her college. She is organizing a Fun Run/Walk fund-raising event to benefit the local Children's Hospital. Lisel wants to create an Access database to manage event vendors, the venue, participants, donors, and donations. Before the event takes place, Lisel and the student government representatives must contact vendors and ask for their participation in the event. Also, participants in the event must be registered and issued an entry number.
Three tables are necessary for the database: Vendors, Participants, and Venue. Fields in the Vendors table will include: Vendor Name, Vendor Contact Information, Venue Space Assigned. Fields in the Participants table will include: FirstName, LastName, ParticipantNumber, Donation, and Donors. The Venue table will include: TentNumber and TentSize. Choose the best answer for the questions below.Laquan, another student representative, has the responsibility of contacting the vendors for the event and assigning tent spaces to them. He needs to view data that uses fields from both the Vendor table and the Venue table. Which database tool would create the most concise list of vendors, vendor contact information, and assigned tent spaces: a query, a table, or a form?

---

Definitions:

Third-Party Payors

Entities (usually insurance companies or government programs) that pay for healthcare services on behalf of patients, rather than direct payments by patients.

Sterling Foundation

An organization or entity established for the purpose of managing assets or funds for charitable, educational, or similar goals.

Program Service Expenses

Costs directly incurred in carrying out the operational activities aligned with the mission of a non-profit or governmental organization.

Supporting Service Expenses

Costs incurred by a business or organization for activities that aid the operation but do not directly contribute to the main business activity.