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

Benzene from sodium benzoate - How to calculate theoretical yield recrystallization - What is the expense recognition principle in accounting - Dr priyal de silva nanayakkara - Nurs 6512 head to toe assessment - Interest accrued on 6 month note payable - Company sales invoices census data and trade - Indices examples and solutions - Why did the hen run away - Year 12 physics formula sheet - Baskerville old face adobe - St anne's church dunmurry - Racp written exam pass mark - CIS 336 Enterprise Architecture - What is needed to determine a facility's cmi - When remains are found, fleshed or skeletonized, the discoverer should: - Class president speech examples - Walmart Manages Ethics and Compliance Challenges - The cost of capital ppt - Kinns chapter 16 patient accounts collections and practice management - Sikhism cosmogony origin of the universe - Book a council clean up liverpool - Hormone harmony happy mammoth - I'm a brick and i'm drowning slowly - Welcome to year 5 - Cryptography and Network Security - Characteristics of accounting information pdf - Sewing machine safety poster - Lady macbeth sleepwalking scene video - Example of a text response essay - Math 144 major assignment 2 - Dolphins are not fish - Malaysia cyber security strategy - Building shared services at rr communications case study - Medical nutrition therapy case study answers - Philip carmody melbourne grammar - Cost volume profit analysis youtube - Life in a jar - The lazy mower is it really worth it - MCU and assembly language - Respond to 2 Colleague 1 paragraph each - 380 bus route auckland - Modelo you hear: anoche dormiste (you slept) sólo una hora. you choose: tienes sueño. - Conformity and rebellion essay - Gallery attendant job description - Short anecdotes of gandhi - St george christian college - Performance compensation and rewards presentation - Traffic jam team building activity - Toll second step program - Module 4 Graded Assignment-- Cyb Law - Legal,Ethical,&social environment - Preliminary stage cost drivers definition - When forming the disaccharide maltose from two glucose monosaccharides: - The crucible and the dressmaker sample essay - International financial management madura 13th edition pdf - Final Project paper - Southwestern university traffic problems case study solution - Unit 5 db - DISCUSSION - Psychosocial Development DUE IN 72 HOURS - Bus 308 week 1 problem set - Kellen winslow jr mother katrina ramsey - 136 banjarra drive charleville - PA 2 Paper - Business Research Methodology - English - Robert peck commonwealth joe - Mozambique cell phone codes - Vision mission and strategy of coca cola - Biol1020 textbook - Purdue university medical coding - Plinth sealing strip wickes - Hi q antenna base station - Civil service learning uk - Discussion Board Unit 5 DSDD - NEED IN 15 HOURS or LESS - 5 - Presentation on a How to Manage HIT (Health Information Technology) Changes - Name the muscle that subdivides the ventral body cavity - Earthquake vocabulary crossword puzzle - Research paper - Research Paper - Using revenue management to set orlando magic ticket prices - Robin hood case study recommendations - NS-10 -P - Gsm frame structure ppt - Bank of baroda power of attorney format - Empire abrasive equipment manuals - Bad college essay topics - Mybcommlab answers - Magnesium noble gas configuration - Round orange pill 10 dan 5554 - Psychology - Itpm best practices - Fay abdella - Chapter 13 case scanner project - Merton council building control - Tata group contribute annually for social welfare activity - Canberra theatre seating plan - Who are the demanders and suppliers in health policies - Lae x5 thermostat manual