Exploring Microsoft Office Plus Edition with additional Excel & Access coverage

(NOTE: The Plus Edition extends the coverage of Access and Excel to six and seven chapters, respectively (as opposed to four chapters each in Volume I). It also maintains the same level of coverage for PowerPoint and Word as in Volume I so that both applications are Microsoft Office Specialist certified. The Plus Edition includes a new module on XML.) 

WINDOWS XP
Chapter 1: Getting Started with Microsoft Windows XP 
Welcome to Windows XP
The Desktop  
        Moving and Sizing a Window
Anatomy of a Window  
        Pull-Down Menus 
        Dialog Boxes 
Help and Support Center 
Files and Folders
The Exploring Office Practice Files 
Connecting to the Internet   
Windows Explorer  
       Personal Folders  
       Moving and Copying a File 
       Deleting a File  
       Backup 
Increasing Productivity 
       The Control Panel 
       Shortcuts 
       The Search Companion
Fun with Windows XP 
        Windows Media Player 
        Digital Photography 
        Windows Messenger  

MICROSOFT OFFICE WORD 2003 
Chapter 1:Microsoft Word: What Will Word Processing Do for Me? 
The Basics of Word Processing  
   The Insertion Point 
    Word Wrap
    Toggle Switches 
    Insert versus Overtype 
    Deleting Text
Introduction to Microsoft Word
   The File Menu 
    Learning by Doing 
Troubleshooting
Introduction to Formatting 
The Spell Check
     AutoCorrect and AutoText
Thesaurus
Grammar Check
Save As Command 
    Backup Options  

Chapter 2: Gaining Proficiency: Editing and Formatting 
Undo and Redo Commands

Moving and Copying Text

Find, Replace, and GO TO Commands

Scrolling

View Menu  

Typography 

      Type Size 

      Format Font Command

 Page Setup Command        

      Page Breaks 
An Exercise in Design
Paragraph Formatting 

       Alignment

       Indents

       Tabs

       Hyphenation

       Line Spacing

Format Paragraph Command 

       Borders and Shading

Column Formatting

 

Chapter 3: Enhancing a Document: The Web and Other Resources

Enhancing a Document  

      The Microsoft Clip Organizer 

      The Insert Symbol Command   

      Microsoft Word Art 
The Drawing Toolbar
Microsoft Word and the Internet 

       Copyright Protection 
Wizards and Templates
Mail Merge 

  

Chapter 4: Advanced Features: Outlines, Tables, Styles and Sections 

Requirements of a Term Paper  

     Bullets and Lists

     Creating an Outline 

Tables
Styles
The Outline View

        The AutoFormat Command

Working in Long Documents

        Page Numbers

        Headers and Footers 

        Sections

        Table of Contents

        Creating an Index

        The Go To Command

 

MICROSOFT OFFICE EXCEL 2003 

Chapter 1: Introduction to Excel: What is a Spreadsheet?  
Introduction to Spreadsheets  

      The Accountant’s Ledger 

      The Professor’s Grade Book

      Row and Column Headings 

      Formulas and Constants 

Introduction to Microsoft Excel 

       Toolbars

The File Menu  
Modifying a Worksheet 
The Page Setup Command  

A Better Grade Book
Cell Ranges
Copy Command
Move Operation
Learning by Doing 

Formatting
Format Cells Command

     Alignment

      Fonts

      Borders, Patterns, and Shading    

 

Chapter 2: Getting Proficiency: The Web and Business Applications

Employee Payroll 

      Pointing

      The Fill Handle

      Comments

Excel and the Internet 
Web Queries  

 

Chapter 3: Graphs and Charts: Delivering a Message 

Charts Types   

      Pie Charts  

      Column and Bar Charts       

Creating a Bar Chart

      The Chart Wizard

      Modifying a Chart 

Multiple Data Series  

       Stacked Column Charts  

Object Linking and Embedding   

 

Chapter 4: Using Spreadsheets in Decision Making: What If? 

Spreadsheets in Decision Making  

      Analysis of a Car Loan  

      PMT Function

      FV Function

      Inserting a Function 

      The Goal Seek Command

Home Mortgages

      Relative versus Absolute Addresses

      Mixed Reference

The Grade Book Revisited

       Statistical Functions

       Arithmetic Expressions versus Functions

       IF Functions

       VLOOKUP Function

Working with Large Spreadsheets 

       Freezing Panes 

       Hiding Rows and Columns 

       Printing a Large Worksheet

       AutoFilter Command   

 

Chapter 5: Consolidating Data: Worksheet References and File Linking  

Consolidating Data

The Three-Dimensional Workbook   

      Copying Worksheets   

      Multiple Worksheets        

Worksheet References   

       3-D Reference

       Grouping Worksheets

       The AutoFormat Command   

The Documentation Worksheet    
Linking Workbooks    

       3-D Reference

       Grouping Worksheets

       The AutoFormat Command   

 

Chapter 6: A Financial Forecast: Auditing, Protection, and Templates  

A Financial Forecast   

      Advanced Formatting   

Scenario Manager  
Workgroups and Auditing 

      Data Validation 

Templates       

 

Chapter 7: List and Data Management: Converting Data to Information   

Lists and Data Management 

Implementation in Excel    

      Data Form Command    

      Sort Command

The Text Import Wizard

      Excel and XML         

