Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is a two - part exercise: a . Create a script that creates to tables named InvoiceCopy and VendorCopy that contain all of the
This is a twopart exercise: a Create a script that creates to tables named InvoiceCopy and VendorCopy that contain all of the records from the Invoices and Vendors table. b Create a script that contains a set of action queries coded as a transaction. The first action should update the VendorCopy table by changing the VendorName Data Reproductions Corp to DRC The second action should update all invoices for Data Reproductions Corp so that their invoice numbers include the prefix DRC example; DRC with being the original invoice number
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started