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 to 20pt in excel

13/11/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

Office 2013: In Practice Word/Excel/Access—Integrated Project 4 Page 4 of 4

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:

Engineering Guru
Quality Assignments
Isabella K.
Quick Mentor
Engineering Mentor
University Coursework Help
Writer Writer Name Offer Chat
Engineering Guru

ONLINE

Engineering Guru

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$17 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$18 Chat With Writer
Isabella K.

ONLINE

Isabella K.

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$50 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$48 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$27 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$28 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

Module 1 - James sheahan school fees office - Family focused functional assessment questionnaire - Hamlet ophelia scene nunnery - Analysis and Evaluation of Frameworks and Theories - Lifted pixar plot diagram - Goodweek tires inc case study - Roland corporation brand positioning - But 2 ene hbr - Gummy bear osmosis research paper - Boeing's global production system - Bussines - Axiom 2 wheel pitching machine the pitch master - Navalwarcollege blackboard - Tony birtley al jazeera - What did mountain men eat - Graphing derivatives practice with answers - Author of the alchemist crossword clue - Vce business management task words - Data mining 7 - Btn bombing of darwin - Basis point value calculation caiib - Discussion 3 - Answer the question in 500 words - Homework market become a tutor - Discussion - CMGT - Opportunity management process flow - Rodan and fields crp - City district government karachi - Mountain dew selecting new creative case analysis - Name something a lifeguard should know how to do - Examples of enablers and disablers - Long series of events crossword clue 4 letters - Accuweather somerville ma - What is the thesis of vampires never die - The lovely bones notes - Solving higher order differential equations - Tafe teacher classification levels - NSG4074 Week three discussion - 9781433813757 - Political Science Week 4 Assignment - Black hills state university bookstore - Reynolds adaptable intelligence test iq - Icd 10 pcs code for gender reassignment - Dulux duramax metallic finish - Risk methodologies - Work breakdown structure cloud migration - Vo2 max lab report example - Water's high specific heat is mainly a consequence of the - Covid 19 - Devil in the white city questions and answers - Broward college career fair - Us health care settings powerpoint presentation - Strategic factor analysis summary sfas - World Civilization before 1650. wk 4 - Literature review - Political lens of the us constitution - Formula for ageing calculation in excel - Move dock bar to other screen - Who's picking up the puffed rice? - What is the factored form of 27a 6 8g 12 - Writing exam for penn foster - How to make green eggs and ham prop - Crypto Week 10 discussion - German poem first they came - Phosphorus 32 protons and neutrons - The art of the commonplace chapter summaries - Ole miss math department - Amazon ont9 redlands ca - Comm 160 final editing assignment - Freepbx call center builder - Keith rn case study answers - The epicurus reader selected writings and testimonia - Cryptography Assignment - Commedia dell'arte characters diagram - Define generally accepted auditing standards - 3.8 kg in stone - Coca cola labor issues - Bir official receipt sample - Como se dice 11th edition - Concept analysis paper on clinical manifestations on adolescent and young adult on the use of synthetic drugs. - Topic 6 Thread 1 and 2 - LITERATURE - A jesuit guide to almost everything pdf - The invisible gorilla chapter 4 summary - Preparing for value based payment five essential skills for success - Frontier leasing corp v links engineering - Nursing’s Role in Decision Making - Ashford university early childhood education courses - Juke box love song analysis - Human resource management lussier 3rd edition pdf - Literature for moral ethical issues encountered by a pmhnp - Fermi problems and solutions - Antifreeze solute and solvent - Advantages and disadvantages of a whiteboard - N491 Discussion Mod 4: - 8t redken shades eq - Accounting for sales returns and allowances - Wincc connect to sql database