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

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.

Step by Step Solution

★★★★★

3.43 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a AfterInsert data macro b AfterUpdate data macro c A... 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 (978).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

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

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

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

Please helps! PLEASE DO QUESTION 1- 6. Thank you! The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises,...

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

If you are using Access 2016, do the following. Add a field to the Client table named AvailableCredit. Set the field to currency. Create a data macro associated with the After Update event for the...

Assignment 2. (The Text book is;- murach's ASP.NET 4.5 WEB PROGRAMMING WITH VB 2012.) The attached sportspro.Jpg file Attached Files: sportspro.jpg (28.108 KB) 01-DisplayCustomers.pdf (220.31 KB)...

Objective: Create a web page that accesses data from a SQL* data source. You will need to create the TechSupport DB if you have not already. Start by creating a new ASP.NET Web Application project in...

Complete the Heather Sweeney Designs Case Study at the end of the Chapter. Heather Sweeney is an interior designer who specializes in home kitchen design. She offers a variety of seminars at home....

Team Assignment 2 - Charles Book Club Page 1 Second Team Assignment Submission Deadline: Monday, April 25, 11:59 PM Submit two files ONLY to your team folder under Springboard DROPBOX \"Team...

Of the 500 students who attend West Middle School, 95 are boys who play a musical instrument and 75 are girls who play a musical instrument. If 60% of the boys and 40% of the girls who play a musical...

Evergreen Carpets' books show the following data. In early 2013, auditors found that the ending inventory for 2010 was understated by $6,000 and that the ending inventory for 2012 was overstated by...

When a price, wage, or interest rate is adjusted automatically with inflation, it is said to be _ _ _ _ _ _ _ _ _ _ . Question 1 7 options: 1 ) indexed 2 ) COLAed 3 ) nominally adjusted 4 ) semi -...

A new biscuit company is planning to adopt social listening. Which things should they watch out for ? a. Influencers b. Their Brand c. Topics relevant to their business d. Competitors e. All the above

Which of the following defines a DBMS? a. A collection of data that corresponds to one record b. A file used to store data about a single entity c. The person or group in charge of a database d. A...

The Sports Physical Therapy database does not include a field for the hours that the therapist is working. For example, doing any sort of treatment requires set up and break down of equipment,...

In a(n) _____, rectangles represent entities and display their attributes; lines represent relationships between connected entities. a. Entity-relationship (E-R) diagram b. Unstructured data file c....

Greta has risk aversion of A = 3 when applied to return on wealth over a 1 - year horizon. She is pondering two portfolios, the S&P 5 0 0 and a hedge fund, as well as a number of 1 - year strategies....

Question 9 You have $30,000 in a brokerage account now, and you plan to deposit an additional $15,000 at the end of every future year, starting one year from today, and your goal is to accumulate...

The treasurer of Kelly Bottling Company (a corporation) currently has $270,000 invested in preferred stock yielding 11 percent. He appreciates the tax advantages of preferred stock and is considering...