Access XP: Beginner Level

• 1.0 Introduction
• 1.1 Starting Access
• 1.2 Opening an Existing Database
• 1.3 The Access Desktop
• 1.4 The Database Window
• 1.5 A Preview of the Database Components

• 2.0 Working with an Existing Database
• 2.1 Viewing & Navigating Table Data
• 2.2 Editing Table Data
• 2.3 Adding Records to a Table
• 2.4 Selecting & Deleting Records
• 2.5 Find & Replace
• 2.6 Modifying the Appearance of a Datasheet
• 2.7 Spell-Check & Auto-correct

• 3.0 Form Basics
• 3.1 Moving from Record to Record
• 3.2 Finding
• 3.3 Sorting
• 3.4 Filtering
• 3.5 AutoForms
• 3.6 Using a Form Wizard
• 3.7 Conditional Formatting

• 4.0 Report Basics
• 4.1 Moving from Page to Page
• 4.2 Zooming In & Out
• 4.3 Viewing Multiple Pages
• 4.4 Printing
• 4.5 AutoReports & the Report Wizard
• 4.6 Printing Database Objects

Access XP: Intermediate Level

• 1.0 Planning & Designing a Database
• 1.1 Evaluating Inputs & Outputs
• 1.2 Normalization
• 1.3 Creating a Database Using a Wizard
• 1.4 Creating a Database from Scratch

• 2.0 Building & Modifying Tables
• 2.1 Creating Tables Using a Wizard
• 2.2 Creating Tables without the Use of a Wizard
• 2.3 Setting Primary Keys
• 2.4 Field Properties
• 2.5 Input Masks
• 2.6 The Lookup Wizard
• 2.7 Indexes

• 3.0 Working with Relationships
• 3.1 Introduction to Relationships
• 3.2 Types of Relationships
• 3.3 Referential Integrity
• 3.4 Indexes & Relationships
• 3.5 Printing Relationships

Access XP: Advanced Level

• 1.0 Designing Simple Queries
• 1.1 Selecting Fields
• 1.2 Ordering the Query Result & Refining Queries with Criteria
• 1.3 Updatability of Query Results
• 1.4 Queries Based on Multiple Tables

• 2.0 Building & Modifying Forms
• 2.1 Adding Controls
• 2.2 Selecting Controls
• 2.3 Moving, Sizing, & Deleting Controls
• 2.4 Aligning Controls

• 2.5 Changing Control Properties
• 2.6 Changing the Tab Order Controls
• 2.7 Form Properties
• 2.8 Working with Combo Boxes & List Boxes

• 3.0 Building & Modifying Reports
• 3.1 Understanding Report Bands
• 3.2 Working with Controls
• 3.3 Creating Groups & Total Reports
• 3.4 Working with Report Properties
• 3.5 Modifying Selection Criteria

Excel XP: Beginner Level

• 1.0 The Excel Screen
• 1.1 Overview
• 1.2 Screen Elements

• 2.0 Entering Data
• 2.1 Data Entry Techniques
• 2.2 AutoFill Entry Techniques
• 2.3 Erasing Data
• 2.4 AutoComplete
• 2.5 Undo and Re-do

• 3.0 Entering Formulas
• 3.1 Three Methods of Entering Formulas
• 3.2 Repeating a Formula in Adjacent Cells
• 3.3 Formulas Beyond Addition & Subtraction

• 4.0 Basic Excel Functions
• 4.1 Summation
• 4.2 Recalculating Effects & Hierarchy of Operations
• 4.3 Other Functions

• 5.0 Formatting
• 5.1 The Formatting Toolbar
• 5.2 Adjusting Widths and Row Heights
• 5.3 Numeric Formatting

• 6.0 Saving, Opening and Closing Files
• 6.1 File Save and File Save As
• 6.2 Opening a File
• 6.3 Creating a New Workbook

• 7.0 The Help System
• 7.1 Using the Help System

• Excel XP: Intermediate Level

• 1.0 Changing Worksheet Layout
• 1.1 Inserting Columns, Rows, & Cells
• 1.2 Deleting Columns, Rows, & Cells
• 1.3 Moving Cells
• 1.4 Copying Cells

• 2.0 Additional Formatting
• 2.1 Formatting Cell Attributes & Alignment
• 2.2 Borders
• 2.3 Numeric Formatting
• 2.4 Centering Text Across Columns
• 2.5 Hiding & Unhiding Columns & Rows

• 3.0 Printing
• 3.1 Using Print Preview & Page Setup
• 3.2 Printing Controls
• 3.3 Using Page Break & Preview

• 4.0 Using Cell References
• 4.1 Absolute References
• 4.2 Mixed References

