Word/Excel/Access 2013:Integrated Project4:

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]

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-ListingsBrochuredocument 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.