In Chapter 9 you created a database for the Wine Depot consisting of a Wine Products table, a Winery table, and a Buyer table. You also created an initial query, form, and report. Barbara has now asked you to make some changes to those files. Make the following changes for Barbara using the ch9-04_student_name file you created in Chapter 9. (Note: Open your ch9-04_student_name file first, save it as ch 10-04_student_name, and then make the listed changes.)

a. Add buyer 105, Carly Simon, 555-6874 to the Buyer table.

b. Add winery 20 (Robert Mondovi, American, 105) and winery 21 (Wente, American, 104) to the Winery table.

c. Delete wines with SKU 15966 and 16769.

d. Delete winery 2.

e. Add the following records to the Wine Products table:

f. Enforce referential integrity between the tables.
g. Print the Relationships report.
h. Add a Picture field for OLE objects to the Wine Products table.
i. Add pictures to the Wine Products table for products 11475, 12384, 12895, 14539, and 15347. And are labeled with the SKU number)
j. Establish a phone number input mask for the Phone field of the Buyer table, and then change all the phone numbers in the table to include an area code of 805.
k. Create a validation rule for the Price field of the Wine Products table, making the price field required and making sure the price is no less than $ 1 but no more than $ 100. Create your own feedback statement and enter it as the validation text. Save the changes you made.
1. When creating your validation rule, you might well have checked to see if the data already stored actually met that rule. If you did check, you found that the validation rule was in conflict with some of the existing data. Change the rule so that the price must be no less than $ 1 but now no more than $200. Create your own feedback statement and enter it as the validation text. Save the changes you made.
m. Establish a default value of 750 for the Size field of the Wine Products table.
n. Resize the column width of the Wine Products table so that it can fit on one page when printed in landscape orientation.
o. Print each table.
p. Print documentation on the properties of the Phone field of the Buyer table and the Price field of the Wine Products table.

Transcribed Image Text:

SKU Winery Price Cost Size Vintage Quantit 12564 Merlot 12895 Sauvignon Blanc 4 16900 Syrah 11350 Pinot Noir 11475 Pinot Noir 12380 Pinot Noir 12383 Chardonnay 12384 Fume Blanc 21 12.99 8.00 15.49 9.00 24.00 18.00 30.00 24.00 22.00 7.50 21.00 18.00 18.00 12.00 17.49 11.00 750 750 750 750 750 750 750 750 2000 2002 2001 2001 2001 2000 2000 2001 12 12 48 24 36 36 20 20 20