Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Change selected cell to 20pt in excel

05/12/2021 Client: muhammad11 Deadline: 2 Day

Word/Excel/Access 2013: Integrated Project 4
Integrated Project 4
For this project, you create a brochure for Placer Hills Real Estate using information from an Access database and Excel workbook. You create a report and parameter query in Access and use formulas, functions, and formatting in Excel.

[Student learning outcomes Word - 1.1, 1.3, 1.4, 1.5, 1.6, 2.1, 2.7, 4.1, 4.2, 4.3; Excel – 1.1, 1.2, 1.4, 1.5, 1.6, 2.1, 2.2, 2.3, 2.4; Access – 1.1, 1.2, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 4.4, 4.6]

Files Needed PHRE-ListingsBrochure.docx , PHRE-Logo.png , PHRE-Listings.accdb , PHRE-Sales.xlsx, Completed Project File Names: [your initials] Integrated Project 3a.docx , [your initials] Integrated Project 3b.accdb , and [your initials] Integrated Project 3c.xlsx .

Skills Covered in this Project

Change page orientation and margins.

Apply a style to selected text.

Modify and update a style.

Apply a Theme and Style Set.

Insert and position a picture.

Use the Report Wizard to create a report in Access.

Add fields, define a group level, and sort a report.

Use AutoFit Column Width.

Create a query in Design view.

Add criteria and a parameter to a query.

Sort the query.

Type a parameter value on a parameter query.

Copy query results and paste into Word.

Create and copy a formula in Excel.

Insert the AVERAGE function.

Apply formatting and Cell Styles to a worksheet.

Copy data from Excel and paste the data into Word.

Delete a row in a table.

Apply a table style and change table style options.

Change row height and cell alignment.

1. Open the PHRE-ListingsBrochure document from your student data files and save it as [your initials] Integrated Project 4a .

2. Change page layout, apply formatting and styles, and modify styles.

a. Change the page orientation to Landscape.

b. Change the top margin to 0.75” and the bottom margin to 0.5”.

c. Apply the Title style to the first line of text.

d. Apply the Heading 1 style to each of the other headings; don’t apply the style to the blank line below each heading.

e. Apply the Circuit theme and Shaded style set to the document.

f. Select the title, change the font size to 20 pt., change the font color to Black, Text 1, apply bold formatting, center the title.

g. Delete the space between “Rocklin” and “Listings” in the title and insert a line break (Shift+Enter) between these two words.

h. Select the first heading with the Heading 1 style applied, change the font color to Black, Text 1, apply bold formatting, center the text, and apply 12 pt. before and after paragraph spacing.

i. With the text still selected, update the Heading 1 style to match the selection. The other headings should change to the updated Heading 1 style.

3. Insert and position a picture.

a. Move your insertion point to the beginning of the document.

b. Insert the PHRE-Logo picture from your student data files.

c. Change the text wrapping to In Front of Text.

d. Change the Horizontal Absolute position to 8.7” to the right of Page.

e. Change the Vertical Absolute position to 0.2” below Page.

4. Save the document and leave it open.

5. Open the PHRE-Listings Access database from your student data files and save it as [your initials] Integrated Project 4b .

6. Create a report based on a table using the Report Wizard.

a. Use the Report Wizard to create a report using fields from the Listings table.

b. Use the following fields in the report: ListPrice, Address, City, SqFt, Beds, Baths, Garage, and YearBuilt.

c. Add City as a grouping level.

d. Sort first by Beds in descending order and then SqFt in descending order.

e. Select Outline layout, change the orientation to Landscape, and check the box to adjust the field widths so all fields fit on one page (if it is not already selected).

f. Title the report PHRE Listings by City.

g. Finish and preview the report.

h. Close the report.

7. Create a parameter query with multiple criteria.

a. Create a new query in Design view using fields from the Listings table.

b. Use the following fields in the query: ListingID, DateListed, ListPrice, Address, City, SqFt, Beds, Baths, Garage, and YearBuilt.

c. Add criteria to query for homes with a list price of less than $400,000 (don’t use $ or thousands separator) and between 3 and 4 bedrooms.

d. Sort by SqFt in descending order.

e. Add a parameter to the query in the City field that prompts users for a parameter value. Type [Enter the City] as the parameter.

f. Save the query as CityListings.

8. Run the query and copy results to the open Word document.

a. Run the CityListings query and type Roseville when prompted to enter a parameter value. Only those listings in Roseville that are less than $400,000 and have 3 or 4 bedrooms are displayed (Figure 1).

b. Select and copy the results of the query. Don’t include the last mostly blank row.

Figure 1 Integrated Project 4b, CityListing query, Roseville parameter

c. Return to the Word document, place your insertion point on the blank line below the first city heading, and use Ctrl+V to paste the results.

d. Repeat steps 8a-c to query for Rocklin and paste the results in the appropriate area in the Word document.

9. Save and close the Access database.

10. Open the PHRE-Sales Excel workbook from your student data files and save it as [your initials] Integrated Project 4c .

11. Insert a formula and function and copy the formulas to other cells.

a. Select cell K3 and create a formula to calculate price per square feet based on the selling price.

