Office 2007 Complete Training Bundle

MS Word 2007 Level One

Lesson 1 - Exploring the Word Environment
Exploring the Word Environment
Document
Microsoft Office Word 2007
Word Document
Demo - Explore Word
Lab - Exploring the User Interface Elements in a Word Environment
The Microsoft Office Button
The Ribbon
Lab - Exploring the Various Elements on the Ribbon
The Microsoft Office Window Frame
The Home Tab
The Insert Tab
The Page Layout Tab
The Review Tab
The View Tab
Dialog Box Launchers
Galleries
Live Preview
Document Views
Demo - View Document
Lab - Viewing a Document
Word Help
Word Help Options
Demo - Help
Word Help Toolbar
Lab - Searching for Information Using Microsoft Word Help
Lesson 1 Review

Lesson 2 - Creating a Document
Creating a Document
AutoCorrect Dialog Box
Word Wrap
Formatting Marks
Saving Files
Demo - Create Document and Save
Save As Command
Lab - Saving a Document
Compatibility Checker
Print Preview Options
Demo - Preview and Print
Print Dialog Box
Lab - Previewing a Document
Lab - Printing a Document
Word Options Dialog Box
Demo -Word Options
Lab - Customizing the Microsoft Office User Interface
Lab - Customize the Microsoft Office Window Frame
Lesson 2 Review

Lesson 3 - Editing a Document
Editing a Document
Scroll Bars
Selection Bar
Demo - Move Cursor and Selecting Text
Mini Toolbar
Clipboard Group
Text Pasting Options
Demo - Cut, Copy, and Paste
Lab - Moving Text Within a Document
Lab - Copying Text Between Documents
Lab - Pasting Text in a Document
Clipboard Task Pane
Find And Replace Dialog Box
Find Options
Replace Options
Demo - Search and Replace
Go To Options
Lesson 3 Review

Lesson 4 - Formatting Text
Formatting Text
Styles
Fonts
Font Styles
Font Case
Demo - Change Font and Size
Lab - Changing the Font and Font Size
Effects
Demo - Font Styles and Effects
Lab - Applying Font Styles and Effects
Lab - Change Text Color
Lab - Highlighting Text in a Document
Lab - Removing Text Highlights
Reveal Formatting Task Pane
Demo - Paste Formats
Demo - Clear Formatting
Lab - Clearing Text Formatting
Lesson 4 Review

Lesson 5 - Formatting Paragraphs
Formatting Paragraphs
Margins
Rulers
Tabs Dialog Box
Demo - Tab Stops
Indents
Indentation Options
Demo - Alignment
Lab - Aligning Paragraphs
Borders
Shading
Borders And Shading Dialog Box
Demo - Indents and Borders
Lab - Applying Borders and Shading to a Paragraph
Quick Styles in Word
Styles Task Pane
Lab - Applying Paragraph Styles
List
Bulleted List
Numbered List
Demo - Styles, Bullets, and Numbers
Text Spacing Options
Lab - Changing the Space Between Lines of Text
Lesson 5 Review

Lesson 6 - Adding Tables
Adding Tables
Tables
Contextual Tabs
Table Tools Design Contextual Tab
Table Properties Dialog Box
Quick Tables
Demo - Insert Columns and Rows
Lab - Inserting a Table
Table Styles
Demo - Format a Table
Table Style Options Group
Convert Text To Table Dialog Box
Convert Table To Text Dialog Box
Demo - Creating a Table and Adding Text
Demo - Convert Text to Table
Lab - Converting Text to Table
Lesson 6 Review

Lesson 7 - Enhancing Visual Appeal Using Graphic Objects
Enhancing Visual Appeal Using Graphic Objects
Symbols
Special Characters
Illustrations
Picture
Clip Art
Illustrations Group
Clip Art Task Pane
Sizing Handles
Demo - Insert Graphics
Lab - Inserting a Picture from Clip Art
Picture Tools Format Contextual Tab
Watermark
Printed Watermark Dialog Box
Demo -Watermarks
Lab - Adding a Text Watermark
Lesson 7 Review

Lesson 8 - Proofing a Document
Proofing a Document
Research Task Pane
Thesaurus
Lab - Using a Thesaurus to Replace a Word
Research Options Dialog Box
Readability Statistics Dialog Box
Spelling and Grammar Options
Demo - Spelling and Grammar
Lab - Checking a Documents Spelling and Grammar
Custom Dictionary
Custom Dictionaries Dialog Box
Demo - Autocorrect
Lab - Customizing the AutoCorrect Options
Lab - Counting Words in a Document
Lesson 8 Review

Lesson 9 - Controlling Page Appearance
Controlling Page Appearance
Page Orientation
Paper Size
Page Setup Dialog Box
Demo - Margins and Orientation
Lab - Changing a Documents Page Orientation and Margin
Page Border
Border Types
Demo - Borders and Art
Lab - Applying an Art Page Border
Page Color
Headers and Footers
Header & Footer Design Contextual Tab
Demo - Headers and Footers
Lab - Adding a Header and Footer
Lab - Modifying Headers and Footers
Demo - Page Breaks
Lab - Inserting Manual Page Breaks
Lab - Modifying a Document in Print Preview
Lesson 9 Review
Course Closure

