The Wine Depot is interested in more effectively managing their inventory. Barbara would like you to put together a database of their current wine inventory. Create a new database file using the following information and name the file ch9-04_student_name (replacing student name with your name).

a. Use the following information to create and print a wine products table, a buyer table, and a winery table. Use the field Name in the Buyer and Winery tables even when you are warned against using a reserved name.

b. Establish the appropriate relationship between each table and then print the relationships report.
c. Create and print a query that lists SKU, Type, Winery, Buyer, and Buyer Phone for all products. (Save as Wine Products Query 1.)
d. Create and print a form for entering new products; use whatever style you'd like. (Save the form as Wine Products Form 1, and print the first record only.)
e. Create and print a report with the fields Type, Name (Name of Winery), Vintage, and Price for all products. The report should be sorted by Type in ascending order and be formatted in a Tabular layout with Portrait orientation. (Save the report as Wine Products Report 1.) All field information should be visible.

Transcribed Image Text:

SKU T Wine Price Cost Size Vinta Quantit 13883 Chardonnay 14539 Merlot 15347 Cabernet Sauvignon 3 15966 Pinot Noir 16528 Chardonnay 16554 Sauvignon Blanc 16716 Chardonnay 16739 Chardonnay 16769 Syrah 16874 Syrah 17024 Sauvignon Blanc 17275 Sauvignon Blanc 17425 Zinfandel 17454 Sauvignon Blanc 17521 Chardonnay 17539 Caberet S 19 75.00 45.00 750 2000 17549 Zinfandel 17578 Cabernet Sauvignon 12 17840 Red Chianti 41.00 24.60 7501998 36.00 21.60 750 1999 120.00 72.00 750 989 65.00 39,00 750 30.00 18.00 750 200 21.00 12.60 750 2001 20.00 12.00 750 200 61.00 36.60 750999 34.00 20.40 750 2000 35.00 21.00 750 2000 22.00 13.20 750 2001 16.00 9.60 750 28.00 6.80 750 2001 15.00 9.00 750 2002 24.00 14.40 750 200 12 1999 24 8 10 15 10 2002 10 4 22.00 13.20 750 2000 11.00 6.60 750 2001 32.00 19.20 7501999 12 Buyer Name Phone 101 James Taylor 102 Johnny Rivers 103 Michael Jackson 104 Aaden Mikowicz 555-1245 555-8794 555-9743 555-2914 Wine Name Location Buyer Babcock Bass Phillip Beringer Brander Cafaro Carhartt Clarendon Gainey America Australia America America America America Australia America 101 104 101 101 101 101 104 102 9 Location Buyer Wine Name 102 102 102 104 New Zealand 104 South Africa 103 103 104 103 103 103 America America America Chile Gary Farrell Joel Gott Melville Miguel Torres MudHouse Neil Ellis Neyers San Vincenti Talbot Voss Woodward 10 12 13 14 15 16 America Italy America America America 19