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
You will save your files as:
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.
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.
Why Choose Us
Top quality papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional academic writers
We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.
If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & confidential
We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.
Admission help & business writing
You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.
Editing your paper
Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.
Revising your paper
Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers