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?

Question

Quizplus · Accepted Answer

The Answer of 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?

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