Please answer question with Microsoft Access

ISBN:13-978-0-13-697127-6

1. Please write the answers for the questions. You can use the Internet to research and find answers. It can be assumed that we drink coffee the first thing in the morning. There is something romantic about brewing a pot of coffee, holding a freshly bought cup close, sipping it while reading the news, first thing in the morning. This gets better during winterl There is also something practical about it: Sipping piping hot caffeine as soon as possible prepares us for the day - or, at the very least, for the coming few hours. Where does this coffee come from and how it lands in your pot is Supply Chain Management at its very bestl Make sure your answer is detailed as to include transportation, logistics, Internal and external processes, other ingredients that are necessary to make this coffee drinkable and enjoyable by youl Research the Intemet to understand the supply chain networks behind this coffee, and write down the SCM part of coffee. Problem 2: Use Microsoft ACCESS (Please See ACCESS FILES) . Please practice Access before you do this part of the assignment Note: if you do not have Microsoft Access database on your computer you have one of these options: 1. If you have a PC, then Access is available from the Office 365 suite. 2. If you have a Mac, a. You can connect to the University Labs remotely (please talk to IT help) b. You can go to a University Lab and use that computer to do the database assienments 3. If you have a chrome, then you can go to a University Lab and use that computer to do the database assignments. CloudNine, Inc. uses an ERP system and one of its products is Cheese that is sold to retall stores. This exercise is to understand how ERP systems use databases. Ms. Claudine Chez, the CEO of CloudNine, Wants to know the answers to following questions: 1. A list of customers with order dates, shipped dates, payment dates, how they paid, and the amount of payments. 2. Average consumer rating of Cheese Types such as Colby, Cheddar, etc. 3. The supplier's name whose supplier contact begins with the letter "J" 4. The revenues of customers with their orderiDs and ProductiDS, who have been customers since Year 2011. She also wants a report of Cheese Inventory (i.e. Weeksupply) grouped by ChType (like Hard, Semi-hard, etc..). She also wants you to show Proform and the ProductiD in the report. 1. Please write the answers for the questions. You can use the Internet to research and find answers. It can be assumed that we drink coffee the first thing in the morning. There is something romantic about brewing a pot of coffee, holding a freshly bought cup close, sipping it while reading the news, first thing in the morning. This gets better during winterl There is also something practical about it: Sipping piping hot caffeine as soon as possible prepares us for the day - or, at the very least, for the coming few hours. Where does this coffee come from and how it lands in your pot is Supply Chain Management at its very bestl Make sure your answer is detailed as to include transportation, logistics, Internal and external processes, other ingredients that are necessary to make this coffee drinkable and enjoyable by youl Research the Intemet to understand the supply chain networks behind this coffee, and write down the SCM part of coffee. Problem 2: Use Microsoft ACCESS (Please See ACCESS FILES) . Please practice Access before you do this part of the assignment Note: if you do not have Microsoft Access database on your computer you have one of these options: 1. If you have a PC, then Access is available from the Office 365 suite. 2. If you have a Mac, a. You can connect to the University Labs remotely (please talk to IT help) b. You can go to a University Lab and use that computer to do the database assienments 3. If you have a chrome, then you can go to a University Lab and use that computer to do the database assignments. CloudNine, Inc. uses an ERP system and one of its products is Cheese that is sold to retall stores. This exercise is to understand how ERP systems use databases. Ms. Claudine Chez, the CEO of CloudNine, Wants to know the answers to following questions: 1. A list of customers with order dates, shipped dates, payment dates, how they paid, and the amount of payments. 2. Average consumer rating of Cheese Types such as Colby, Cheddar, etc. 3. The supplier's name whose supplier contact begins with the letter "J" 4. The revenues of customers with their orderiDs and ProductiDS, who have been customers since Year 2011. She also wants a report of Cheese Inventory (i.e. Weeksupply) grouped by ChType (like Hard, Semi-hard, etc..). She also wants you to show Proform and the ProductiD in the report