If you are using Access 2010, create the following data macros.
a. Create a data macro associated with the After Insert event for the Customer table to implement the trigger in Step 12a. Test the data macro by adding a customer and ensuring that the corresponding sales rep’s commission is updated correctly.
b. Create a data macro associated with the After Update event for the Customer table to implement the trigger in Step 12b. Test the data macro by changing a customer’s balance and ensuring that the corresponding sales rep’s commission is updated correctly.
c. Create a data macro associated with the After Delete event for the Customer table to implement the trigger in Step 12c. Test the data macro by deleting a customer and ensuring that the corresponding sales rep’s commission is updated correctly.