In the following exercises, you will use the data in the Alexamara Marina Group database...

In the following exercises, you will use the data in the Alexamara Marina Group database shown in Figures 1-20 through 1-24. (If you use a computer to complete these exercises, use a copy of the original Alexamara database so your data will not reflect the changes you made in Chapter 3.) If you have access to a DBMS, use the DBMS to perform the tasks and explain the steps you used in the process. If not, explain how you would use SQL to obtain the desired results. Check with your instructor if you are not certain about which approach to take.

If you are using Access 2010, complete the following steps.

a. Add a Currency field named TotalRental to the Owner table. Create and run a query on the MarinaSlip table to determine the appropriate values for this field and then update the Owner table with these values.

b. Create a data macro associated with the After Insert event for the MarinaSlip table to implement the trigger in Step 12a. Test the data macro by adding a row to the MarinaSlip table and ensuring that the TotalRental field for the corresponding owner is updated correctly.

c. Create a data macro associated with the After Update event for the MarinaSlip table to implement the trigger in Step 12b. Test the data macro by changing the rental fee on a row in the MarinaSlip table and ensuring that the TotalRental field for the corresponding owner is updated correctly.

d. Create a data macro associated with the After Delete event for the MarinaSlip table to implement the trigger in Step 12c. Test the data macro by deleting a row from the MarinaSlip table and ensuring that the TotalRental field for the corresponding owner is updated correctly.

Reference: