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:

Sunk Cost

A cost that has already been incurred and cannot be recovered.

Contribution Format

An income statement format that separates fixed and variable costs, showing contribution margin which is sales revenue minus variable costs.

Contribution Margin

The amount by which sales revenue exceeds variable costs of production, indicating how much contributes to covering fixed costs.

Variable Expenses

Costs that vary in proportion to changes in the level of activity or volume of production.