MIS homework
MIS 3003 Chapter 6 Homework
Assume you have been asked to create an Office application to estimate cloud computing costs. You decide to create a spreadsheet into which your customer can provide their cloud computing needs and which you can then import into an Access database and use queries to compute cloud computing costs.
Figure AE-6 shows the structure of the spreadsheet into which your customers will input their requirements. You can download this spreadsheet in the Excel file Ch06Ex02_U7e.xlsx. Figure AE-7 shows an Access table that has costs corresponding to the requirements in Figure AE-6. You can download this database in the Access file Ch06Ex02_U7e.accdb.
a. Import the spreadsheet data into the Access database. (1pt.)
b. Write queries to compute the cost of each resource. (4 pts.)
c. Create report that shows the cost for each type of resource for each month. Show the total costs for the 6-month period for each resource as well. Include a grand total of all the costs (2 pts.)
d. Assume that processing costs increase by 10 percent across the board. Repeat parts b and c for the changed cost. (3 pts.)
Figure AE-7