Capstone Project

In the capstone project you will incorporate Word, Excel, Access, and PowerPoint.

The Guidelines listed below describe the features that must be included in your final Capstone Project submission:

I uploaded my topic in the file box.

For the Word document:

Utilize a Word document theme other than the default Office theme
Change the font and font size to something other than the default at least once within your document
Incorporate graphics (at least one) in addition to the text in the form of pictures, clip art, shapes, etc
Center and format the document title
Adjust margins and line spacing to something other than the default settings
Include a bulleted list
Include a table with a header and a table style applied to it
Include at least two lines of text – (different from the one with bullets) – that incorporate two or more custom tab stops (other than left tabs).

For the Powerpoint presentation:

Include at least five slides
Apply a theme other than the default Office theme and change it’s default colors by selecting a variant of the theme that you selected
Insert a Word Art Style
Apply a texture like Newsprint to at least one slide.
Add at least one picture or Clip Art
Add a bulleted list with multiple levels of indentation
Insert a SmartArt graphic
Incorporate both animations and transitions in your presentation.
Incorporate at least one speaker note and in that note identify the theme and the slide numbers on which your WordArt, SmartArt, and texture appear. An example of a speaker note: ” Wisp theme applied. WordArt – slide 1, SmartArt – slide 3, texture – slide 4″

For the Access database file:

Include two tables – a primary table with a related secondary table that permits a one-to-many relationship. You can construct each table in Access or you may import from Excel if your spreadsheet design includes two related tables
Identify the primary key for each table
Design at least one form
Design at least one report
Design and save queries of the following types:

a) AND query
b) OR query
c) Parameter query
d) Query using a wildcard
e) Query which displays an aggregate function such as AVERAGE
f) an ACTION query such as UPDATE or DELETE query

Create a Lookup Field in one of your tables
Include a validation rule with validation text for one of your fields
Establish a one-to-many relationship with referential integrity

For the Excel spreadsheet:

Include more than one worksheet.
Use both relative and absolute cell references somewhere in your formulas where the cell reference type is appropriate
Utilize at least three functions selected from NOW, SUM, MAX, MIN, AVERAGE, COUNT, COUNTIF
Utilize an IF function
Utilize a custom theme (something that is different from the default Office theme)
Utilize conditional formatting
Cells must have enough width to display all information
Cells ranges must be formatted appropriately for the contents
Construct a chart and locate the chart on a separate chart sheet

Once you have created your Word, Excel, Access, and PowerPoint files, compress them together into a single compressed (zipped) folder that will be uploaded and submitted to this assignment link.