Data Files needed for this Case em: Food.xlsx, Foodborne lllness.accdb

Case problem #2 on page 723

Data Files needed for this Case em: Food.xlsx, Foodborne lllness.accdb Food Safety Monitors Leah pson is a researcher at Food Safety Monitors, a nonprofit advocacy group to help prevent the of foodborne illness from tainted foods and inadequate preparation. She has asked your he n developing an Excel workbook that tracks incidents of food poisoning from the past . Leah wants to explore the relationship between the type of foodborne illness, the food ed, and the meal location. She also wants to compare the rate of foodborne illnesses —-APmn>Pn states during the 17-year period. Complete the following:

1. Open the Food workbook located in the Excel11 > Case2 folder included with your Data Files, and then save the workbook as Food Safety Monitors in the location specified by your instructor.

2. In the Documentation worksheet, enter your name and the date.

3. In the Annual Incidents worksheet, create the following query to extract the annual incidents of foodborne illnesses: a. Connect to the Foodborne Illness Access database file located in the Excel11 > Case2 folder, and then select the Illness table. b. Remove all of the columns from the query except the Date and Illnesses columns. c. Add a column named Year containing the year value for each record. (Hint: In the Add Column tab, click the Date button, and then select Year as the value to create.)

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"