U Spreadsheet Software Access WINE DEPOT The Wine Depot is interested in more effe 1 together a databa repot is interested in more effectively managing their inventory. Barbara would like you to put er a database of their current wine inventory Create a new database file using the following information and name the file First Name La Initial-Access I. a. Use the following information to create the following information to create and print a wine products table, a buyer table, and a winery table. Use the field N use the field Name in the Ruver and Winery tables even when you are warned against using a reserved name. Table Structure: Table Fleid Name Data Type Buyer Buyer Number Name Short Text Phone Short Text Wine Products Number Type Short Text Winery Number Currency Cost Currency Number Vintage Number Quantity Number Winery Number Name Short Text Location Short Text Buyer Number Price Winery Quantity 15 18 SKU Type 13883 Chardonnay 14539 Merlot 15347 Cabernet Sauvignon 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 Cabernet Saun Cabernet Sauvignon 17549 Zinfandel 17578 Cabernet Sauvignon 17840 Red Chianti Winery Price Cost Size 41.00 24.60 750 36.00 21.60 750 3 120.00 72.00 750 65.00 39.00 750 30.00 18.00 750 21.00 12.60 750 20.00 12.00 750 75.00 45.00 750 6 34.00 20.40 750 35.00 21.00 750 22.00 13.20 750 16.00 9.60 750 28.00 16.80750 13 15.00 9.00 750 24.00 14.40 750 19 75.00 45.00 750 22.00 13.20 750 12 11.00 6.60 750 16 32.00 19.20 750 Vintage 2013 2014 2014 2014 2016 2016 2016 2014 2015 2015 2016 2017 2016 2017 2016 2015 2015 2016 2014 10 Nww- Buyer Phone 101 102 103 Name James Taylor Johnny Rivers Michael Jackson David Bowie 555-1245 555-8794 555-9743 555-2914 104 Winery Name Buyer 101 Babcock Bass Phillip Beringer Brander Cafaro Carhartt Clarendon Gainey Gary Farrell Joel Gott Melville Miguel Torres Mud House Neil Ellis Neyers San Vincenti Uber Voss Woodward Location America Australia America America America America Australia America America America America Chile New Zealand South Africa America Italy America America America 104 101 101 101 101 104 102 102 102 102 104 104 103 103 b. Establish the appropriate relationship between each table. c. Create a query that lists SKU, Type, Winery, Buyer, and Buyer Phone for all products. (Save as Wine Products Query 1.) d. Create 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 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 lay-out with Portrait orientation. (Save the report as Wine Products Report 1.) All field information should be visible. Post your access file here by clicking the link above