Video Simulations

Microsoft Access 2007	Microsoft Excel 2007	Microsoft Powerpoint 2007
Microsoft Word 2007	Microsoft Publisher 2007	Microsoft Outlook 2007
Adobe Dreamweaver	Soon: Adobe premier	Soon: Final Cut Pro
Soon: iMovie	Soon: MS Movie Maker

NEW! How to resize photos in Picsizer: How to resize a single photo | How to resize mltiple photos at once

How to Set the Default Save Format in Office 2007

Microsoft Access 2007

Tables	- How to Create a Table - What is the “Primary Key” in a Table? - Understanding the basic concepts of Table Relationships - Create a One to Many Relationship Between Two Tables
Queries	- How to Create a Simple Select Query - Understanding "And" and "Or" queries - How to Create a Parameter Query - Create a Calculation in a Query - Action Queries: Understanding and Creating Make Table Queries - Action Queries: Understanding and Creating Delete Queries
Forms	- Create a Form using Form Wizard - Using Calculated Controls in a Form - Applying Conditional Formatting to a Form
Reports	- Create a Report using Report Wizard - Using Calculated Controls in a Report

Microsoft Excel 2007

Microsoft Access 2007  |  Microsoft Excel 2007  |  Microsoft Powerpoint 2007  |  Microsoft Word 2007  |  Microsoft Publisher 2007  |  Adobe Dreamweaver | top

Functions	- Understanding Basic Functions - Using the IF function
Excel Tables	- What is an Excel Table? - How to create an Excel Table - How to Convert an Excel Table Back to a Range
Advanced Filtering	- How to Create an Advanced Filter - How to Us Database Functions in an Advanced Filter
Pivot Tables	- What is a Pivot Table? - How to Create a Pivot Table - How to Analyze Data in a Pivot Table
Solver	- What is Solver? - Using Solver
Conditional Formatting	- How to Apply Conditional Formatting
Data Analysis	- Linear Regression - Exponential Smoothing - Moving Average
Importing Data	- How to insert stock quotes into your spreadsheet

Microsoft PowerPoint

Microsoft Access 2007  |  Microsoft Excel 2007  |  Microsoft Powerpoint 2007  |  Microsoft Word 2007  |  Microsoft Publisher 2007  |  Adobe Dreamweaver | top

Slide Basics	- Understanding Slide Layouts - Understanding Slide Design (slide templates) - Slide Masters – Creating Custom Templates
Basics	- Understanding and formatting text boxes - Inserting Images - Inserting Sound and Video - Hyperlinks and Action Buttons
Animations	- Understanding PowerPoint Animations - Using basic Animations - Using Slide Transitions

Microsoft Word

Microsoft Access 2007  |  Microsoft Excel 2007  |  Microsoft Powerpoint 2007  |  Microsoft Word 2007  |  Microsoft Publisher 2007  |  Adobe Dreamweaver  | top

Fonts and Styles	- Understanding the Basics of Styles - Using Styles to Create a Table of Contents
Page Layout	- Understanding Line Spacing - Inserting Headers and Footers
Indexes	- How to insert an index

Microsoft Outlook

Microsoft Access 2007  |  Microsoft Excel 2007  |  Microsoft Powerpoint 2007  |  Microsoft Word 2007  |  Microsoft Publisher 2007  |  Adobe Dreamweaver  | top

Item recovery

- How to recover deleted items in Microsoft Outlook

Microsoft Publisher

Microsoft Access 2007  |  Microsoft Excel 2007  |  Microsoft Powerpoint 2007  |  Microsoft Word 2007  |  Microsoft Publisher 2007  |  Adobe Dreamweaver  | top

The Basics	- Understanding the Publisher Interface
Organizning Documents	- How to use Layout Tables in your Publisher Documents
The Look of the Document	- Backgrounds and Color Schemes

Adobe Dreamweaver

Microsoft Access 2007  |  Microsoft Excel 2007  |  Microsoft Powerpoint 2007  |  Microsoft Word 2007  |  Microsoft Publisher 2007  |  Adobe Dreamweaver  | top

Starting a Site	- Creating Your Website Folders - Open Dreamweaver and Connect to Your Folders - Understanding the User Interface - Creating your Index.html file (your home page)
Basics	- Understanding and Using Text and Email Hyperlinks - Understanding Anchored Hyperlinks (links to a different location in the same page) - Inserting Images - Understanding Graphics Hyperlinks and Hotspot (Mapped Graphic) Links - Page Properties: Change the look of your page and your hyperlinks
Templates	- What is a Template? - How to create a Template - How to apply a Template to your web pages - Updating your Template
Navigation	- How to Create a Jump Menu

Microsoft Access 2007  |  Microsoft Excel 2007  |  Microsoft Powerpoint 2007  |  Microsoft Word 2007  |  Microsoft Publisher 2007  |  Microsoft Outlook 2007 |  Adobe Dreamweaver

| top