The book is Concepts of Database Management 8th Edition. Pratt/Last. Question 12 from Colonial Adventure Tours Case. I think we need to be in Table Tools, however, the book doesn't teach us how to...

The book is Concepts of Database Management 8th Edition. Pratt/Last.

Question 12 from Colonial Adventure Tours Case. I think we need to be in Table Tools, however, the book doesn't teach us how to access it and our teacher doesn't teach or answer questions. I am only familiar with query design. If you could teach me "how to fish" so I can learn how to do this for myself, I would appreciate any help you could offer. Thanks.

A) Add a PreviousTrip field to the Customer Table. Create and run a totals query on the Reservation Table to count the number of reservations by customer. Manually update the Customer table with these values. Assign the 0 to customers 110 and 123.

B) Create a data macro associated with the After insert event for the Reservation table to increment the PreviousTrip field for the appropriate customer when inserting a row in the Reservations table. Test the data macro by adding a record to the Reservation table and ensuring that the corresponding customer's previous trip total is updated correctly.

C) Create a data macro associated with the After Delete event for the Reservation table to subtract one on the record being deleted from the customer's previous trip total. Test the data macro by deleting a record from the Reservation table and ensuring that the corresponding customer's previous trip total is updated correctly.