• 5.0 The Tools Options Command
• 5.1 Show/Hide Gridlines & Formulas
• 5.2 Recently Used File List
• 5.3 Sheets in New Workbook
• 5.4 Default Settings

Excel XP: Advanced Level

• 1.0 Adjusting Worksheet Views
• 1.1 Freeze/Unfreeze Panes
• 1.2 Horizontal and Vertical Split Screens

• 2.0 Auditing Techniques
• 2.1 Using the Formula Auditing Toolbar
• 2.2 Tracing Dependent Cells
• 2.3 Tracing Precedent Cells

• 3.0 The IF and VLOOKUP Functions
• 3.1 The IF Functions & Relational Operators
• 3.2 Using Words in IF Functions
• 3.3 Using Logical Operators (AND & OR) with the IF Function
• 3.4 Nested IF Functions
• 3.5 Getting Data from the Table with a VLOOKUP Function

• 4.0 Date & Time Functions
• 4.1 Using Dates as Values
• 4.2 Entering a Series of Dates
• 4.3 Date/Time Entry Techniques

• 5.0 Multi-Sheet Workbooks
• 5.1 Renaming & Reordering Sheets
• 5.2 Inserting & Deleting Sheets
• 5.3 Moving, Copying, & Grouping Sheets
• 5.4 Formulas Across Multiple Sheets

Outlook XP: Beginner Level

• 1.0 Introducing Outlook
• 1.1 Starting Outlook
• 1.2 Discovering Outlook Components & Identifying Main Window

• 2.0 Exploring Outlook
• 2.1 Using the Outlook Bar
• 2.2 Using the Folder List Box
• 2.3 Using a Toolbar
• 2.4 Viewing Outlook Today

• 3.0 Reading & Sending Mail
• 3.1 Displaying Mail Icons
• 3.2 Attachments
• 3.3 Creating & Sending a New Mail Message
• 3.4 Adding an Attachment to a Message
• 3.5 Formatting a Message
• 3.6 Saving a Message in the Drafts Folder

• 4.0 Replying to & Forwarding Messages
• 4.1 Forwarding a Message
• 4.2 Forwarding Responses Automatically
• 4.3 Additional Message Options

• 5.0 Using Address Books
• 5.1 Adding & Editing a Contact
• 5.2 Adding an Address from a Message
• 5.3 Sending a Message from the Address Book
• 5.4 Creating & Using Distribution Lists
• 5.5 Exporting Addresses
• 5.6 Importing an Address Book
• 5.7 Displaying Contacts in Various Views

• 6.0 Printing in Outlook
• 6.1 Printing Items in Outlook
• 6.2 Print Options

• 7.0 Deleting in Outlook
• 7.1 Deleting Items
• 7.2 Emptying Deleted Items

Outlook XP: Intermediate Level

• 1.0 Using the Calendar
• 1.1 Creating an Appointment
• 1.2 Creating a Recurring Appointment
• 1.3 Editing an Appointment
• 1.4 Setting Appointment Reminder Options
• 1.5 Responding to a Reminder

• 2.0 Changing Calendar View & Display Options
• 2.1 Switching Between View Options
• 2.2 Additional Display Settings

• 3.0 Planning Meetings & Appointments
• 3.1 Creating & Sending a Meeting Request
• 3.2 Responding to a Meeting Request
• 3.3 Finding an Appointment
• 3.4 Setting up Your Work Schedule

• 4.0 Creating & Responding to Tasks
• 4.1 Creating a Task
• 4.2 Creating a Recurring Task
• 4.3 Creating a Task Request
• 4.4 Responding to a Task Request
• 4.5 Scheduling Time for a Task
• 4.6 Setting Tasks Default Options

• 5.0 Journal Entries
• 5.1 Creating a Journal Entry
• 5.2 Creating Automatic Journal Entries
• 5.3 Editing a Journal Entry
• 5.4 Journal Entry Views

• 6.0 Using Notes
• 6.1 Creating & Using Notes
• 6.2 Editing, Sorting, & Viewing Notes

• 7.0 Organizing, Recalling, & Resending Messages
• 7.1 Creating Folders
• 7.2 Moving a Message to Another Folder
• 7.3 Automating Your Mailbox
• 7.4 Recalling a Message

• 8.0 Customizing Toolbars
• 8.1 Di8splaying Toolbars
• 8.2 Customizing Toolbars
• 8.3 Creating a New Toolbar Button

Outlook XP: Advanced Level

• 1.0 Advanced Mail Message Options
• 1.1 Automatic Spell Checking
• 1.2 Creating a Signature in Outlook
• 1.3 Setting the Default Message
• 1.4 Setting the Default Stationary