b. Copy this formula to K4:K10.

c. Select cell A11 and type Averages.

d. Insert an AVERAGE function to calculate the average Days On The Market.

e. Copy this function to calculate the averages of SqFt, List Price, Sell Price, and Price per SqFt.

12. Format the worksheet.

a. Format the calculated values in the Averages row consistent with the values above them; make them consistent in number format, decimal places, and alignment.

b. Merge & Center the first row and apply the Heading 1 cell style.

c. Apply the 40% - Accent1 cell style and bold formatting to the column headings in the second row.

d. Apply the Total cell style to the last row.

e. Rename the worksheet tab November Sales (Figure 2).

Figure 2 Integrated Project 4c completed

13. Copy A2:K11 and paste it below the last heading (“November Sales”) in the Word document.

14. Return to the Excel workbook and save and close it.

15. Return to the Word document and customize the tables.

a. Delete the first row containing “CityListings” from each of the first two tables.

b. Select the first table, change the font size to 10 pt., and AutoFit Window.

c. Apply the Grid Table 2 table style, and select Header Row and Banded Rows as the table style options; all other options should be deselected.

d. Repeat steps 15b and c on each of the other two tables.

e. Select the last table, change the row height to 0.14”, and select Total Row in the table style options.

f. In the last table, select the first row, and use the Table Properties dialog box to align text in these cells at the Bottom; don’t change the horizontal alignment of these column headings.

16. Delete the blank line below each of the first two tables.

17. Save and close the Word document (Figure 3).

Figure 3 Integrated Project 4a completed

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Academic Master
Essay Writing Help
Smart Tutor
Top Grade Essay
Accounting & Finance Mentor
WRITING LAND
Writer Writer Name Offer Chat
Academic Master

ONLINE

Academic Master

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$17 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$23 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$43 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$26 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$37 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$21 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Legal ethical & social environment - Caco3 2hcl cacl2 co2 h2o balanced equation - Seat belt laws victoria history - Pb co3 2 name - Powerpoint - Alphabet symmetry worksheet answers - Which of the following is not a special journal - Rprogramming and Probability - Analysis of cherry pink and apple blossom white - Aunty joan's gourmet toffee stockists - My uq timetable planner - Read Deceitful Spammer or Marketing Genius? and complete the questions at the end of the case study. - Week 3 - Assignment: Examine Quasi-Experimental Research Methods - Suppose a life insurance company sells a - Oscillometric method using the finger pulse transducer - Abm voltage source multisim - Compass point health visitors - Need someone to do a speaker reflection - Sir joseph hotung net worth - Smileline inc has an onsite daycare - Dulux block filler paint - Fundamentals of Statistics - Phrase wheel cheats disney movies - When were fiber optic cables invented - What is the meaning of smaw welding - A box contains 6 blue marbles and 4 red marbles - As1684 span tables download free - HS 2200 Social Welfare/Discussion - What does edi mean in insurance - California History - 1 page - Which is a characteristic of pseudoscience - Discussion Question - I will wait country song - Organizational communication 3 - Researching wan technologies - Fagan v metropolitan police commissioner 1969 1 qb 439 - Supplier power tends to be low when - Writing a speech outline template - Discussion - Integrated marketing communication essay - Iphone upgrade program vs trade in - Pent ca gov forms htm - Descended from odin trustpilot - Purchase order number generator - Theater Midsummer Night’s Dream assignment - Motor program theory - Microsoft Power Point Assignments 3 - Australian new zealand standard classification of occupations anzsco - Lyle lanley costume - Pure nitrosyl chloride gas was heated to - Discussion 1 - How to tighten swarovski bracelet - Ballantine bossa nova sequence dance - On the sidewalk bleeding summary - Processes and Threads (Operating system) - Road and maritime services contact - Tvb anniversary awards 2012 - Usa patriot act powerpoint presentation - Which of the following events are equal - Uptown uptempo woman guitar chords - Santander mortgage documents required - Worksheet Chinese - Discussion Forum # 3 What Laws Need to Change in order to Improve the Health of Indigenous People? - Botany Dissertation Due in one week - Maersk compensation philosophy - Motifs in julius caesar - Titration gizmo answer key - The second layer of the criminal justice wedding cake consists of - Managing operations - Business plan template hubspot - Detecting Plagiarism - David chosen as king - The norton introduction to literature 12th edition - The thickness of soap film is nm - Aboriginal creation story of uluru - Sa010 form - After seeing advertisements for the toyota prius joel - L glucose d glucose and fructose are examples of - Cisco prime infrastructure license types - Scs 100 project 1 comparison template - Count backwards from 20 - Geology Project 3 & 4 - H r diagram lab answers - Project plan executive summary template - How much is 1.5 kg in grams - Sadler report on child labor summary - Leadership Perspectives - Harvard business school matching dell case study - Ross london telescope serial numbers - Mariana canta en el coro (choir) de la universidad. - Gail pallin stage management - Partial diploid lac operon - Minitab relative frequency histogram - Camper northeast sandy lane - Is sodium chloride soluble in acetone - Work safe smart move - Tjx data breach case study - The ugly american summary - Boolean algebra simplification examples - What are the three counties in delaware