Data versus Information     

       AutoFilter Command 

       Advanced Filter Command 

       Criteria Range

       Database Functions

       Insert Name Command

Subtotals    
Pivot Tables and Pivot Charts 

 

  

MICROSOFT OFFICE ACCESS 2003 

Chapter 1: Introduction to Access: What Is a Database?  
The College Bookstore

Introduction to Microsoft Access   

      The Database Window 

      Tables 

      Forms, Queries, and Reports  

Filters and Sorting  
Looking Ahead: A Relational Database  

 

Chapter 2: Tables and Forms: Design, Properties, Views, and Wizards 

A Student Database 

      Include the Necessary Data

      Store Data in Its Smallest Parts 

      Avoid Calculated Fields

Creating a Table

      Primary Key

      Views

Properties  
Forms

      Properties

      AutoForms and the Form Wizard

      Modifying a Form  

A More Sophisticated Form   

 

Chapter 3: Information from the Database: Reports and Queries  

Data versus Information    

      Reports   

      Anatomy of a Report

      The Report of a Wizard 

      Apply What You Know

      Bound, Unbound, and Calculated Controls         

Introduction to Queries   

       Query Design View

       Selection Criteria   
Access Functions and Calculated Controls
Grouping Records  
Crosstab Queries
Action Queries   

Chapter 4: Proficiency: Relational Databases, Pivot Charts, and the Switchboard 
The Investment Database    
      Multiple-Table Queries    
      Maintaining the Database
The Import Spreadsheet Wizard
Total Queries  
      Microsoft Graph
Pivot Tables and Pivot Charts
The User Interface  
       The Switchboard Manager  
       Other Access Utilities  

Chapter 5: One-to-Many Relationship: Subforms and Multiple-table Queries 

A Database for Consumer Loans 

      The AutoNumber Field Type    

      Referential Integrity

      Implementation in Access         

Subforms    

       The Form Wizard        

Multiple Table Queries     
Expanding the Database     

       Multiple Subforms 

 

Chapter 6: Many-to-many Relationships: A More Complex System   

The Computer Store    

      The AutoNumber Field Type

       The Relationship Window 

Subforms, Queries, and AutoLookup        
Parameter Queries
Total Queries
Learning by Doing        

Expanding the Database

The Sales Commission Query    

 

 

MICROSOFT OFFICE POWERPOINT 2003 

Chapter 1: Introduction to PowerPoint: Presentations Made Easy 

Introduction to PowerPoint

      The Common User Interface 

      PowerPoint Views

      The File Menu     

Creating a Presentation

       Slide Layouts   

Templates
The Slide Show

       Delivering the Presentation   

Enhancing a Presentation

       The Microsoft Clip Organizer

         Office Art

         Microsoft WordArt  

 

Chapter 2: Gaining Proficiency: Slide Show Tools and Digital Photography  
Slide Show Tools
Reviewing a Presentation      
PowerPoint and the Internet

       Copyright Protection      

Fun with Photographs

      Photographs, File Formats, and File Folders

      Transitions and Animations    

The Auto-Content Wizard   

 

GETTING STARTED WITH XML   

Chapter 1: Using XML with Microsoft Office 2003

Introduction to XML       

Microsoft Word and XML  
Microsoft Excel and XML       
Microsoft Access and XML            

 

 

INTEGRATED CASE STUDIES  

The Totally Fit Wellness Center
Totally Fit Revenue Workbook and Chart

     (Excel)

Report to the President

     (Word and Excel)

Presentation to the President

      (PowerPoint and Excel)

Last-minute Change

       (Word, Excel, and PowerPoint)

Importing Data

      (Access and Excel)

Access Objects: Forms, Queries, and Reports

      (Access)

An Access Switchboard

      (Access)

Mail Merge

      (Word and Access)

Worksheet References

      (Excel)

Presentation to the Board

      (PowerPoint and Excel)

Letter to the Board

      (Word and Excel)

Create a Home Page

      (Word)

Submission Checklist

      (Word)

 

Alternate Airways

Objectives Alternate Revenue Workbook and Chart

      (Excel)

Report to the President

      (Word and Excel)

Presentation to the President

      (PowerPoint and Excel)

Last-minute Change

     (Word, Excel, and PowerPoint)

Importing Data

    (Access and Excel)

A Relational Database

    (Access)

Access Objects: Forms, Queries, and Reports

     (Access)

An Access Switchboard

     (Access)

Mail Merge

     (Word and Access)

Worksheet References

     (Excel)

Presentation to the Board

     (PowerPoint and Excel)

Letter to the Board

     (Word and Excel)

Create a Home Page

     (Word)

Submission Checklist

     (Word)

 

University Housing

Objectives University Housing Workbook and Chart

          (Excel)

Report to the Provost

          (Word and Excel)

Presentation to the Provost

         (PowerPoint and Excel)

Last-minute Change

        (Word, Excel, and PowerPoint)

Importing Data

       (Access and Excel)

A Relational Database

       (Access)

Access Objects: Forms, Queries, and Reports

       (Access)

An Access Switchboard

       (Access)

Mail Merge

       (Word and Access)

Worksheet References

       (Excel)

Presentation to Trustees

      (PowerPoint and Excel)

Letter to Trustees

      (Word and Excel)

Create a Home Page

      (Word)

Submission Checklist

       (Word)