• 2.0 Filtering, Finding & Flagging
• 2.1 Filtering Unwanted Messages
• 2.2 Finding Mail Messages
• 2.3 Flagging Messages
• 2.4 Flagging a Message from a Particular Sender
• 2.5 Completing & Clearing a Flag

• 3.0 Advanced Contact Options
• 3.1 Finding Contact Information from an E-mail
• 3.2 Contact-Related Activities

• 4.0 Archiving Outlook Data
• 4.1 Running the Manual Archive
• 4.2 Retrieving Archived Items
• 4.3 Enabling & Disabling AutoArchive
• 4.4 Setting Archive Properties for Items

• 5.0 Public Folders
• 5.1 Creating a Public Folder
• 5.2 Public Folder Permissions
• 5.3 Public Folder Conversations
• 5.4 Posting Documents to Public Folder

• 6.0 Multiple E-Mail Accounts
• 6.1 Creating Multiple E-mail Accounts
• 6.2 Sending Mail from Multiple Accounts

• 7.0 Speech Input
• 7.1 Setting Up Voice Recognition
• 7.2 Voice Commands
• 7.3 Dictation

• 8.0 Mailbox Cleanup
• 8.1 Mailbox Cleanup Feature

PowerPoint XP: Beginner Level

• 1.0 Getting Started
• 1.1 What is PowerPoint?
• 1.2 Starting PowerPoint XP
• 1.3 Touring the PowerPoint Window

• 2.0 Creating a New Presentation
• 2.1 New Presentation Task Pane
• 2.2 AutoContent Wizard
• 2.3 Saving & Closing Your Work
• 2.4 Creating from a Design Template
• 2.5 Creating a Blank Presentation

• 3.0 Revising Presentations
• 3.1 Opening an Existing Presentation
• 3.2 Navigating in a Presentation

• 4.0 Editing Text
• 4.1 Viewing a Presentation
• 4.2 Creating a New Slide

• 5.0 Getting Help
• 5.1 Ask A Question Box
• 5.2 Office Assistant
• 5.3 PowerPoint Help Window
• 5.4 Context-Sensitive Help

• 6.0 Outlining
• 6.1 Entering Text in an Outline
• 6.2 Inserting an Outline from Microsoft Word

• 7.0 Modifying Slides, Paragraphs, & Text
• 7.1 Exporting an Outline

• 8.0 Adding & Modifying Slide Text
• 8.1 Adding & Moving Text
• 8.2 Formatting Text & Symbols
• 8.3 Changing Text Box Properties
• 8.4 AutoCorrect & AutoFormat
• 8.5 Outline vs. Slide

• 9.0 Preparing Presentations
• 9.1 Checking Spelling
• 9.2 Checking Presentation Styles
• 9.3 Speaker Notes
• 9.4 Adding a Header & Footer

• 10.0 Printing Presentations
• 10.1 Page Setup & Preview
• 10.2 Printing a Presentation
• 
  h4. PowerPoint XP: Intermediate Level

• 1.0 Developing Content
• 1.1 Planning & Communicating Effectively

• 2.0 Managing Presentations
• 2.1 Inserting Slides from Other Presentations
• 2.2 File & Folder Management
• 2.3 Search Task Pane
• 2.4 Find & Replace
• 2.5 Keyboard Shortcuts

• 3.0 Changing Design & Layout
• 3.1 Applying a Design Template
• 3.2 Changing the Layout of a Slide

• 4.0 Working with Masters
• 4.1 Modifying the Slide Master
• 4.2 Formatting Bullets
• 4.3 Handout & Notes Masters

• 5.0 Graphics & Pictures
• 5.1 Inserting Clip Art
• 5.2 Inserting Pictures
• 5.3 The Clip Organizer
• 5.4 Modifying Images

• 6.0 Creating & Formatting Objects
• 6.1 Adding & Editing an Object
• 6.2 Formatting Objects
• 6.3 Object Placement, Orientation, & Grouping
• 6.4 Enhancing Text with WordArt

PowerPoint XP: Advanced Level

• 1.0 Working with Tables
• 1.1 Creating Tables
• 1.2 Modifying & Formatting Tables

• 2.0 Working with Graphs & Charts
• 2.1 Inserting & Formatting a Graph
• 2.2 Creating an Organization Chart

• 3.0 Organizing Your Presentation
• 3.1 Rearranging & Summarizing Slides
• 3.2 Hiding, Duplicating, & Deleting Slides

• 4.0 Customizing PowerPoint
• 4.1 Menus & Toolbars
• 4.2 Customizing the Workspace
• 4.3 Changing User Options

