Computer Applications – 1/27/10

1. Create an Excel Spreadsheet with Charts identical to the sheet
2. The Total Revenue Graph uses the Total for each fiscal year (FY)
3. The Fiscal Year 2003 Chart uses the quarter data for FY 03.
4. Under the Page Layout Tab Select – Margins – Narrow Margins
5. The Page Setup should include the following:  Landscape, Gridlines, Column and Row Headings
6. Header:  EXCEL FINAL and Footer:  NAME(PIC) – HOUR – DATE
7. Print Preview and Print the Spreadsheet.
8. Save the Document as  Your Name Excel Final

Part II – PowerPoint    Final        25 Points

1. Read the directions provided.
2. Some of the Clip Art may be found on the I: drive

Part III – Access Final        25 Points

1. Create a new database called Moonlight Motel
2. Create a Table and name it Room Information
3. Use the field names and record information provided to create the table. 
4. The Room Number is the primary key for the Room Information Table
5. Save and Close the Room Information Table
6. Create a Table and name it Customer Information Table
   
7. Use the field names and record information provided to create the table. 
8. The Credit Card # is the primary key for the Customer Information Table
9. Apply the Lookup Wizard for the Room Number Field in the Customer Information Table
10. Save and close the table
11. Create forms for each table and input the information provided.
12. Save & Close the forms when you have completed inputting the information
13. Open each table and copy them onto a word document
14. Header:  ACCESS FINAL
15. Footer:  Name(Pic) – Date – Hour
16. Save as YOUR NAME ACCESS FINAL