Assume you have been asked to create an Office application to estimate cloud computing costs. You decide to create a spreadsheet into which your customers can provide their cloud computing needs and which you can then import into an Access database, using queries to compute cloud computing costs.

Figure AE-4 shows the structure of the spreadsheet into which your customers will input their requirements.

You can download this spreadsheet in the Excel file Ch06Ex02_E7e. Figure AE-5 shows an Access table that has costs corresponding to the requirements in Figure AE-4. You can download this database in the Access file Ch06Ex02_E7e.

a. Import the spreadsheet data into the Access database.

b. Write queries to compute the cost of each resource.

c. Create a 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.

d. Create a pie chart that breaks out the total costs by resource. Hint: You have to import the query data back into Excel.

e. Create a pie chart that breaks out the total costs by month. Hint: You have to import the query data back into Excel.

f. Assume that processing costs increase by 10 percent across the board. Repeat parts

c, d, and e for the changed costs.