MS Word 2007 Level Two

Lesson 1 - Managing Lists
Managing Lists
Sort Field
Demo - Sorting a List
Lab - Sorting a List
Renumbering Options
Demo - Renumbering Lists
Lab - Renumbering Lists
Multilevel Lists
Multilevel List Gallery
Demo - Multilevel Lists
Lab - Structuring a List on Multiple Levels
Lab - Customizing a List
Lesson 1 Review

Lesson 2 - Customizing Tables and Charts
Customizing Tables and Charts
Cell Merge
Cell Split
Text Positioning Options
Cell Alignment
Text Orientation
Demo - Formatting a Table and Cell Alignment
Lab - Modifying Cell Structure
Lab - Positioning Text in a Cell
Demo - Borders and Shading
Lab - Applying Borders and Shading
Lab - Sorting Data in a Table
Equations
Equation Tool
Function
Lab - Building an Equation
Formulas in Word Table
Demo - Typing Formulas
Demo - Creating Formulas
Lab - Performing Calculations in a Table
Charts
Chart In Microsoft Office Word Window
Demo - Creating Charts
Lab - Creating a Chart
Lesson 2 Review

Lesson 3 - Customizing Character and Paragraph Formats
Customizing Character and Paragraph Formats
Character Spacing
Character Spacing Options
Demo - Character Spacing
Lab - Controlling Character Appearance
Formatting Paragraphs
Demo - Paragraph Spacing
Lab - Controlling Paragraph Flow
Lesson 3 Review

Lesson 4 - Customizing Styles for Document Elements
Customizing Styles for Document Elements
Paragraph Styles
Character Styles
Custom Styles
Lab - Creating a Custom Style
Templates in Word
Style Modification Options
Lab - Modifying a Style
List Style
The Define New List Style Dialog Box
Lab - Creating a List Style
Table Style
Lab - Creating a Table Style
Demo - Styles
Demo - Modifying Styles
Lesson 4 Review

Lesson 5 - Modifying Pictures
Modifying Pictures
Cropping
Demo - Picture Cropping
Lab - Resizing a Picture
Picture Contrast
Picture Brightness
The Recolor Gallery
Demo - Picture Properties
Lab - Setting Picture Prominence
Text Wrapping Style
Lab - Setting the Text Wrapping Style for a Picture
Lesson 5 Review

Lesson 6 - Creating Customized Graphic Elements
Creating Customized Graphic Elements
Shapes in Word
Drawing Canvas
Demo - Adding Shapes
Lab - Drawing a Shape
WordArt
WordArt Tools Format Contextual Tab
Demo -WordArt
Drop Caps
Lab - Adding Special Effects to Text
Text Box
Text Box Tools Format Contextual Tab
Lab - Displaying Text as Graphic Using Text Boxes
SmartArt Graphics
Demo - SmartArt
Lab - Creating a Complex Illustration
Lesson 6 Review

Lesson 7 - Structuring Content Using Quick Parts
Structuring Content Using Quick Parts
Building Blocks
Sidebars
The Modify Building Block Dialog Box
Demo - Viewing Building Blocks
Demo - Create Quick Parts
Lab - Creating a Quick Part
Lab - Inserting a Building Block
Lab - Modifying a Building Block
Demo - Insert Field
Lesson 7 Review

Lesson 8 - Controlling Text Flow
Controlling Text Flow
Section Breaks
Types of Section Breaks
Demo - Section Breaks
Lab - Inserting Section Breaks
Demo - Headers and Footers
Lab - Adding a Header and Footer for a Document Section
Text Columns
Text Columns Options
Demo - Columns
Lab - Inserting Columns
Pull Quotes
Demo - Pull Quotes
Lab - Creating Pull Quotes
Demo - Text Flow
Lab - Linking Text Boxes
Lesson 8 Review

Lesson 9 - Automating Tasks
Automating Tasks
Macros
Demo - Macros
Lab - Performing a Task Automatically Using a Macro
Lab - Recording a Macro
Lab - Modifying a Macro
Demo - Create Macros
Visual Basic for Applications (VBA)
Lesson 9 Review

Lesson 10 - Automating Document Creation
Automating Document Creation
Template Categories
Template Wizards
Demo - Using Templates
Demo - Creating Templates
Lab - Creating a Document Using a Wizard
Lab - Changing the Default Font of a Template
Lab - Changing the Default Template Location
Field Codes
Document Themes
Demo - Themes
Lab - Applying a Customizing Document Themes
Lab - Create a Custom Theme Lesson 10 Review

Lesson 11 - Automating Mail Merges
Automating Mail Merges
Mail Merge
Merge Fields
Data Source
The Mail Merge Process
Demo - Mail Merge
Demo - Mail Merge Labels
Lab - Performing a Mail Merge
Lab - Merging Labels
Lab - Testing the Data Source
Lesson 11 Review
Course Closure

