Business Database Worksheet

Description

The scenario:

Johnston Smith, Associate Director of Sales as Pasedena HVAC Manufacturer, has asked you to calculate the cost of running HVAC units in summer and provide a report.

For this assignment, you will need the following files:

New blank Access database

HVAC_Cooling

You will save your files as:

Lastname_Firstname_HVAC_Cooling

Lastname_Firstname_Cooling_Costs

Open the HVAC_Cooling Excel file, and save the file as Lastname_Firstname_HVAC_Cooling.
Insert the your name in the footer.
In the worksheet, insert an Excel table with a header row.
Add a calculated column that calculates the cost of cooling using $0.00124 per Cooling BTU formatted with the Accounting Number Format.
Filter the data to display only one Heating BTU number of your choice.
Apply Best Fit to all columns.
Center the worksheet horizontally on a landscape page.
In Access, create a new database and save it as Lastname_Firstname_Cooling_Costs
Import your Lastname_Firstname_HVAC_Cooling Excel file.
In the table, filter the data to show only data for the Cooling BTU greater than 60,000 and the Power unit of your choice.
Create a report based on your results.
Delete the four measurement fields following the Heating BTU field, and be sure the title fits on one line.

Special Instructions: Use the Supporting Materials below to complete the project.

1 attachments

Slide 1 of 1

attachment_1

attachment_1

Unformatted Attachment Preview

Model
Power
Cooling BTU
CLD036B LE
CLD048B LE
CLD060B LE
CLD070B LE
CLD036C LE
CLD048C LE
CLD060C LE
CLD070B LE
CLD036D LE
CLD048D LE
CLD060D LE
CLD070B LE
CLD036B ME
CLD048B ME
CLD060B ME
CLD070B ME
CLD036C ME
CLD048C ME
CLD060C ME
CLD070B ME
CLD036D ME
CLD048D ME
CLD060D ME
CLD070B ME
CLD036B HE
CLD048B HE
CLD060B HE
CLD070B HE
CLD036C HE
CLD048C HE
CLD060C HE
CLD070B HE
CLD036D HE
CLD048D HE
CLD060D HE
CLD070B HE
230/60/3
230/60/3
230/60/3
230/60/4
460/60/3
460/60/3
460/60/3
460/60/4
575/60/3
575/60/3
575/60/3
575/60/4
230/60/3
230/60/3
230/60/3
230/60/4
460/60/3
460/60/3
460/60/3
460/60/4
575/60/3
575/60/3
575/60/3
575/60/4
230/60/3
230/60/3
230/60/3
230/60/4
460/60/3
460/60/3
460/60/3
460/60/4
575/60/3
CLD
575/60/3
575/60/4
39,500
50,500
73,200
71,000
37,500
49,500
63,200
71,000
37,500
37,500
49,500
63,200
74,000
37,500
49,500
63,200
75,000
37,500
49,500
74,000
37,500
49,500
63,200
75,000
37,500
49,500
63,200
76,000
37,500
49,500
63,200
77,000
37,500
49,500
83,200
98,000
Heating
Height
BTU
48,500
32
48,500
32
48,500
36
48,500
38
50,000
32
50,000
32
50,000
36
50,000
38
50,000
36
64,000
32
64,000
32
64,000
36
64,000
38
64,000
36
64,000
36
75,000
36
75,000
38
75,000
32
75,000
32
75,000
38
75,000
36
75,000
36
75,000
36
75,000
38
75,000
32
75,000
32
96,000
36
96,000
38
96,000
32
96,000
32
104,000
36
104,000
38
96,000
36
96,000
36
104,000
36
104,000
38
Width
Length
Weight
40
45
50
55
40
45
50
55
40
40
45
50
55
40
45
50
55
40
45
55
40
45
50
55
40
45
50
55
40
45
50
55
40
45
50
55
54
56
58
70
60
62
64
70
66
60
62
64
70
66
68
70
70
58
60
70
66
68
70
70
58
60
62
70
64
66
68
70
70
72
74
74
350
360
375
385
400
420
450
460
470
425
465
475
485
495
525
550
600
415
435
485
495
525
550
600
415
435
450
460
470
500
515
525
600
650
675
700

Purchase answer to see full
attachment

Explanation & Answer:

Worksheet

User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.