Level 1
1.0 Introduction
1.1 Basic Concepts
1.2 Overview of Access
1.3 Tables
1.4 Forms
1.5 Queries
1.6 Reports
1.7 Section Summary
2.0 Creating a Database
2.1 The Database Wizard
2.2 Create a Blank Database
2.3 Creating a Table Using the Wizard
2.4 Creating a Table in the Design View
2.5 Creating a Table with Data Entry
2.6 Creating a Table by Importing Data
2.7 Section Summary
3.0 Table Utilities
3.1 Editing Table Data
3.2 Adding & Deleting Records
3.3 Adding & Deleting Fields
3.4 Printing a Table
3.5 Section Summary
4.0 Table Appearance
4.1 Column Widths and Row Heights
4.2 Hiding, Freezing, and Moving Columns
4.3 Fonts and Colors
4.4 Section Summary
5.0 Table Data Features
5.1 Working with Fields in Design View
5.2 Finding & Replacing Data
5.3 Sorting Data
5.4 Filtering Data
5.5 Section Summary
6.0 Query Essentials
6.1 Creating a Simple Query
6.2 Setting Criteria
6.3 Wildcards
Level 1
1.0 The Excel Screen
1.1 The Excel Workbook and Worksheets
1.2 Title Bar and Menu Bar
1.3 Toolbars
1.4 Formula Bar
1.5 Columns and Rows
1.6 Navigation
1.7 Sheet Names and the Status Bar
1.8 Mouse Pointers and Shortcut Menus
1.9 Section Summary
2.0 Entering Data
2.1 Data Entry Techniques
2.2 AutoFill Entry Techniques
2.3 Erasing Data
2.4 AutoComplete and Pre-Selection
2.5 Undo and Redo
2.6 Section Summary
3.0 Working With Existing Documents
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula in Adjacent Cells
3.3 Additional Formulas
3.4 Section Summary
4.0 Basic Excel Functions
4.1 Summation
4.2 Recalculating & Hierarchy of Operations
4.3 Other Functions
4.4 Section Summary
5.0 Formatting
5.1 The Formatting Toolbar
5.2 Adjusting Column Widths & Row Heights
5.3 Numeric Formatting
5.4 Section Summary
6.0 Saving, Opening and Closing Files
6.1 File Save or File Save As
6.2 Opening and Closing a File
6.3 Creating a New Workbook
6.4 Section Summary
7.0 The Excel Help System
Level 1
1.0 Introducing Outlook
1.1 Launching Outlook
1.2 Overview of the Outlook Interface
1.3 Folder List
1.4 Outlook Today
2.0 Reading Mail Messages
2.1 Opening and Closing a Mail Message
2.2 Accessing Attachments
3.0 Deleting Items in Outlook
3.1 Restoring a Deleted Item
4.0 Sending Mail Messages
4.1 Sending a New Mail Message
4.2 Adding an Attachment to a Message
4.3 Advanced Formatting Options
4.4 Saving a Draft Message
4.5 Sending to Multiple Recipients
4.6 Sending Over the Internet
5.0 Replying, Forwarding Messages
5.1 Replying to a Message
5.2 Forwarding a Message to Someone Else
6.0 Using Outlook's Address Books
6.1 Adding and Editing a Contact
6.2 Adding a Contact From a Message
6.3 Sending a Message From Contact List
6.4 Using Distribution Lists
7.0 Printing
7.1 Printing Items in Outlook
7.2 Print Attachments
Level 1
1.0 Introduction to PowerPoint 2000
1.1 PowerPoint Screen Elements
1.2 Section Summary
2.0 Creating a New Presentation
2.1 AutoContent Wizard
2.2 Creating From a Design Template
2.3 Saving and Closing Your Work
2.4 Section Summary
3.0 Opening, Navigating & Text Editing
3.1 Opening and Navigating a Presentation
3.2 Editing Text
3.3 Viewing a Presentation
3.4 Creating a New Slide
3.5 Section Summary
4.0 Getting Help
4.1 PowerPoint Help Options
4.2 Section Summary
5.0 Outlining
5.1 Entering Text in an Outline
5.2 Inserting an Outline from Microsoft Word
5.3 Exporting an Outline
5.4 Section Summary
6.0 Slide Text
6.1 Adding and Moving Text
6.2 Symbols
6.3 Formatting Text
6.4 Changing Text Box Properties
6.5 Section Summary
7.0 Checking Spelling
7.1 PowerPoint Spell Checker
7.2 AutoCorrect
7.3 Section Summary
8.0 Printing Presentations
8.1 Speaker Notes
8.2 Printing the Presentation
8.3 Section Summary
Level 1
1.0 Microsoft Word 2000
1.1 Launching Word 2000
1.2 Word Window Overview
2.0 New Documents
2.1 Creating a New Document
2.2 Templates
2.3 Wizards
2.4 Saving Your Documents
3.0 Working With Existing Documents
3.1 Opening a Document
3.2 Navigation Within a Document
3.3 Basic Editing
3.4 Selecting Text
3.5 Moving Text
3.6 Printing a Document
3.7 Updating a Saved Document
4.0 The Word 2000 Help System
4.1 Getting Help
5.0 Customizing Word 2000
5.1 Toolbars
5.2 Resetting the Toolbars
5.3 General Word Options
6.0 Proofreading and Printing
6.1 Spelling and Grammar
Level 2
1.0 Form Essentials
1.1 Using the Form Wizard
1.2 Creating Forms with AutoForm
1.3 Section Summary
2.0 Report Essentials
2.1 Using the Report Wizard
2.2 Exporting Reports
2.3 Using the Label Wizard
2.4 Section Summary
3.0 Field Properties
3.1 Field Size
3.2 Date & Time
3.3 Custom Formats
3.4 Yes & No Fields
3.5 Default Value & Expression Builder
3.6 Validation Rule
3.7 Section Summary
4.0 Creating a Lookup
4.1 Creating a Lookup Field
4.2 Limit to List
4.3 Section Summary
5.0 Importing & Exporting Data
5.1 Importing/Exporting
5.2 Linking Data from Excel
5.3 Section Summary
6.0 Relationships
6.1 Relationship Concepts
6.2 Creating Table Relationships
6.3 Enforcing Referential Integrity
6.4 Understanding Cascade Options
6.5 Printing Database Information
Level 2
1.0 Changing Worksheet Layout
1.1 Inserting Columns, Rows, and Cells
1.2 Deleting Columns, Rows, and Cells
1.3 Moving Cells
1.4 Copying Cells
1.5 Section Summary
2.0 Additional Formatting
2.1 Formatting Cell Attributes and Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Centering Text Across Columns
2.5 Hiding and Unhiding Columns and Rows
2.6 Section Summary
3.0 Printing
3.1 Using Print Preview and Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
3.4 Section Summary
4.0 Using Cell References
4.1 Absolute References
4.2 Mixed References
4.3 Section Summary
5.0 The Tools Options Command
5.1 Show/Hide Gridlines and Formulas
5.2 File List and New Workbook Sheets
5.3 Default Settings
5.4 Section Summary
6.0 Introduction to Charting - An Overview
6.1 Quick Chart Creation
6.2 Chart Types
6.3 Titles, Gridlines, and Scaling
6.4 Formatting Basics
6.5 Printing and Copying Charts
Level 2
1.0 Managing Your Calendar
1.1 Calendar Views and Display Options
1.2 Setting Your Work Schedule
1.3 Creating Personal Appointments
1.4 Inviting Additional Attendees
1.5 Checking Attendee Schedules
1.6 Responding to a Meeting Request
1.7 Creating Recurring Appointments
2.0 Managing Your Tasks
2.1 Creating a Task and a Recurring Task
2.2 Responding to a Task Request
2.3 Scheduling Time For a Task
3.0 Using the Outlook Journal
3.1 Tracking Contact Activities
3.2 Creating a Journal Entry
4.0 Organizing Messages
4.1 Creating Personal Folders
4.2 Moving a Message to Another Folder
4.3 Automating Your Mailbox
5.0 Outlook Help
5.1 Accessing Online Help
Level 2
1.0 Effective Presentation Planning
1.1 Presentation Goals
1.2 Section Summary
2.0 Slideshow Preparation
2.1 Design Templates
2.2 Master View
2.3 Section Summary
3.0 Inserting Content
3.1 Inserting Text
3.2 Inserting Clipart
3.3 Inserting Files
3.4 Section Summary
4.0 Additional Graphic Content
4.1 Word Art
4.2 AutoShapes
4.3 Grouping Objects
4.4 Organizational Charts
4.5 Section Summary
5.0 Animation
5.1 Text Animation
5.2 Animating Graphics
5.3 Section Summary
Level 2
1.0 Managing Documents
1.1 Working With Multiple Documents
1.2 Splitting a Document View
1.3 File and Folder Management
1.4 Finding Documents
2.0 Text and Paragraphs
2.1 Formatting Text
2.2 Formatting Paragraphs
3.0 Page Layout
3.1 Margins
3.2 Page Setup
4.0 Additional Editing Tools
4.1 Symbols and Special Characters
4.2 AutoCorrect and AutoText
4.3 Find and Replace
4.4 Format Painter
5.0 Introduction to Graphics
5.1 Inserting Clip Art
5.2 Inserting Picture Files
5.3 AutoShapes
5.4 WordArt
Level 3
1.0 Advanced Query Techniques
1.1 Using Parameter Queries
1.2 Reports Based on Parameter Queries
1.3 Setting up Calculated Fields
1.4 Overview of the Expression Builder
1.5 Creating Summary Queries
1.6 Section Summary
2.0 Access & HTML
2.1 Creating & Using Hyperlinks
2.2 Publishing Database to HTML Format
2.3 Data Access Pages
2.4 Section Summary
3.0 Action Queries
3.1 Making a Table Query
3.2 Running an Append Query
3.3 Running a Delete Query
3.4 Running an Update Query
3.5 Section Summary
4.0 Database Maintenance
4.1 Using Compact & Repair Utility
4.2 Database Backup
4.3 Section Summary
5.0 Advanced Form Design
5.1 Creating & Using Form Controls
5.2 Calculated Controls
5.3 Section Summary
6.0 Advanced Form Modification
6.1 Manipulating Form Controls
6.2 Adding Fields
6.3 Adjusting Tab Order
6.4 Section Summary
7.0 Advanced Report Design
7.1 Understanding the Report Design
7.2 Modifying Controls
7.3 Adding Controls
7.4 Sorting and Grouping Report Data
7.5 Working with the Pagebreak Control
Level 3
1.0 Adjusting Worksheet Views
1.1 Freeze/Unfreeze Panes
1.2 Horizontal and Vertical Split Screens
1.3 Section Summary
2.0 Formula Auditing Techniques
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
2.4 Section Summary
3.0 The IF and VLOOKUP Functions
3.1 IF Functions and Relational Operators
3.2 Logical Operators with the IF Function
3.3 Nested IF Functions
3.4 The VLOOKUP Function
3.5 Section Summary
4.0 Dates and Times
4.1 Using Dates as Values
4.2 Entering a Series of Dates
4.3 Date/Time Entry Techniques
4.4 Section Summary
5.0 Multi-sheet Workbooks
5.1 Renaming Sheets
5.2 Inserting and Deleting Sheets
5.3 Moving, Copying, and Grouping
5.4 Formulas Across Multiple Sheets
5.5 Section Summary
6.0 Intro to Database Features - An Overview
6.1 Sorting Data
6.2 Creating Subtotals
6.3 Filtering
6.4 Pivot Tables
Level 3
1.0 Customizing Toolbars
1.1 Displaying Toolbars
1.2 Customizing Toolbars
1.3 Creating a New Toolbar
1.4 Customizing the Outlook Bar
2.0 Advanced Mail Message Options
2.1 Automatic Spell Checking
2.2 Auto Correct
2.3 Message Signatures
2.4 Additional Message Options
3.0 Finding Messages
3.1 Finding Mail Messages
3.2 Advanced Find
4.0 Recalling & Resending Messages
4.1 Recalling a Message
4.2 Resending a Message
5.0 Flagging Items
5.1 Flagging an Item
5.2 Sorting a Folder
5.3 Marking a Flagged Item Complete
6.0 AutoArchive
6.1 Using AutoArchive
6.2 Viewing Archived Items
6.3 Restoring Archived Items
7.0 Public Folders
7.1 Creating a Public Folder
7.2 Accessing and Using a Public Folder
Level 3
1.0 Customizing the Interface
1.1 Toolbars
1.2 Creating a new Toolbar
1.3 Add/Remove Buttons to the Toolbars
1.4 Additional Display Options
1.5 Section Summary
2.0 Creating Tables and Charts
2.1 Creating a Table
2.2 Creating a Chart
2.3 Linking to an Excel Spreadsheet
2.4 Section Summary
3.0 Video & Audio Objects
3.1 Inserting Video
3.2 Inserting CD Audio
3.3 Sound from Clip Organizer and File
3.4 Section Summary
4.0 Organizing Your Presentation
4.1 Inserting Slide from another Presentation
4.2 Rearranging Slides
4.3 Creating a Summary Slide
4.4 Hiding Slides
4.5 Section Summary
5.0 Final Preparation & Delivery
5.1 Slide Transitions
5.2 Section Summary
Level 3
1.0 Understanding Formatting in Word 2000
1.1 Character Formatting and Fonts
1.2 Viewing the Document's Formatting
2.0 Paragraph Formatting
2.1 Tabs
2.2 Indents
2.3 Paragraph Spacing
2.4 Line Breaks
2.5 Bullets and Numbering
2.6 Outlines
2.7 Borders and Shading
3.0 Document Formatting
3.1 Numbering Pages
3.2 Headers and Footers
4.0 Columns
4.1 Creating and Managing Columns
5.0 Formatting with Styles
5.1 Styles
6.0 Tables
6.1 Inserting Tables
6.2 Modifying Tables
6.3 Formatting Tables
6.4 Formulas
7.0 Long Documents
7.1 Table of Contents
7.2 Indexes
| 