• 5.0 Viewing & Changing Presentation Colors
• 5.1 Viewing & Choosing a Color Scheme
• 5.2 Creating a New Color Scheme
• 5.3 Adding & Modifying a Slide Background

• 6.0 Creating a Custom Design Template
• 6.1 Creating Multiple Master Slides
• 6.2 Adding a Custom Background
• 6.3 Saving & Applying a Custom Template

• 7.0 Preparing & Delivering a Slide Show
• 7.1 Adding Transitions
• 7.2 Applying Other Animation
• 7.3 Presenting a Slide Show

Word XP: Beginner Level

• 1.0 Getting Started
• 1.1 Starting Word 2002
• 1.2 Touring the Word Window

• 2.0 Creating New Documents
• 2.1 Starting a New Document
• 2.2 Entering Text
• 2.3 Saving Your Work
• 2.4 Printing & Closing a Document
• 2.5 Using a Template
• 2.6 Using a Wizard
• 2.7 Exiting Out of Word

• 3.0 Revising Documents
• 3.1 Opening a document
• 3.2 Navigating in a Document
• 3.3 Basic Editing
• 3.4 Click & Type
• 3.5 Smart Tags
• 3.6 Adding a Date
• 3.7 Adding an Envelope
• 3.8 Multiple Page Documents

• 4.0 Getting Help
• 4.1 Ask a Question
• 4.2 Office Assistant
• 4.3 Word Help Window
• 4.4 Context Sensitive

• 5.0 Shortcuts
• 5.1 Shortcut Menus
• 5.2 Keyboard Shortcuts
• 5.3 Work the Way You Want

• 6.0 Essential Skills
• 6.1 Selecting Text
• 6.2 Copying & Moving Text
• 6.3 Clipboard Task Pane
• 6.4 Undo, Redo, & Repeat
• 6.5 AutoCorrect
• 6.7 AutoComplete

• 7.0 Formatting Text & Paragraphs
• 7.1 Working with Fonts
• 7.2 Symbols & Special Characters
• 7.3 Paragraph Alignment & Line Spacing

• 8.0 Proofreading & Printing Documents
• 8.1 Spelling & Grammar
• 8.2 Thesaurus & Word Count
• 8.3 Previewing & Printing

Word XP: Intermediate Level

• 1.0 Managing Documents
• 1.1 Document Views
• 1.2 Working with Multiple Documents
• 1.3 File & Folder Management
• 1.4 Search Task Pane

• 2.0 Additional Editing Tools
• 2.1 AutoText
• 2.2 Find & Replace
• 2.3 Format Painter

• 3.0 Page Layout
• 3.1 Margins & Page Setup
• 3.2 Page Breaks

• 4.0 Customizing Word
• 4.1 Menus & Toolbars
• 4.2 Changing Defaults
• 4.3 User Options

• 5.0 Understanding Formatting in Word
• 5.1 Formatting Choices
• 5.2 Reveal Formatting Task Pane

• 6.0 Paragraph Formatting
• 6.1 Tabs
• 6.2 Indents
• 6.3 Bullets & Numbering
• 6.4 Line Breaks
• 6.5 Spacing Before & After
• 6.6 Styles & Formatting Task Pane
• 6.7 Sorting Text
• 6.8 Borders & Shading

• 7.0 Document Formatting
• 7.1 Numbering Pages
• 7.2 Headers & Footers

• 8.0 Mail Merge Basics
• 8.1 Understanding Mail Merge
• 8.2 Form Letters
• 8.3 Labels

• 9.0 Introduction to Graphics
• 9.1 Inserting Clip Art
• 9.2 Drawing & Modifying Shapes

Word XP: Advanced Level

• 1.0 Tables
• 1.1 Inserting Tables
• 1.2 Navigating in a Table
• 1.3 Modifying Tables
• 1.4 Formatting Tables

• 2.0 Formatting with Styles & Themes
• 2.1 Applying Styles
• 2.2 Styles & Formatting Task Pane
• 2.3 Creating & Modifying Styles
• 2.4 Applying a Theme

• 3.0 Document Templates
• 3.1 Personalizing Words Templates
• 3.2 Automating & Sharing a Template

• 4.0 Formatting
• 4.1 Section Formatting
• 4.2 Working with Columns

• 5.0 Long or Complex Documents
• 5.1 Bookmarks
• 5.2 Document Maps
• 5.3 Footnotes
• 5.4 Tables of Contents & Indexes
• 5.5 Outlines
• 5.6 Master Documents

• 6.0 Creating & Using Macros
• 6.1 Creating & Running Macros
• 6.2 Editing Macros
• 6.3 Automatic Macros