MS Excel 2007 Level One

Lesson 1 - Exploring the Excel Environment
Exploring the Excel Environment
Spreadsheets
Microsoft Office Excel 2007
The Excel Application Window
Worksheets
Workbooks
The Microsoft Office Button
Demo - Explore User Interface
Lab - Explore User Interface
The Ribbon
Demo - Ribbon
Lab - Exploring the Ribbon
The Quick Access Toolbar
Demo - Quick Access Toolbar
The Microsoft Office Window Frame
The Home Tab
The Insert Tab
The Page Layout Tab
The Formulas Tab
The Data Tab
The Review Tab
The View Tab
Dialog Box Launchers
The Excel Help Window
Demo - Help
Lab - Obtaining Help
The Excel Help Toolbar
Customization Options
Lab - Customizing the Quick Access Toolbar
Lesson 1 Review

Lesson 2 - Working with an Excel Worksheet
Working with an Excel Worksheet
Mouse Navigation Options
Demo - Navigation
Lab - Navigation in Excel
The New Workbook Dialog Box
The Mini Toolbar
Demo - Enter Data
Lab - Selecting an Entering Data
File Formats
Demo - Saving
Lab - Saving a Workbook
Lab - Converting an XLS Workbook to an XLSX Workbook
Lab - Saving a Workbook in XLS Format
Lesson 2 Review

Lesson 3 - Modify a Worksheet
Modify a Worksheet
Undo and Redo
Demo - Editing
Auto Fill
Demo - Auto Fill
The Find Command
The Replace Command
Demo - Find and Replace
Lab - Searching for Data in a Worksheet
Cell References
Cell Names
Demo - Insert cells
The Go To Command
Lab - Locating a Cell in a Worksheet
The Spelling Dialog Box
Demo - Spell Check
Lab - Spell Checking a Worksheet
Lesson 3 Review

Lesson 4 - Performing Calculations
Performing Calculations
Excel Formulas
The Formula Bar
Demo - Formula
Lab - Creating Basic Formulas
The Order of Operations
Functions
Formula AutoComplete
Demo - Functions Lab - Calculating with other Basic Functions
Relative References
Demo - Coping Formulas and Functions
Lab - Coping Formulas and Functions
Absolute Reference
Demo - Absolute
Lab - Creating an Absolute Reference
Mixed References
Lab - Creating a Mixed Reference
Lesson 4 Review

Lesson 5 - Formatting a Worksheet
Formatting a Worksheet
Fonts
Demo - Text to Column
Lab - Converting Text to Columns
Demo - Fonts
Lab - Modifying Fonts
The Format Cells Dialog Box
Lab - Adding Borders and Colors to Cells
Lab - Transposing Data While Pasting Content
Demo - Column Widths and Row Height
Lab - Changing Column Width and Row Height
Live Preview
Number Formats
Lab - Applying Number Formats
Lab - Aligning Cell Contents
Demo - Merge and Split Cells
Lab - Merging Cells
Demo - Format Number
Demo - Find and Replace Formats
Lab - Replacing Formats
Autoformats
Lab - Applying an AutoFormat
Cell Styles
Demo - Styles
Lab - Applying Cell Styles
Themes
Lab - Applying Themes
Lesson 5 Review

Lesson 6 - Developing a Workbook
Developing a Workbook
Worksheet Tabs
Demo - Format Worksheet Tabs
Lab - Formatting Worksheet Tabs
Insert and Delete Worksheets
Demo - Insert and Delete Sheets
Lab - Inserting and Deleting Worksheets
Lab - Copying and Pasting Worksheet
Lesson 6 Review

Lesson 7 - Printing Workbook Contents
Printing Workbook Contents
Headers
Demo - Print Titles
Footers
Demo - Headers and Footers
Lab - Creating a Header and Footer Header Dialog Box
Page Margins
Lab - Setting Page Margins
Page Orientation
Demo - Margins Orientation
Lab - Changing Page Orientation
Page Breaks
Demo - Page Breaks
Lab - Setting Page Breaks
Lesson 7 Review

Lesson 8 - Customizing Layout
Customizing Layout
Split Worksheet
Demo - Window Split
Lab - Splitting a Worksheet
Freeze and Unfreeze
Lab - Freezing and Unfreezing Rows and Columns
Demo - Arrange
Lab - Arranging Worksheets in New Windows
Lab - Hiding and Unhiding Worksheet
Lesson 8 Review
Closure

MS Excel 2007 Level Two

Lesson 1 - Enhancing Workbooks
Enhancing Workbooks Personalize Options
Demo - Excel Options
Lab - Customizing the Excel Interface
Color Scheme
Modified Excel Environment in Windows Vistas (Black)
Built-In Theme Options
Create New Theme Colors Options
Create New Theme Fonts Options
Demo - Custom Worksheet
Lab - Customizing an Excel Worksheet
Lab - Enhancing Worksheets using Themes
Comments
Demo - Comments
Lab - Manipulating Comments
Hyperlinks
Demo - Creating Hyperlinks
Lab - Creating a Hyperlink to an Existing File
Lab - Editing and Removing Hyperlinks
Research Task Pane
Demo - Research
Lab - Using Web-Based Research Tools
Lesson 1 Review

