Change the structure of the What SUP database (Use the Ch10-02 file; do not use the file you just updated in Assignment 1 or 2.)
a. Add the following product to the Product table. ProductID: 117; ProductName: LadyG; Length: 8.5; SupplierID: 6; CategoryID: F; ProductNumber: 3983AE; UnitCost: 620; Reorder Level: 1; Lead Time: 3; Buyer ID: 604; Picture: 117.bmp.
b. Modify the caption and re-size the column width of each field of the Product table so that the table will fit on one page when printed in landscape orientation.
c. Print the Product table in landscape orientation.
d. Create a validation rule for the Reorder Level field of the Product table, making the field a required one and making sure the reorder level is greater than 0 and less than 25 units. Create your own feed-back statement and insert it as the validation text.
e. Establish 7 as the default value for the Lead Time field of the Product table.
f. Establish a phone number input mask for the BuyerPhone field of the Buyers table.
g. Enforce referential integrity between the Product table and the Buyer and Category tables.
h. Print a Relationships report.
i. Print documentation on the properties of the Reorder Level and Lead Time fields of the Product table and the BuyerPhone field of the Buyers table.
j. Save your file as Ch10-02_03_student_name (replacing student_name with your name).