If you are using Access 2013, complete the following steps.
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 value 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 Reservation 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.