Lesson 2 - Creating Workbooks Using Templates
Creating Workbooks Using Templates The Expense Template
Demo - Using Templates
Lab - Creating a Workbook from a Template
Types of Excel Templates
An Example of a Custom Template
Demo - Creating Templates
Lab - Creating a Custom Template
Lesson 2 Review

Lesson 3 - Organizing Data Using Tables
Organizing Data Using Table sAn Excel Table
Demo - Create Table
Lab - Creating a Table Using the Default Table Style
Demo - Table Styles
Lab - Creating a Table Using the Desired Table Style
Lab - Modifying a Table
Lab - Formatting a Table
Lab - Creating a Custom Table Style
Lesson 3 Review

Lesson 4 - Presenting Data Using Charts
Presenting Data Using Charts Create A Chart
Demo - Create A Chart
Lab - Modifying a Table
Modify Charts
Lab - Modify a Chart
Demo - Changing a Chart Type
Format Charts
Lab - Formatting a Chart
Lab - Creating a Chart Template
Share Charts
Demo - Move Chart
Lab - Sharing a Chart
Lesson 4 Review

Lesson 5 - Analyzing Data Using PivotTables and PivotCharts
Analyzing Data Using PivotTables and PivotChartsSource Data for a PivotTable
Summarizing Data with a PivotTable
A PivotTable Report
Demo - Create Pivot
Lab - Performing Calculations Using a PivotTable
A PivotChart
Demo - Pivot Chart
Lab - Creating a Pivot Chart
An Existing PivotTable and Corresponding PivotChart
Demo - Modify Pivot
Lesson 5 Review

Lesson 6 - Enhancing Visual Appeal Using Graphic Objects
Enhancing Visual Appeal Using Graphic Objects
Graphic Objects
Demo - Insert and Modify Picture
Lab - Inserting a Picture in a Worksheet
Lab - Modifying Pictures
Lab - Applying Picture Shape to a Graphic
Lab - Drawing and Modifying Shapes
Lab - Rotating Shapes
Layering
Lab - Layering Graphics
Demo - Smart Art
Lab - Inserting a SmartArt Graphic
Lab - Modifying a SmartArt Graphic
Grouping
Lab - Grouping Objects
Demo - Clipart
Lesson 6 Review

Lesson 7 - Calculating Data with Advanced Formulas
Calculating Data with Advanced Formulas Range Names
Demo - Create Name
Lab - Naming a Range
Lab - Renaming a Range
Lab - Using Named Regions in Formula Calculations
Lab - Adding Columns to a Worksheet Containing Page Names
Three-Dimensional Cell References
Demo - Calculate Data Across
Lab - Comparing a 360-Day vs. 365-Day Date Calculation System
Date and Time Function
Demo - Dates
Financial Function
Demo - Convert Text To Columns
Lab - Using Formulas to convert text data to individual columns
Demo - Statistical Function
Demo - Upper and Lower
Lab - Using the UPPER, LOWER, and PROPER Text Functions
Lookup and Reference Function
Demo - Hlookup
Lab - Looking up Part Numbers with the HLOOKUP Function
Lab - Looking up Part Numbers with the VLOOKUP Function
Logical Function
Demo - If Statement
Lab - Performing Conditional Calculations with SUMIFS, COUNTIFS, and AVGIFS Functions
Lab - Performing Conditional Calculations with SUMIF, COUNTIF, and AVERAGIF Functions
Lab - Calculating Sales Honors with IF Function and the AND Function
Lab - Calculating Sales Honors with IF Function and the OR Function
Lab - Eliminating Calculation Errors with the IFERROR Function
Demo - View and Print Formulas
Lab - Printing a Worksheet with the Formulas Displayed
Lesson 7 Review

Lesson 8 - Sorting and Filtering Data Sorting and Filtering Data Single-Level Sort in Ascending Order
Multiple-Level Sort in Both Ascending and Descending Order
Demo - Sort Data
Lab - Sorting Data
Filter
Lab - Filtering Data
Lab - Calculating Sums, Counts, and Averages on Filtered Data
Database Function
Subtotals
Demo - Subtotals
Lab - Applying Subtotals to a Sorted List
Lesson 8 Review
Course Closure

MS Excel 2007 Level Three

Lesson 1 - Steamlining Workflow
Steamlining Workflow
Macro
Record Macro Procedure Reference
Demo - Macros
Editing Macros
Macro Settings
Demo - Edit Macros
Conditional Formatting
Conditional Formats
Conditional Formatting Procedure Reference
Demo - Conditional Formats
Data Validation
Data Validation Procedure Reference br /> Workbook Properties
Demo - Data Validation
Lesson 1 Review

MS Access 2007 Level One

