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 the selected cell to 20pt

09/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

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 Help
Top Class Results
Essay & Assignment Help
Isabella K.
Top Grade Tutor
Quality Homework Helper
Writer Writer Name Offer Chat
Engineering Help

ONLINE

Engineering Help

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$39 Chat With Writer
Top Class Results

ONLINE

Top Class Results

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

$40 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

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

$33 Chat With Writer
Isabella K.

ONLINE

Isabella K.

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.

$40 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade 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.

$21 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

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

Assurance function of public health - What are the five types of governmental funds - Strategic management texts and cases - What does the name christian mean - Round 216 to the nearest ten - Wilkins a zurn company material requirements planning - Analyzing written text - Hicaps add provider form - Prestwich company has budgeted production - Chalmers street clinic edinburgh - Order 2271965: Santa Cruz Bicycles - Question (5) - Lab 2 separation of a mixture answer key - Colin davis machine company maintains a general ledger account - Need this DQ in 24 hours or less - Double declining balance depreciation table - Quiz and Written test - The last dance encountering death and dying pdf - Katherine a strause american trees in summer - Sas 9.4 export to excel - Business Intelligence(Assign1) - Those winter sundays pdf - Jessica and lorenzo plot - English bridge union chicago score sheet - Australian performance and development framework - 19766 westchester clinton township mi 48036 - 5 mcg to ml - HN521 Discussion 10 - Business communication writing improvement exercises - Each of the following items is accurately defined under fica as taxable wages except: - What is a mco in healthcare - 1.5 mm brass tube - A job order cost system - Format string vulnerabilities in cryptography and network security - Acca colleges in ahmedabad - Cloud Conference Presentation (14 PPT slides) - Genetic engineering ppt template - Centaurplus c27 wiring y plan - When does an embryo become a fetus penn foster - 4 point moving average - Flinders harvard reference guide - Braverman company has two manufacturing - Johnson and johnson ratio analysis - Belle vale medical centre - Who warned, “advertisements contain the only truth to be relied on in a newspaper?” - Week 6 Discussion post - Answer discussion question in 175 words or less - Frs 8 related party disclosures - Byrne and clore reward need satisfaction theory - 4/2 - Rowe vets bradley stoke eye clinic - Shooting stars carol ann duffy - Cloud computing within an enterprise risk management framework - Leadership Analysis - Family business 6 - Ephesians 5 33 nkjv - Alan j dabbiere net worth - Fallin jessica mauboy guitar chords - Hello! Can you tell me a website to download videos from tiktoks? - Which of the following elements of the marketing communication mix - Case Study - What distinguishes free range chickens - Salvation army outlook login australia - What is a voluntary statement to police - Evidence-based professional nursing practice - Black death source analysis - Disusion - Data-driven decision making - Boq stamp duty calculator - Konstantin vasily petrides trait model - Using Online Class Services to Upskill: Finding the Right Courses for Professional Development - Group therapy a live demonstration - Oral history interview essay example - Weight watchers outraged at jennifer - Explain how using edi facilitates electronic transactions in healthcare - In plato's republic what service does glaukon do for socrates - Glos royal hospital map - Discussion - Comedy express bandu ani guruji - Exercise 23 questions to be graded - Remaining labor units in p6 - JOURNAL ARTICLE REVIEW - Multiparty Negotiation - Cissp 7th edition shon harris pdf - What is chocolate rain - MM GD1 - Gc 2 worksheet 6 patterson answers - Newcastle airport training academy - Equations of motion worksheet with answers - Occupational therapy acu course outline - IISP DISCUSSION-5-dummy - Need 4 examples no references needed - Star wars episode 1 full movie free youtube - Problem Solution Essay - Assignment cover sheet unisa - Wkuid - I got flowers today domestic violence poem - International council of chemical associations - NEED 3+ PAGES WITH 4 Peer reviewed REFERENCES CITED IN APA FORMAT - What does the cathedral symbolize in cathedral by raymond carver - Fau human resource management