Question: Add, change, and delete records to the What SUP database (use the Ch10-02 file) a. Add the following record to the Buyers table: BuyerID 605,

Add, change, and delete records to the What SUP database (use the Ch10-02 file)
a. Add the following record to the Buyers table: BuyerID 605, Farley, 555-7187.
b. Add G as a CategoryID with a CategoryName of Women’s as a category to the Category table.
c. Delete the following record from the Buyers table: BuyerID 601.
d. Change the buyer for the following Product IDs from buyer 601 to buyer 605: Product ID 104, 108, 113, and 115.
e. Print the first page of the product, buyers, and category tables as modified in a landscape orientation.
f. Save your file as Ch10-02_01_student_name (replacing student_name with your name).

Step by Step Solution

3.43 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Product table Buyers table Category table Product ID Product Name 101 Vene... View full answer

blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Using Microsoft Excel Questions!