Lesson 1 - Exploring the Access Environment
Exploring the Access Environment
Database
Database Terminology
Relational Databases
Getting Started With Microsoft Office Access Window
The Microsoft Office Button
The Ribbon
ScreenTips
The Quick Access Toolbar
The Navigation Pane
The Tabbed Document Window Viewing Feature
The Microsoft Office Window Frame
The Home Tab
The Create Tab
The External Data Tab
The Database Tools Tab
Contextual Tabs
Dialog Box Launchers
Galleries
The Access Options Dialog Box
Customize Options
Access Help 2007
Access Help Toolbar Options
Table
Query
Recordset
Form
Report
Demo - Navigation
Demo - Customize Access
Demo - Help
Lesson 1 Review

Lesson 2 - Designing a Database
Designing a Database
The Relational Database Design Process
Statement of Purpose-Example
Statement of Purpose-Non-Example
Existing Data-Paper Format
Existing Data-Electronic Format
How to determine Additional Fields
Field and Table Names
How to Group Fields into Tables
Normalization
Denormalization
Primary Keys-Example
Primary Keys-Non-Example
Composite Keys
Foreign Keys
Table Relationships
One-to-One Relationship
One-to-Many Relationship
Lesson 2 Review

Lesson 3 - Building a Database
Building a Database
Access Database Templates
Table Views
The Field Insertion Feature
Field Templates Task Pane
Data Types
Rich Text Memo Field
Auto Calendar
Multi-valued Fields
File Types
Table Properties
Table Design Options
Referential Integrity
The Relationships Window
The Edit Relationships Dialog Box
Relationship Report
Demo - Create Database
Demo - Create Table
Demo - Manage Table and Relationship
Lesson 3 Review

Lesson 4 - Managing Data in a Table
Managing Data in a Table
The Search and Replace Commands
The Totals Feature
Records Sorting
Subdatasheet
Subdatasheets
Demo - Managing Data
Demo - Sorting
Lesson 4 Review

Lesson 5 - Querying a Database
Querying a Database
Filter Data
Simple Queries - The Query Wizard
The Query Wizard
The Query Design Feature
Query Criteria
Comparison Operators
Conditional Operators
Arithmetic Operators
Expressions
The Expression Builder
The Zoom Dialog Box
The Property Sheet Pane
Demo -filter
Demo - Create Query
Demo - Calculations
Lesson 5 Review

Lesson 6 - Designing Forms
Designing Forms
Form Sections
The Record Navigation Bar
The Form Wizard
Controls
Demo - Use Form
Demo - Create a Form
Demo - Modify Forms
Lesson 6 Review

Lesson 7 - Generating Reports
Generating Reports
Report Sections
The Report Wizard
Summary Options
Control Properties
AutoFormat
Page Setup Options
Print Preview
Proofing Options
Demo - Create Reports
Demo - Modify Reports and Math
Lesson 7 Review
Course Closure

MS Access Level Two

Lesson 1 - Controlling Data Entry
Controlling Data Entry
Field Properties
Input Masks
Input Mask Wizard
Lookup List Fields
Lookup Wizard
Demo - Field Properties
Demo - Input Mask
Demo - Lookup Fields
Lesson 1 Review

Lesson 2 - Joining Tables
Joining Tables
Query Joins
Inner Join
Left Outer Join
Right Outer Join
The Join Properties Dialog Box
Self Joins
The Alias Property
Demo - Inner and Outer join
Demo - Join
Lesson 2 Review

Lesson 3 - Creating Flexible Queries
Creating Flexible Queries
Select Query Properties
Parameter Queries
The Like Operator and Wildcards
Common Wildcards
Other wildcards
Append Query
Action Queries
Update Query
Delete Query
Make Table Query
Demo - Query Properties
Demo - Parameter Queries
Demo - Action Query
Lesson 3 Review

Lesson 4 - Improving Forms
Improving Forms
Design Tools
Layouts
Types of Layouts
Control Padding - Narrow, Medium or Wide
Sort Data Within Forms
Anchor & Form Controls
Control Grouping and Ungrouping
Conditional Formatting
Control Wizards
Combo Box Control
List Box Control
Option Group Control
Command Buttons
Subforms
Demo - Modify Form
Demo - Sorting and Filtering
Demo - Format Form
Demo - Option Buttons
Demo - Subforms
Lesson 4 Review

Lesson 5 - Customizing Reports
Customizing Reports
Report Design
The Group, Sort and Total Pane
The Totals Feature
The Field List Pane
The Rich Text Support Feature
Report Pagination
Summarize Report Information
Subreports
Demo - Create a Report
Demo - Group Sort
Demo - Format Report
Demo - Pagination
Demo - Subreports
Lesson 5 Review

Lesson 6 - Sharing Data Across Applications
Sharing Data Across Applications
Options for Importing Data
Delimiters
Exporting Data
Mail Merge Task Pane
Demo - Import Excel
Demo - Import Export CSV File
Lesson 6 Review
Course Closure

MS Access Level Three

