19 Aug 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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.