In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL Distributors 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 uncertain about which approach to take.

If you are using Access 2013, create the following data macros.

a. Create a data macro associated with the After Insert event for the Customer table to add the customer’s balance multiplied by the rep’s commission rate to the commission for the corresponding rep when adding a customer. Test the data macro by adding a customer and ensuring that the corresponding rep’s commission is updated correctly.

b. Create a data macro associated with the After Update event for the Customer table to add the difference between the new balance and the old balance multiplied by the rep’s commission rate to the commission for the corresponding rep when updating a customer. Test the data macro by changing a customer’s balance and ensuring that the corresponding rep’s commission is updated correctly.

c. Create a data macro associated with the After Delete event for the Customer table to subtract the balance multiplied by the rep’s commission rate from the commission for the corresponding rep when deleting a customer. Test the data macro by deleting a customer and ensuring that the corresponding rep’s commission is updated correctly.