Lesson 1 - Structure Existing Data
Structure Existing Data
First Normal Form
Demo - Table Analyzer
Second Normal Form
Functional Dependency
Third Normal Form
Transitive Dependency
Many-to-Many Relationships
Junction Tables
Demo - Junction Table
Demo - Modify Tables
Lesson 1 Review

Lesson 2 - Writing Advanced Queries
Writing Advanced Queries
Subqueries
Subqueries: Process
Demo - Subquery
SQL
Steps: Create a Subquery in SQL view
Unmatched Queries
Steps: Unmatched Queries
Find Duplicates Queries
Steps: Duplicate Query
Demo - Unmatched and Find Duplicates
Summarize Records using Criteria
Demo - Summarizing Records
Crosstab Query
Demo - Crosstab
PivotTable and PivotChart
PivotChart
Demo - PivotChart
Lesson 2 Review

Lesson 3 - Simplifying Tasks with Macros
Simplifying Tasks with Macros
Macro
Macros
Demo - Macro Form
The Macro Builder Window
Macro Actions
Action Arguments
Demo - Command Buttons and Expressions
Object Events
Macro Conditions
Steps: Restrict Records Using a Condition
Plan a Macro
Embedded Macros
Demo - Mandatory Data Entry and Message Box
Demo - Automate Data Entry
Lesson 3 Review

Lesson 4 - Making Effective Use of Forms
Making Effective Use of Forms
Active X Controls
Form Format Properties
Demo - Calendar Form
Tab Control
Demo - Tab Control
Demo - Pivot
Lesson 4 Review

Lesson 5 - Making Reports More Effective
Making Reports More Effective
Chart
Chart Types
Demo - Chart in Report
Demo - Column Report
Demo - Cancel Printing
Report Snapshot
Demo - Snapshot
Lesson 5 Review

Lesson 6 - Maintaining an Access Database
Maintaining an Access Database
Links to External Data Sources
Linked Table Manager
Demo - Link Tables
Managing a Database
Object Dependencies Task Pane
Demo - Compact and Repair Object Dependencies
Database Documenter
Performance Analyzer
Demo - Performance
Lesson 6 Review
Course Closure

MS PowerPoint 2007 Level One

Lesson 1 - Exploring the PowerPoint Environment
Exploring the PowerPoint Environment
Presentations
PowerPoint Presentations
The Microsoft Office Button
Demo - Exploring the Interface
The Quick Access Toolbar
Demo - The Quick Access Toolbar
The Microsoft Office Window Frame
The Ribbon
The Home Tab
The Insert Tab
The Design Tab
The Animations Tab
The Slide Show Tab
The Review Tab
The View Tab
The Dialog Box Launchers
Contextual Tabs
PowerPoint Help Feature
PowerPoint Help Toolbar Options
Demo - Using Help
The PowerPoint Options Dialog Box
Lesson 1 Review

Lesson 2 - Creating a Presentation
Creating a Presentation
Presentation Guidelines
Saving Presentations
Demo - Saving a Presentation
Templates
Demo - Creating a Presentation Using a Template
Demo - Creating a Presentation from a Word Outline
Compatibility Checker
Slide Layouts
Galleries
Themes
Components of Themes
Demo - Themes
Live Preview
Background Styles
Text Placeholders
Demo - Add Text
The Paste Special Command
Demo - Edit Text
The Slides Tab
Demo - Views
Lesson 2 Review

Lesson 3 - Formatting Text on Slides
Formatting Text on Slides
Character Formats
Demo - Applying Character Formats
Demo - Paragraph Formats
The Mini Toolbar
Format Painter
Replace Font Dialog Box
Text Styles
Demo - Format Text Placeholders
Bulleted List
Numbered List
Indent Markers
Typography Effects
Lesson 3 Review

Lesson 4 - Adding Graphical Objects to a Presentation
Adding Graphical Objects to a Presentation
Clip Art
Demo - Insert Clip Art
Shapes
Demo - Shapes
Drawing Tools
WordArt
Demo - Insert Word Art
Lesson 4 Review

Lesson 5 - Modifying Objects
Modifying Objects
Object Selection
Object Scaling
Demo - Modify Objects
Picture Tools
Image Compression
Orientation
Demo - Orientation of Objects
The Set Transparent Color Option
Grouping and Ungrouping Objects
Order of Objects
Guides and Gridlines
Demo - Layering Objects
Lesson 5 Review

Lesson 6 - Adding Tables to a Presentation
Adding Tables to a Presentation
Tables
Table Creation
Demo - Insert a Table
Demo - Insert a Table from Word
Table Tools
Table Fill Options
Table Styles
Lesson 6 Review

Lesson 7 - Inserting Charts in a Presentation
Inserting Charts in a Presentation
Charts
Demo - Insert a Chart
Chart Data
The Chart Window
Chart Tools
Chart Types
Chart Layouts
Chart Styles
Demo - Modify a Chart
Demo - Paste a Chart from Excel
Leson 7 Review

