Change the length of the LastName field in the Owner table to 30.
If you are using Access 2013, complete the following steps.
a. Add a Currency field named TotalFees to the Location table. Create and run a totals query on the
CondoUnit table to determine the total fees by location and then manually update the Location table with
these values.
b. Create a data macro associated with the After Insert event for the CondoUnit table to add the condo fee
to the total fees for the appropriate location when adding a record to the CondoUnit table. Test the data
macro by adding a row to the CondoUnit table and ensuring that the TotalFees field for the corresponding location is updated correctly.
c. Create a data macro associated with the After Update event for the CondoUnit table to add the difference
between the new condo fee and the old condo fee to the total fees for the appropriate location. Test the
data macro by changing the condo fee on a row in the CondoUnit table and ensuring that the TotalFees
field for the corresponding location is updated correctly.
d. Create a data macro associated with the After Delete event for the CondoUnit table to subtract the condo
fee from the total fees for the appropriate location when deleting a row in the CondoUnit table. Test the
data macro by deleting a row from the CondoUnit table and ensuring that the TotalFees field for the
corresponding location is updated correctly.