If you are using Access 2010, complete the following steps.
a. Add the TotalValue field to the Branch table. Create and run a query on the Copy table to determine the appropriate values for this field, and then update the Branch table with these values.
b. Create a data macro associated with the After Insert event for the Copy table to implement the trigger in Step 13a. Test the data macro by adding a record to the Copy table and ensuring that the corresponding branch’s total value is updated correctly.
c. Create a data macro associated with the After Update event for the Copy table to implement the trigger in Step 13b. Test the data macro by changing a price on a record in the Copy table and ensuring that the corresponding branch’s total value is updated correctly.
d. Create a data macro associated with the After Delete event for the Copy table to implement the trigger in Step 13c. Test the data macro by deleting a record from the Copy table and ensuring that the corresponding branch’s total value is updated correctly.