Lesson 8 - Preparing to Deliver a Presentation
Preparing to Deliver a Presentation
AutoCorrect
The Spell Checker
Demo - Spell Check
Transitions
Demo - Add Transitions
Animation Effects
Demo - Add Animations
Speaker Notes
Handouts
Outlines
The Page Setup Dialog Box
The Package For CD Option
Demo - Preparing for a Presentation
Lesson 8 Review
Course Closure

MS PowerPoint 2007 Level Two

Lesson 1 - Customizing the PowerPoint Environment
Customizing the PowerPoint Environment
Default Color Scheme
Color Scheme Applied
The PowerPoint Options Dialog Box
Demo - Customize the Powerpoint Interface
Lesson 1 Review

Lesson 2 - Customizing a Design Template
Customizing a Design Template
Custom Template
Demo - Adding a Background Graphic to a Slide Master
Slide Master
Demo - Slide Master
The Reuse Slides Pane
Slide Masters
Custom Themes
Demo - Custom Layouts
Custom Bullets
The Bullets And Numbering Dialog Box
Demo - Customize Bullets
Common Slide Information
The Header And Footer Dialog Box
The Notes Master
The Handout Master
Demo - Master Notes and Handouts
Lesson 2 Review

Lesson 3 - Adding Diagrams to a Presentation
Adding Diagrams to a Presentation
SmartArt Graphics
Demo - Add Diagrams
The Choose A SmartArt Graphic Dialog Box
SmartArt Tools
Demo - Modify Diagrams
Lesson 3 Review

Lesson 4 - Adding Special Effects to Presentations
Adding Special Effects to Presentations
The Movie Options Group
Demo - Movies and Sound
The Clip Art Task Pane
Custom Animation Task Pane
The Entrance Custom Animation Effect
The Emphasis Custom Animation Effect
The Motion Paths Custom Animation Effect
The Exit Custom Animation Effect
Ordering
Demo - Applying Effects to Text
Demo - Custom Animation
Lesson 4 Review

Lesson 5 - Customizing a Slide Show Presentation
Customizing a Slide Show Presentation
Custom Slide Shows
Slide Show Options
The Custom Show Dialog Box
Demo - Custom Slide Show
Hyperlinks
Demo - Hyperlinks
The Action Settings Dialog Box
Action Buttons
Demo - Hyperlinks and Action Buttons
Annotation
Demo - Annotate a Slide
Recording Quality
Record Narration
The Rehearse Timings Feature
Information Kiosks
Lesson 5 Review

Lesson 6 - Collaborating on a Presentation
Collaborating on a Presentation
Some Definitions..
The Publish Slides Dialog Box
Information Rights Management
Rights-Protected Presentation
Demo - Limit Editing of Slide Content
Lesson 6 Review

Lesson 7 - Finalizing a Presentation
Finalizing a Presentation
Review Tab: Comments
Review Tab: Research Task Pane
Review Tab: Thesaurus
Password-Protected Presentation
Standard File Properties
Advanced File Properties
Digital Signatures
Get A Digital ID Dialog Box
The Document Inspector Dialog Box
The Mark As Final Feature
The Publish As Web Page Dialog Box
Demo - Finalizing a Presentation
Demo - Publish a Presentation as a Web Page
Lesson 7 Review
Course Closure

MS Outlook 2007 Level One

Lesson 1 - Getting Started with Outlook
Microsoft Office Outlook 2007
The Microsoft Office Outlook 2007 Window
Item
Folder
The To-Do Bar
Demo - Exploring the Interface
Email Address
The New Message Window
Demo - Sending a Message
Demo - Resend and Reply
The Microsoft Office Button
The Quick Access Toolbar
The Ribbon
The AutoPreview Feature
The Infobar
Print Dialog Box
The Auto Empty Feature
Demo - Print and Delete
Lesson 1 Review

Lesson 2 - Composing Messages
Address Book
Global Address List
The Mini Toolbar
Dialog Box Launcher
Gallery
AutoCorrect
Demo - New Message Formatting and Spellcheck
Attachment
Demo - Attachments
Forward
Demo - Forwarding
Lesson 2 Review

Lesson 3 - Organizing Messages
Organizing Messages
Attachment Preview
Message Flagging
Demo - Attachment Flags
Demo - Attachments - Pictures
Demo -Word Attachment Preview
Demo - Folders
Lesson 3 Review

Lesson 4 - Managing Contacts
Managing Contacts
Contact
Demo - Adding a Contact
The Contact Form
Electronic Business Card
The Outlook Address Book
Contact Views
Demo - Contact Views and Sending Contacts
Color Category
Sort Order
The Map Button
Demo - Adding a Contact from a Message Header
Lesson 4 Review

Lesson 5 - Scheduling Appointments
Scheduling Appointments
Outlook Calendar
The Appointment Form
Private Appointment
Demo - Add, Modify, and Categorize Appointments
Demo - Reoccurring Appointments
Lesson 5 Review

Lesson 6 - Scheduling Meetings
Scheduling Meetings
The Meeting Scheduling Process
Meeting Form
Meeting Resources
Group Schedule
Responses
Demo - Inviting Attendees
Lesson 6 Review

