
Concept explainers
Explanation of Solution
a.
Steps to import the spreadsheet data into the access:
Double click on the file “Ch06Ex02 _U10e.xlsx” that is downloaded and it will appear as shown below:
Screenshot of After opening the file
The above file will contain single sheet.
Open the existing access
Double click on the file “Ch06Ex02 _U10e.accdb” that is downloaded and it will appear as shown below:
Screenshot of Ch06Ex02 _U10e access database
- Open the table “CloudCosts” contains cost for each cloud processing resources.
To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.
- A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.
Screenshot of Getting external data dialog box
- Now Import Spreadsheet wizard get opened...
Explanation of Solution
b.
Steps to compute the cost of each resource:
- Click the “CREATE” tab and select a “Query Design” option.
- Close the “Show Table” dialogue box.
- Click “SQL view” option. The query page will be open and enter the following SQL query:
SELECT CloudCosts.Resource_Name, (CloudCosts.Cost*Sheet1.Jan18) AS Jan, (CloudCosts.Cost*Sheet1.Feb18) AS Feb, (CloudCosts.Cost*Sheet1.Mar18) AS Mar, (CloudCosts...
Explanation of Solution
c.
Steps to be followed to perform report creation:
- Once the query result will appear on the screen as above figure, navigate to “CREATE” tab and click a “Report” button.
- Now right click the Report and select “Design View” option, the design view wizard for the corresponding report will be opened as follows:
Screenshot of Design view for Report
- Now, enter the report name on Report Header by entering the text...
Explanation of Solution
d.
Steps to export the query into Excel and create pie chart report for corresponding query data:
- Double click the report which user want to import and click on the “External Data” tab and click on “Excel” icon on Export Tool.
- The following “Excel-Spreadsheet” window will be opened.
Screenshot of Excel Spreadsheet wizard
- Click the “Browse” button and select the place to save the report.
- Click the drop-down button on “File format” label and select the excel version...
Explanation of Solution
e.
Steps to create pie chart for total cost by month:
- Now open the excel report on the corresponding folder.
- Navigate to “Insert” tab and select “Pie” type chart from Charts Tool.
- Right click the chart and select “Select Data” option.
- Select the month name and its total row range...
Explanation of Solution
f.
Repeat the sub parts b, c, d, e with new cost:
After increasing the cloud cost by 10%, the result will be as follows:
Screenshot of CloudCosts Table
Steps to compute the cost of each resource:
- Click the “CREATE” tab and select a “Query Design” option.
- Close the “Show Table” dialogue box.
- Click “SQL view” option. The query page will be open and enter the following SQL query:
SELECT CloudCosts.Resource_Name, (CloudCosts.Cost*Sheet1.Jan18) AS Jan, (CloudCosts.Cost*Sheet1.Feb18) AS Feb, (CloudCosts.Cost*Sheet1.Mar18) AS Mar, (CloudCosts.Cost*Sheet1.Apr18) AS Apr, (CloudCosts.Cost*Sheet1.May18) AS May, (CloudCosts.Cost*Sheet1.Jun18) AS Jun, (Jan+Feb+Mar+Apr+May+Jun) AS Total
FROM CloudCosts INNER JOIN Sheet1 ON CloudCosts.Resource_Name = Sheet1.Field1;
Click the “RUN” button. The following result will be appeared as follows:
Screenshot of Query result
Steps to be followed to perform report creation:
- Once the query result will appear on the screen as above figure, navigate to “CREATE” tab and click a “Report” button.
- Now right click the Report and select “Design View” option, the design view wizard for the corresponding report will be opened as follows:
Screenshot of Design view for Report
- Now, enter the report name on Report Header by entering the text.
- In order to calculate the total cost resources for each month by select the column name in Detail section and navigate to “Design” tab. Select the “Total” list button and click “Sum”.
- Repeat the above step for all months.
- Finally click the “View” button.
Screenshot of Report for cloud resource cost

Want to see the full answer?
Check out a sample textbook solution
Chapter AE Solutions
EBK USING MIS
- show all the workarrow_forwardList down the strenghts and weaknesses of your team project for Capsim Simulation? Explan.arrow_forwardCapsim Team PowerPoint Presentations - Slide Title: Key LearningsWhat were the key learnings that you discovered as a team through your Capsim simulation?arrow_forward
- Write the SQL code that permits to implement the tables: Student and Transcript. NB: Add the constraints on the attributes – keys and other.arrow_forwardDraw an ERD that will involve the entity types: Professor, Student, Department and Course. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.arrow_forwardDraw an ERD that represents a book in a library system. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.arrow_forward
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning



