1. Please write the answers for the questions, You can use the Internet to research and find answert. It can be assumed that we drink colfee the first thing in the momitg. Thete is something romantic about brewing a pot of cotfee, holdine a freshly bought cup dose, sipping if whle teading the news, first thine in the moening. This gets beeter during winterl There is also something practical asout if: Sipping piping hot catleine as soon as possible prepares us for the day - or, at the very least, for the coming frw hours. Where does this coffee come frem and how it lands is your pet is Supply Chain Management at its very best! Make sure your answer is detaled as to incluse tramportation, logistics, Intemal and external processes, other ingredients that are necessary to make this colfee drieable and enjoyable by youl Research the intemet to understand the supply chain netwoels behind thic coffee, and write down the SCM part of colfee. Problem 2: Use Microsett AcCess (Please See ACcess FILE5) . Please practice Access before you do this part of the askignement Note: if you do not have Microsoft Access database cet your computer you have one of these optiond- 1. If you have a PC, then Access is a wallable from the Offce 365 sulte. 2. If you harve a Mac, a. You can connect to the University Labs remotely (please talk to If help) b. You can go to a University Lab and use that computer to do the databale asugnnents 3. If vou hare a chrome, then you ean go to a Univernfy tab and use that cemputer to do the dacabase assignments. CloudNine, loc. wses an ERP system and one of its products is Cheese that is sold to retait stores. This exercise is to understand how IHP pystems wie databases. Ms. Clyudine Chez, the CCO of Cloud Nine, wants to know the arrwen to following questionk: 1. A list of custemers with oeder dates, shipped dates, payment dases, how they paid, and the amount of payments. 2. Averaze consumer rating of Cheese Types usch as Colby, Cheddar, etc: 3. The supolier's name whose supplier contact bezim with the letter IJ 4. The revenueri of cussomers with their orderios and ProductiDs, who have been customers since Year 2011. Shit aho wants a report of Cheese imveritory (L.e. Weeksuppty) Erouped ty ChType (fike Hard, Sene hard, ete). She atso wants you to show Proform and the Preducto in the report. 1. Please weite the anserers for the tuentions. 7oe can use the intermet to research and find asswers. It can be ansumed that we driek celfie the frit thine in the mornine. There is something romantic about brewine a pot of cotlee, hoidine a fredily bought oup dose, seping it while resding the newh, firat thing hot calleine art soon an ponsible prepures un for the any - br, at the wery least, for the coming few houss. Where does this coflee come traen ard teee it lands in vour poe is Supply Chain Management at its verr betat Make sure your answer is detalked as to include transectation, logntict, Internal and entemal processes, other ineredients that are nectary ta maie this colee drinizble and enioyable by youl scM part of colfice. Proble 2: Uhe Micraselt Mcciss (Please See Mcmss Ftisi). Please practice Accest before you do this part of the assigntent Nate: if you do not have Microseft Acoest dacubues bot your cemputer you have ine af theie optiont: 1. If you have a RC, then Acress a maisible trem the Office 365 yite. 2. Wyou have a Mac. a. Yoe can contect to the thivenity Lats remotely (Diease tala bo it hebl t. Yos can go to a University Lub ant ase that campolse to de the database atsienments 3. If you have a chromt, then vou can go ha a lievenity Lab and use that computer to do the databout assegeneity. weits to know the anseresto following quetions. amevor ef peywerets. 2. Averaes contwmer fative of Cheese Tywes wect an Colby, Cheddar, efc: 3. The topplier's name whese 1 pelte bertact beims a th toe letser "f vear abti. ete. 1. She alia wanti you to show Prefare ane the thoducte in the ieport. INFS 40111 HW 4 1. Please write the answers for the questions. You can use the Intemet to research and find answers. it can be assumed that we drink colfee 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 wintert 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 heurs. Where does this coffee come from and how it lands in your pot is Supply Chain Management at its very best! Make sure your answer is detailed as to include transportation, logistics, Internal and external processes, other ingredients that are necessary to make this colfee drinkable and enjoyable by youl Research the internet 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 FItES) . Please practice Access belore you do this part of the assignment Note: If you do not have Microsaft 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 heip) b. You can go to a University Lab and use that computer to do the database assignments 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 retail 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, efc. 3. The supplier's name whose supplier contact begins with the letter "F" 4. The revenues of customers with their orderibs and Productios, who have been customers since Year 2011. She alio wants a report of Cheese inventory (li.e. Weeksupply) grouped by Chivpe (like Hard, Semithard, etc..). She also wants you to show Proform and the Productib 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 best! 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 Internet 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 avallable 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 assignments 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 retail 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 best! 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 Internet 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 avallable 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 assignments 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 retail 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 answert. It can be assumed that we drink colfee the first thing in the momitg. Thete is something romantic about brewing a pot of cotfee, holdine a freshly bought cup dose, sipping if whle teading the news, first thine in the moening. This gets beeter during winterl There is also something practical asout if: Sipping piping hot catleine as soon as possible prepares us for the day - or, at the very least, for the coming frw hours. Where does this coffee come frem and how it lands is your pet is Supply Chain Management at its very best! Make sure your answer is detaled as to incluse tramportation, logistics, Intemal and external processes, other ingredients that are necessary to make this colfee drieable and enjoyable by youl Research the intemet to understand the supply chain netwoels behind thic coffee, and write down the SCM part of colfee. Problem 2: Use Microsett AcCess (Please See ACcess FILE5) . Please practice Access before you do this part of the askignement Note: if you do not have Microsoft Access database cet your computer you have one of these optiond- 1. If you have a PC, then Access is a wallable from the Offce 365 sulte. 2. If you harve a Mac, a. You can connect to the University Labs remotely (please talk to If help) b. You can go to a University Lab and use that computer to do the databale asugnnents 3. If vou hare a chrome, then you ean go to a Univernfy tab and use that cemputer to do the dacabase assignments. CloudNine, loc. wses an ERP system and one of its products is Cheese that is sold to retait stores. This exercise is to understand how IHP pystems wie databases. Ms. Clyudine Chez, the CCO of Cloud Nine, wants to know the arrwen to following questionk: 1. A list of custemers with oeder dates, shipped dates, payment dases, how they paid, and the amount of payments. 2. Averaze consumer rating of Cheese Types usch as Colby, Cheddar, etc: 3. The supolier's name whose supplier contact bezim with the letter IJ 4. The revenueri of cussomers with their orderios and ProductiDs, who have been customers since Year 2011. Shit aho wants a report of Cheese imveritory (L.e. Weeksuppty) Erouped ty ChType (fike Hard, Sene hard, ete). She atso wants you to show Proform and the Preducto in the report. 1. Please weite the anserers for the tuentions. 7oe can use the intermet to research and find asswers. It can be ansumed that we driek celfie the frit thine in the mornine. There is something romantic about brewine a pot of cotlee, hoidine a fredily bought oup dose, seping it while resding the newh, firat thing hot calleine art soon an ponsible prepures un for the any - br, at the wery least, for the coming few houss. Where does this coflee come traen ard teee it lands in vour poe is Supply Chain Management at its verr betat Make sure your answer is detalked as to include transectation, logntict, Internal and entemal processes, other ineredients that are nectary ta maie this colee drinizble and enioyable by youl scM part of colfice. Proble 2: Uhe Micraselt Mcciss (Please See Mcmss Ftisi). Please practice Accest before you do this part of the assigntent Nate: if you do not have Microseft Acoest dacubues bot your cemputer you have ine af theie optiont: 1. If you have a RC, then Acress a maisible trem the Office 365 yite. 2. Wyou have a Mac. a. Yoe can contect to the thivenity Lats remotely (Diease tala bo it hebl t. Yos can go to a University Lub ant ase that campolse to de the database atsienments 3. If you have a chromt, then vou can go ha a lievenity Lab and use that computer to do the databout assegeneity. weits to know the anseresto following quetions. amevor ef peywerets. 2. Averaes contwmer fative of Cheese Tywes wect an Colby, Cheddar, efc: 3. The topplier's name whese 1 pelte bertact beims a th toe letser "f vear abti. ete. 1. She alia wanti you to show Prefare ane the thoducte in the ieport. INFS 40111 HW 4 1. Please write the answers for the questions. You can use the Intemet to research and find answers. it can be assumed that we drink colfee 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 wintert 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 heurs. Where does this coffee come from and how it lands in your pot is Supply Chain Management at its very best! Make sure your answer is detailed as to include transportation, logistics, Internal and external processes, other ingredients that are necessary to make this colfee drinkable and enjoyable by youl Research the internet 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 FItES) . Please practice Access belore you do this part of the assignment Note: If you do not have Microsaft 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 heip) b. You can go to a University Lab and use that computer to do the database assignments 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 retail 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, efc. 3. The supplier's name whose supplier contact begins with the letter "F" 4. The revenues of customers with their orderibs and Productios, who have been customers since Year 2011. She alio wants a report of Cheese inventory (li.e. Weeksupply) grouped by Chivpe (like Hard, Semithard, etc..). She also wants you to show Proform and the Productib 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 best! 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 Internet 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 avallable 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 assignments 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 retail 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 best! 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 Internet 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 avallable 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 assignments 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 retail 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