Question: 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

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.

Step by Step Solution

★★★★★

3.49 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Open the Branch table in Design view and add the T... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

671-CS-DB (987).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

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...

1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data...

The owner of Colonial Adventure Tours 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 Colonial Adventure...

SQL code 1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a...

can please someone help me with this assignment Solmaris Condominium Group Case In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21...

This is to be written in SQL for MS Access. Questions) 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12 I keep getting syntax errors and I cannot figure out why. 1. Create a view named PenguinBooks. It consists of...

What are the SQL codes? 4. Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name. a. Create an index named TripIndex1 on the TripName field in the...

What are the SQL for below? 10. Change the length of the StartLocation field in the Trip table to 60. 12. Complete the following steps. a. Add a PreviousTrip field to the Customer table. Create and...

In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the...

I Need questions 1-5. Thank you! -- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database --...

The following represents the potential outcomes of your first salary negotiation after graduation: Assuming this is a sequential move game with the employer moving first, indicate the most likely...

A cyclic machine, shown in Fig. P7.50, receives 325 kJ from a 1000 K energy reservoir. It rejects 125 kJ to a 400 K energy reservoir and the cycle produces 200 kJ of work as output. Is this cycle...

Refer to Exercise 6.41, describing a study about pet ownership and marriage. Explain whether each of the following is likely to be a problem for that study: a. Confounding variables and the...

At what traffic temperature does the audience show interest in what the company is offering ? a. Cold Traffic b. Hot Traffic c. Warm Traffic .

Assume that the Pitt Fitness accountant has met with the owner to discuss how to handle payments and balances. They both decide to add fields to the Customers table to record any payments arriving...

What best describes a null value? a. A zero-length string, b. A space or tab character c. An intentional nothing d. The string "null"

Using Access, an employee at JC Consulting tried to delete TaskID CODE01 from the TaskMasterList table and received the following error message: The record cannot be deleted or changed because table...

On November 14, Thorogood Enterprises announced that the public and acrimonious battle with its current CEO had been resolved. Under the terms of the deal, the CEO would step down from his position...

MCentral Heating Co. is considering a project with the following financial characteristics: Fixed capital outlay is $1.5 billion Investment in net working capital is $0.4 billion. Straight-line...

Compare the natural uranium fuel needs in the case of the PWR design to the CANDU design.