Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

Mr Hach G Wells, your manager, has set up the following tasks for you to complete for this phase of the project:
1.    Create a Spreadsheet and import the four (4) Access 2007/2010/2013 Tables into four (4) Worksheets
2.    Data Validation Check
3.    Create an Index Worksheet
4.    Create a Data Input Worksheet Template for later use
5.    Create a Calculations Worksheet Template for later use
6.    Create Name Ranges for the Customers, Items, and Suppliers data
7.    Create a Report Worksheet and set up the column headings
8.    Modify the Report Worksheet by Cell Referencing all the Orders Table data
9.    Modify the Report Worksheet by using VLOOKUP to get Customer, Item and Supplier data
10.    Modify the Data Input Worksheet to include extra data needed for tasks 11 to 15
11.    Modify the Report Worksheet by using a Nested IF to calculate Cost Price (AU)
12.    Modify the Report Worksheet by using a Nested IF to calculate Selling Price
13.    Modify the Report Worksheet by using a Nested IF to calculate Freight Cost
14.    Modify the Report Worksheet by using a AND / IF to calculate Item Discount
15.    Modify the Report Worksheet by using simple formulas to find Purchases and Sales, and Modify the Report Worksheet by using a formula to calculate the Order Discount
16.    Modify the Data Input Worksheet to include extra data needed for tasks 18 to 22
17.    Modify the Calculations Worksheet by using simple formulas
18.    Modify the Data Input Worksheet by Cell Referencing all the Calculations data
19.    Create eight (8) Scenarios on the Data Input Worksheet
20.    Create a Scenario Summary of the eight (8) Scenarios
21.    Create an Documentation Worksheet
22.    Create an Analytical Essay to describe the findings made using the Spreadsheet
Check the imported data in the CustomersTable, ItemsTable, SuppliersTable and OrdersTable to ensure that:
The column headings are displayed correctly
The content of each column displays in a format that appears valid for that type of data (apply appropriate formatting if required).The content of each column contains complete and accurate data values (eg. Phone numbers are not truncated).The content of each column contains reasonable data values for the use of this business.
Add a worksheet labelled Index before the four tables from Task 1. Put a heading at the top of the worksheet in cell A1 called Index Worksheet. Ensure that it contains all the recommended data for this worksheet listed in Appendix 7 of the Study Materials – Spreadsheet design considerations.
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders



testimonials icon
1. Find the absolute extrema of the function () = 3 4 4 3 on the interval [1,2]To find extreme points, we find and set () to 0: () = 12 3 12 2 = 12 2...
testimonials icon
Read through the list of research topics (located in the Appendix), or by clicking the link ...
testimonials icon
Here are the instructions for the writing sample: Imagine we are working with JiffyLube on a project to redesign the frontend of https://www.jiffyl...
testimonials icon
1.Governmental accountability is an important aspect for public administrators to be effective.Explain what steps can be ta...
testimonials icon
1.     Explain why you think eCommerce is successful and why it's taken off in terms of number of users who pr...
testimonials icon
Prove that (tanθ - 1/cosθ)^2 = sinθ-1/sinθ+1...
testimonials icon
Bape User Research Reporthttps://bape.com/index/You will conduct user research in...
testimonials icon
Archer Daniels Midland Company is considering buying a new farm that it plans to operate for 10 years. The farm will require an...
testimonials icon
ibed how environment can affect and promote health. This was basically the first nursing research article ever published. It...
testimonials icon
Choose one topic and complete at minimum 1200 word paper that includes appropriate citations and format.Instruction...
testimonials icon
CJS 200 Week 8 Assignment Parole and Truth in Sentencing Paper...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65