Level 1
1.0 Introduction to Access
1.1 Overview of Access
1.2 Tables
1.3 Forms
1.4 Queries
1.5 Reports
1.6 Section Summary
2.0 Creating a Database
2.1 Create a Blank Database
2.2 Creating a Table Using the Wizard
2.3 Creating a Table in the Design View
2.4 Creating a Table with Data Entry
2.5 Creating a Table by Importing Data
2.6 Section Summary
3.0 Table Utilities
3.1 Adding & Deleting Records
3.2 Adding & Deleting Fields
3.3 Printing Tables
3.4 Section Summary
4.0 Table Appearance
4.1 Hiding, Freezing, and Moving Columns
4.2 Fonts and Colors
4.3 Section Summary
5.0 Table Data Features
5.1 Finding & Replacing Data
5.2 Sorting Data
5.3 Filtering Data
5.4 Section Summary
6.0 Query Essentials
6.1 Setting Criteria
6.2 Wildcards
Level 1
1.0 The Excel Screen
1.1 The Excel Workbook
1.2 The Task Pane
1.3 Title Bar and Menu Bar
1.4 Toolbars
1.5 Formula
1.6 Columns & Rows
1.7 Navigation
1.8 Sheet Names & the Status Bar
1.9 Mouse Pointers & Shortcut Menus
2.0 Entering Data
2.1 Data Entry Techniques
2.2 AutoFill Entry Techniques
2.3 Erasing Data
2.4 AutoComplete & Pre-selection
2.5 IP Classes
3.0 Entering Formulas
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula in Adjacent Cells
3.3 Additional Formulas
4.0 Basic Excel Functions
4.1 Summation & Averaging
4.2 Recalculating Effects
4.3 Other Functions
5.0 Formatting
5.1 The Formatting Toolbar
5.2 Adjusting Column Widths
5.3 Numeric Formatting
6.0 Saving Files
6.1 File Save or File Save As
6.2 Opening & Closing a File
6.3 Creating a New Workbook
7.0 The Excel Help System
7.1 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
1.1 Section Summary
2.0 Creating a New Presentation
2.1 AutoContent Wizard
2.2 Saving & Closing Your Work
2.3 Creating from a Design Template
2.4 Section Summary
3.0 Opening, Navigating & Text Editing
3.1 Opening & 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 Ask a Question Box
4.2 Office Assistant
4.3 PowerPoint Help Window
4.4 Context-Sensitive Help
4.5 Section Summary
5.0 Outlining
5.1 Entering Text in an Outline
5.2 Inserting an Outline from Microsoft Word
5.3 Modifying Slides
5.4 Exporting an Outline
5.5 Section Summary
6.0 Slide Text
6.1 Adding and Moving Text
6.2 Formatting Text & Symbols
6.3 Changing Text Box Properties
6.4 Section Summary
7.0 Checking Spelling
7.1 Checking Spelling
7.2 AutoCorrect
7.3 AutoFormat
7.4 Section Summary
8.0 Delivering Presentations
8.1 Speaker Notes
8.2 Printing a Presentation
8.3 Section Summary
Level 1
1.0 Introduction to Word 2002
1.1 Launching Word 2002
1.2 Word Window Overview
2.0 Creating New Documents
2.1 Creating a New Document
2.2 Saving a Document
2.3 Using a Template
2.4 Using a Wizard
2.5 Exiting Out of Word
3.0 Working with Existing Documents
3.1 Opening a Document
3.2 Navigating a Document
3.3 Basic Editing
3.4 Adding a Date
3.5 Adding an Envelope
3.6 Printing a Document
3.7 Updating the Saved Document
4.0 Getting Help
4.1 Ask a Question
4.2 Office Assistant
4.3 Word Help Window
4.4 Context Sensitive
5.0 Essential Skills
5.1 Shortcuts
5.2 Toolbars
5.3 Selecting Text
5.4 Copying & Moving Text
5.5 Clipboard Task Pane
5.6 Undo/Redo & Repeat
6.0 Proofreading Documents
6.1 Spelling & Grammar
6.2 Thesaurus & Word Count
7.0 Level Summary
Level 2
1.0 Form Essentials
1.1 Creating Forms with AutoForm
1.2 Section Summary
2.0 Report Essentials
2.1 Exporting Reports
2.2 Using the Label Wizard
2.3 Section Summary
3.0 Field Properties
3.1 Date and Time
3.2 Custom Formats
3.3 Yes & No Fields
3.4 Default Value & Expression Builder
3.5 Validation Rule
3.6 Section Summary
4.0 Creating a Lookup
4.1 Limit to List
4.2 Section Summary
5.0 Importing and Exporting Data
5.1 Linking Data from Excel
5.2 Section Summary
6.0 Relationships
6.1 Creating Table Relationships
6.2 Enforcing Referential Integrity
6.3 Understanding Cascade Options
6.4 Printing Database Information
Level 2
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 and 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
5.2 File List & New Workbook
5.3 Default Settings
6.0 Introduction to Charting-An Overview
6.1 Quick Chart Creation
6.2 Chart Types
6.3 Titles/Gridlines & Scaling
6.4 Formatting Basics
6.5 Printing & 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 Section Summary
2.0 Slideshow Preparation
2.1 Design Template
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 Diagrams & Organizational Charts
4.5 Section Summary
5.0 Animation
5.1 Text Animation
5.2 Animating Graphics
5.3 Sound Effects
5.4 Section Summary
Level 2
1.0 Managing Documents
1.1 Working with Multiple Documents
1.2 File & Folder Management
1.3 Search Task Pane
2.0 Formatting Text & Paragraphs
2.1 Working with Fonts
2.2 Formatting Paragraphs
3.0 Additional Editing Tools
3.1 Special Characters & Autocorrect
3.2 Auto Complete
3.3 Auto Text
3.4 Find & Replace
3.5 Format Painter
4.0 Page Layout
4.1 Margins & Page Setup
4.2 Adjusting Margins with Rulers
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 Reports Based on Parameter Queries
1.2 Setting up Calculated Fields
1.3 Overview of the Expression Builder
1.4 Creating Summary Queries
1.5 Section Summary
2.0 Access & HTML
2.1 Publishing Database to HTML Format
2.2 Data Access Pages
2.3 Section Summary
3.0 Merging Access into Word
3.1 Running the Merge
3.2 Section Summary
4.0 Action Queries
4.1 Running an Append Query
4.2 Running a Delete Query
4.3 Running a Update Query
4.4 Section Summary
5.0 Database Maintenance
5.1 Database Backup
5.2 Section Summary
6.0 Advanced Form Design
6.1 Creating & Using Form Controls
6.2 Calculated Controls
6.3 Section Summary
7.0 Advanced Form Modification
7.1 Adding Fields
7.2 Adjusting Tab Order
7.3 Section Summary
8.0 Advanced Report Design
8.1 Modifying Controls
8.2 Adding Controls
8.3 Sorting and Grouping Report Data
8.4 Working with the Pagebreak Control
Level 3
1.0 Adjusting Worksheet Views
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split Screens
2.0 Formula Auditing Techniques
2.1 Using the Formula Auditing Toolbar
2.2 Tracing Dependent Cells
2.3 Tracing Precendent Cells
3.0 The IF & VLOOKUP Functions
3.1 IF & VLOOKUP Functions Operators
3.2 Logical Operators
3.3 Nested IF Functions
3.4 Getting Data from Tables
4.0 Dates & Times
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 Sheets
5.2 Inserting & Deleting Sheets
5.3 Moving/Copying & Grouping
5.4 Formulas across Multiple Sheets
6.0 Introduction to Database Features
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 Create a New Toolbar
1.3 Add/Remove Buttons to Toolbar
1.4 Additional Display Options
1.5 Section Summary
2.0 Creating Tables & 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 Movie from Clip Organizer
3.2 Inserting Video
3.3 Inserting CD Audio
3.4 Sound from Clip Organizer and File
3.5 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
5.1 Slide Transitions
5.2 Notes
5.3 Section Summary
6.0 Delivering Your Presentation
6.1 Presentation Techniques
6.2 Presenter View
6.3 Section Summary
Level 3
1.0 Understanding Formatting in Word
1.1 Formatting Choices
1.2 Reveal Formatting Task Pane
2.0 Paragraph Formatting
2.1 Tabs
2.2 Indenting
2.3 Spacing Before & After
2.4 Line Breaks
2.5 Bullets & Numbering
2.6 Outlines
2.7 Sorting Text
2.8 Borders & Shading
3.0 Document Formatting
3.1 Numbering Pages
3.2 Headers & Footers
4.0 Columns
4.1 Working with Columns
5.0 Formatting with Styles
5.1 Applying Styles
5.2 Styles & Formatting Task Pane
5.3 Modifying an Existing Style
5.4 Creating a Style
6.0 Tables
6.1 Inserting Tables
6.2 Modifying Tables
6.3 Formatting Tables
6.4 Formulas
6.5 Creating a Chart
7.0 Complex Documents
7.1 Bookmarks
7.2 Table of Contents & Indexes
8.0 Level 3 Summary
| 