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

question 30

Short Answer

Case 1-1
Lisel 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:

Statute of Frauds

A legal requirement for certain types of contracts, such as those involving real estate, to be in written form to be valid.

Sales Contracts

Sales contracts are formal agreements between a buyer and seller detailing the terms of a transaction of goods or services.

Retail Arena

The overall retail environment or marketplace where businesses sell goods and services to consumers.

UCC

The Uniform Commercial Code, a set of laws that provide legal rules and regulations governing commercial or business dealings and transactions in the United States.