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

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

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

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

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

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

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

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

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

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

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

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

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

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

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