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 database : 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...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter AE, Problem AE6.2

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 database:

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.CostSheet1.Mar18) AS Mar, (CloudCosts.CostSheet1.Apr18) AS Apr, (CloudCosts.CostSheet1.May18) AS May, (CloudCosts.CostSheet1.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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

This battle room is focused on entry level tasks for a network analyst where you will be given trials and reconnaissance, sensor tuning, log aggregation, SIEM queries, and network analysis. For this week’s project, complete the following tasks: From your Project Ares portal, LOG IN Click on LAUNCH GAME. Select the region NORTH AMERICA Click on Battle School Under the BATTLE SCHOOL pop-up window, click on START TRAINING. Under the BATTLE ROOMS tile, click on ENTER. Under the NETWORK ANALYST tile, click on PLAY. Wait for the Battle Room to load. While loading, the BATTLE ROOM button will display red. Once the Battle Room is loaded, the BATTLE ROOM button will turn yellow and the center of the disk display will indicate CONNECTED. Click on the BATTLE ROOM button to enter the Battle Room. Below the TASKS folder, make sure you click on INSTRUCTIONS to download the Network Analyst Fundamentals material. In the Battle Room, under the TASKS menu select task INTRUSION DETECTION. Complete…

Create a relationship between the common field (Technician Number) of the two tables. Make sure that each client must have 1 and only 1 technician assigned, and each technician can have multiple clients. 2. Create a query to show the Client Number, Client Name, Billed, Paid for clients in Anderson city. Save the query. 3. Create a query to show the Technician Number, Last Name, First Name, YTD Earnings for technicians whose Hourly Rate is greater than or equal to 30. Save the query. 4. Create a query to show Client Number, Client Name, Billed, Paid for clients whose technician number is 22 and whose Billed is over 300. Save the query. 5. Create a query to show the Technician Number, Last Name, First Name, Client Number, Client Name for clients whose technician number 23. Save the query. 6. Create a query to show the Technician Number, Last Name, First Name, Client Number, Client Name for clients whose technician number 23 or 29. Save the query Help please Microsoft office access

Dijkstra's Algorithm (part 1). Consider the network shown below, and Dijkstra’s link-state algorithm. Here, we are interested in computing the least cost path from node E (note: the start node here is E) to all other nodes using Dijkstra's algorithm. Using the algorithm statement used in the textbook and its visual representation, complete the "Step 0" row in the table below showing the link state algorithm’s execution by matching the table entries (i), (ii), (iii), and (iv) with their values. Write down your final [correct] answer, as you‘ll need it for the next question.

Answer 2

Expert Solution & Answer

Chapter AE, Problem AE6.2

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 database:

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.CostSheet1.Mar18) AS Mar, (CloudCosts.CostSheet1.Apr18) AS Apr, (CloudCosts.CostSheet1.May18) AS May, (CloudCosts.CostSheet1.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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter AE, Problem AE6.2

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 database:

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.CostSheet1.Mar18) AS Mar, (CloudCosts.CostSheet1.Apr18) AS Apr, (CloudCosts.CostSheet1.May18) AS May, (CloudCosts.CostSheet1.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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter AE, Problem AE6.2

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 database:

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.CostSheet1.Mar18) AS Mar, (CloudCosts.CostSheet1.Apr18) AS Apr, (CloudCosts.CostSheet1.May18) AS May, (CloudCosts.CostSheet1.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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter AE, Problem AE6.2

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 database:

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.CostSheet1.Mar18) AS Mar, (CloudCosts.CostSheet1.Apr18) AS Apr, (CloudCosts.CostSheet1.May18) AS May, (CloudCosts.CostSheet1.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

Answer 8

Chapter AE, Problem AE6.2

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 database:

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...

Answer 9

Chapter AE, Problem AE6.2

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 database:

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...

Answer 10

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.Cost*Sheet1.Mar18) AS Mar, (CloudCosts...

Answer 11

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.Cost*Sheet1.Mar18) AS Mar, (CloudCosts...

Answer 12

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...

Answer 13

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...

Answer 14

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...

Answer 15

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...

Answer 16

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...

Answer 17

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...

Answer 18

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.CostSheet1.Mar18) AS Mar, (CloudCosts.CostSheet1.Apr18) AS Apr, (CloudCosts.CostSheet1.May18) AS May, (CloudCosts.CostSheet1.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

Answer 19

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.CostSheet1.Jan18) AS Jan, (CloudCosts.CostSheet1.Feb18) AS Feb, (CloudCosts.CostSheet1.Mar18) AS Mar, (CloudCosts.CostSheet1.Apr18) AS Apr, (CloudCosts.CostSheet1.May18) AS May, (CloudCosts.CostSheet1.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

Answer 20

Expert Solution & Answer

Answer 21

Expert Solution & Answer

Answer 22

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 23

Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2

Solution Summary: The author describes the steps to import the spreadsheet data into the access database.

Concept explainers

Videos

Explanation of Solution

Explanation of Solution

Explanation of Solution

Explanation of Solution

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

Want to see the full answer?

Chapter AE Solutions

Solution Summary: The author describes the steps to import the spreadsheet data into the access database.

Concept explainers

Videos

Explanation of Solution

Explanation of Solution

Explanation of Solution

Explanation of Solution

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

Want to see the full answer?

Chapter AE Solutions