Add, change, and delete records to the What SUP database (use the Ch10-02 file) a. Add the
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, 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).
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen
Question Posted: