Document Type



By the end of this course, the students will have a greater depth of understanding in the areas of word processing, spreadsheets, databases, and presentation software and web design using Microsoft Word, Microsoft SharePoint, Microsoft Excel, Access, and PowerPoint covering the following topics.

Microsoft Excel 2007:

Chapter 4: Creating Loan Information

Chapter 5: Working With Lists, Working With Logical Functions

Chapter 6: Working With Multiple Worksheets And Workbooks, Database Functions, And Filtering, And Integrating Excel with Other Window Programs

Microsoft Access 2007:

Chapter 4: Enhancing a Table's Design, and Creating Advanced Queries, Creating Custom Reports

Chapter 5: Creating Custom Forms

Chapter 6: Creating Macros And Switchboards

Other Advanced Tasks, Such As Cross Tab Queries, Parameter Queries, Expressions Right, Left, Mid, Datepart, IIf In Queries And Reports, Make Table Queries, Delete Queries, Macro Groups, Transfer Spreadsheet Macros And More.

Microsoft PowerPoint 2007:

Chapter 4: Presenting a Slide Show

Chapter 5: Integrating PowerPoint with Other Programs, and Collaborating with Workgroups

Publication Date

Spring 2009


College of Engineering and Computer Science


Computer Science

Course Number

CS 206-01