Lesson 7 - Managing Simple Tasks
Managing Simple Tasks
Task
The Task Form
Demo - New Tasks
Demo - Updating Tasks
Lesson 7 Review

Lesson 8 - Using Notes
Using Notes
Notes
Demo - Notes
Lesson 8 Review
Course Closure

MS Outlook 2007 Level Two

Lesson 1 - Setting Calendar Options
Setting Calendar Options
Tools - Options
Calendar Options
Demo - Calendar Options
Time Zones
The Free/Busy Options Dialog Box
Lesson 1 Review

Lesson 2 - Setting Message Options
Setting Message Options
Demo - Message Options
Demo - Message Options Read Receipt
Message Settings
Voting and Tracking Options
Delivery Options
Message Formats
Demo - Message Formats
Rules
The Out Of Office Assistant Dialog Box
Demo - The Out Of Office Assistant
Distribution Lists
Demo - Distribution Lists
Hyperlinks
Demo - Hyperlink
Lesson 2 Review

Lesson 3 - Tracking Work Activities Using the Journal
Tracking Work Activities Using the Journal
The Journal
Demo - Journal
The Journal (Cont.)
Journal Views
Journal Entry Form: Manual Entry
Demo - Journal Add
Lesson 3 Review

Lesson 4 - Managing Tasks
Managing Tasks
Assign Task
Demo - Assign Task
Task Request Form
Demo - Accept and Decline Tasks
Status Report
Lesson 4 Review

Lesson 5 - Sharing Folder Information
Sharing Folder Information
Outlook Folders
Additional Default Folders
Permission Roles
Demo - Mailbox Permissions
Overlay Mode
The Send A Calendar Via E-mail Dialog Box
Delegate Access to Folders
Lesson 5 Review

Lesson 6 - Customizing the Outlook Environment
Customizing the Outlook Environment
Toolbar Options
Demo - Custom Toolbar
Customization
Demo - Custom Menus and Quick Access
Outlook Today Page
Folder Home Page
Lesson 6 Review

Lesson 7 - Locating Outlook Items
Locating Outlook Items
Sort Criteria
Demo - Sorting
Instant Search
Demo - Search
The Query Builder Feature
The Advanced Find Window
The Filter Dialog Box
The Ways To Organize Panel
Demo - Organize
Automatic Formatting
Rules Wizard
Rules Wizard - Predefined Templates
Junk Email Filter
Blocked Senders List
Safe Senders List
Lesson 7 Review

Lesson 8 - Working with Public Folders
Working with Public Folders
Public Folders
Demo - Public Folders
Public Folder Permissions
Sending Messages to Public Folder
Lesson 8 Review
Course Closure

MS Outlook 2007 Level Three

Lesson 1 - Personalizing Your Email
Personalizing Your Email
Stationary
Themes
How to Apply Themes and Stationary
Demo - Themes
Create Custom Theme
Demo - Custom Themes
Signatures
How to Create Signatures
Demo - Create Signature
Demo - Business Card Create Signature
Encryption
Digital Signatures
Demo - Digital Signature
Email Message Security Settings
Demo - Encrypt Digital Signature
Lesson 1 Review

Lesson 2 - Organizing Outlook Items
Organizing Outlook Items
Group Items
Group Outlook Items
Demo - Grouping
Search Folders
How to Create Search Folders
Demo - Search Folders
Conditional Formatting
Lesson 2 Review

Lesson 3 - Managing Outlook Data Files
Managing Outlook Data Files
Managing Outlook Data Files
Store Outlook Items
Outlook Data Files
Data File
Data File Settings
Demo - Outlook Data File
Lesson 3 Review

Lesson 4 - Working with Contacts
Working with Contacts
Forwarding Contacts
Demo - Forward Contact
The Edit Business Card Dialog Box
How to Edit Electronic Business Card
Demo - Business Card
Export Contact Information
Export Contacts
Demo - Export Contacts
Fields
Perform Mail Merge
Mail Merge
Demo - Mail Merge
Merge Field Types
Data Sources
The Mail Merge Recipients Dialog Box
The Filter And Sort Dialog Box
Business Contact Manager
Lesson 4 Review

Lesson 5 - Saving and Archiving Email
Saving and Archiving Email
Saving Messages in Alternate Formats
Demo - Save Alternate Formats
Archive Items
How to Archive
Demo - Archive
Protect Personal Folders
Lesson 5 Review

Lesson 6 - Creating a Custom Form
Creating a Custom Form
Adding Form Fields
Saving Form As Template
Testing a Form
Demo - Message Form
Demo - Form Templates
Lesson 6 Review

Lesson 7 - Working Offline and Remotely
Working Offline and Remotely
Offline Folder File
Send/Receive Groups
Create Send and Receive Groups
Create Custom Send/Receive Group
RPC Over HTTP
How to Configure RPC Over HTTP
Demo - Send Receive and Work Offline
Lesson 7 Review
Course Closure