Problem

Ray Henry would like you to complete the following tasks to help him maintain his databa...

Ray Henry would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Henry Books database shown in Figures 1-17 through 1-20 in Chapter 1. (If you use a computer to complete these exercises, use a copy of the original Henry Books 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.

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.

Reference:

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search