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.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.