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
College of Engineering and Computer Science