| Course Name |
Course Details |
| Access I |
What is Access?
Designing A Database
Importing A Spreadsheet or Other Table
Building A Table
Building A Query
Joining Tables in A Query |
| Access II |
More Queries
Forms
Subforms
Reports
Subreports
Calculations Made Easy in Reports/Forms |
| Access III |
Macros
Making Your Access Database A Computer Program
Action Queries
Creating Drop-Down List Boxes |
| Access IV |
Linking Tables
Advanced Reports (Group and Total)
Advanced Queries
If Functions in Queries, Reports and Forms |
| Excel I |
Starting Excel
Saving Time By Performing Routine Calculations
Changing Text and Number Appearance
Printing
Using Graphics |
| Excel II |
Charts Made Easy
More Functions
Linking
Calculation A Car/House Payment |
| Excel III |
Sorting
Finding Specific Data Quickly
Getting Subtotals Quickly
More Functions |
| Excel IV |
Scenarios
Pivot Tables
Hyperlinks
Visual Basic Within Excel |
| Microsoft Office Hot Tips |
Excel
Quickly Entering Routine Date (such as dates or repeating data)
Resizing All Columns or Rows with One Click
Saving Time by Entering Repeated Lists (such as employees, days, etc.)
Quick Ways to Insert Rows or Columns
Word
Quick Ways to Format Paragraphs
Quick Ways to Select (Highlight) Text
Format Painter
Changing Text to All Caps or Lower Case
Autocorrect
Autotext |
| Stress Management (Stop Stressing and Start Enjoying Life) |
Different Types of Stress and How to Avoid Them
When We Can Handle Stress Alone
When We Need Help
How We Are Affected by Stress
Addressing Specific Examples of Stress |
| Word I |
Starting Word
Using Help
Creating a Simple Document (Letter, Resume, etc.)
Editing a Document
Moving Around a Document Quickly
Enhancing Text Appearance
Setting Tabs
Copying and Moving Text
Find and Replace
Spell Check, Thesaurus and Grammar Check |
| Word II |
Page Breaks, Headers and Footers
Using Columns
Tables
Copying Data to Another Program Document (Excel, PowerPoint, etc.)
Mail Merging (Creating Form Letters, Labels, etc.)
WordArt and Clipart
Format Painter |
| Word III |
Macros
Forms
Templates
Styles
Table of Contents
Bookmarks |
| Word IV |
Drawing
Charts
Spreadsheets Withing Word
Creating a Web Page With Word |
