|
Which class should I take? Answers to FAQ's. |
Office 2003 Class Descriptions
Access Excel
FrontPage Outlook
PowerPoint
Publisher Word
Other Course Descriptions:
Windows XP,
Office 2007,
QuickBooks 2002 |
|
ACCESS
|
Access 2003 Level 1
Full Day Class |
Understanding Access and Databases, File
Formats, The Access Window and
Task Panes, Database
Design and Normalization, Using Database Wizards, Working With Records in
Tables, Creating and Editing Tables, Relationships and
Referential Integrity, Subdatasheets, Working With Records in Forms, Creating
and Editing Forms, Filtering and Finding Data, Creating and Editing Queries, Creating and
Editing Reports, Using Help |
Access 2003 Level 2
Full Day Class |
Modifying Fields in Design View , Field Properties and Data
Types, Importing and Exporting Data, Using the Lookup Wizard, Using the Input
Mask Wizard, Multi-Table Queries, Using the Expression Builder, Calculated
Fields, Modifying Forms in Design View, Working with the Toolbox, Bound,
Unbound, and Option Group Controls, Working with Reports in Design View, Data
Access Pages, Hyperlinks, The Documenter, Managing Databases |
Access 2003 Level 3
Full Day Class |
Database Design and The Table Analyzer
Wizard, Linking Tables, Create and Modify Lookup Fields and Input Masks, Validations, Setting Multiple Primary Keys, More About Relationships, Cascade Options, Join
Types and Properties, Query Joins, Multiple Criteria, Filtering Queries, Parameter
Queries, Action Queries, Update Queries, Creating Forms in Design View, Modifying Forms and
Controls, Subform Controls, Creating Switchboards, Start Up Options, Creating Reports
in Design View, Modifying Reports and Controls, SubReports, Data Access
Pages, Database Security
and Passwords, Database Replication, MDE Files, Macros and Modules |
|
EXCEL |
Excel
2003
Level 1
Full Day Class |
The Excel Window and Workbooks, Smart Tags and the Task Pane, Entering and
Editing Data, Data Types, Working with Columns and Rows, Working with Formulas and Functions, Paste Function Wizard,
Move or Copy Data, Fill Series, Relative, Absolute, and Mixed Cell Addresses,
More Functions, Formatting a Worksheet, Creating and Editing Charts, Printing a
Worksheet, Using Help |
Excel 2003 Level 2
Full Day Class |
Renaming, Moving, Coping, Inserting, and
Deleting Worksheets, Change Tab Color, Named Ranges, Working with Databases,
Find and Replace, Freeze Panes, Hiding Columns or Rows, Sorting Data, Filtering,
More About Functions (IF, OR, FV, PMT, NOW) AutoFormat and Styles, Page Breaks,
Working with Objects, Comments, 3-D Formulas and Linking Worksheets, Saving as a
Web Page, Hyperlinks, Creating Templates |
Excel 2003 Level 3
Full Day Class |
Creating Templates, Named Ranges and Lookup Functions, Data Forms,
Custom and Conditional Formatting, Data Validation, Importing and
Exporting Data, Understanding XML, Web Queries, Publishing to the Web, PivotTables and PivotCharts, Auditing
and Error Checking, Outlining, Subtotals, Custom Filtering, Creating Workspaces,
Sharing Workbooks, Tracking Changes, Protecting Worksheets and Workbooks,
Recording and Running Macros, Customizing Toolbars |
|
FRONTPAGE |
FrontPage 2003
Level 1
Full Day Class |
Understanding FrontPage and the Web, The
FrontPage Window, The Task Pane, Using Templates and Wizards, Understanding Views, Folder and
Navigation View, Text and Lists, Tables, Hyperlinks, Bookmarks, Hyperlink View, Working
with Graphics and Images, Thumbnails, Image Maps and Hotspots, Breaks and Lines, Marquees,
Shared Borders, Themes, Managing a Web, Tasks, Publishing a Web |
FrontPage 2003
Level 2
Full Day Class |
Import Web Wizard, Navigation View, Working with
HTML Tags, XML, Shared Borders and Link Bars,
Positioning Graphics, Backgrounds, DHTML, Custom Themes, Designing Frames,
Banner Ads, Working with Tables, Creating a Search Form, Creating an Input Form,
Connecting a Form to a Database, Returning Data from a database, Setting Form Save Options,
ASP, Publishing Webs |
|
OUTLOOK |
Outlook 2003 Level 1
Full Day Class |
The Outlook Window and Outlook Bar, Sending,
Receiving, and Managing E-mail, E-mail Attachments, Junk Mail, Printing E-mail,
Working with Contacts, Working with Calendar and Scheduling Appointments,
Printing Calendars, Using and Managing Tasks, Using Notes |
Outlook 2003 Level 2
Full Day Class |
Working with Mail Temples, Creating
Signatures, Using the Address Book, Using Stationary, Flagging Messages, Finding
Messages, Working with Categories, Exploring Fields, Archiving, Moving Items
Between Folders, Scheduling Events, Planning Meetings, Using the Journal,
Linking Folder Items, Assigning Tasks, Integrating Outlook and MS Office |
|
POWERPOINT |
PowerPoint 2003
Level 1
Full Day Class |
The PowerPoint Window, The Task Pane, Looking At
Presentation Options, Using the AutoContent Wizard, Navigating Through a
Presentation, Slide Types, Bulleted and Numbered Lists, Working with Tables,
Smart Tags, Outline, and Notes Panes, Working With Slide Masters, Placeholders,
Clip Art, Working With Drawing Tools and Arranging Shapes, Spell Check,
Find and Replace, Creating Transitions, Viewing the Slide Show, Using Slide Show
View Options, Printing Options |
PowerPoint 2003
Level 2
Full Day Class |
Customizing Options, Importing Data, Using Slide
Finder, Format Painter, Using
and Customizing Multiple Masters, Working with Word Art and AutoShapes, More
About Clip Art and Modifying Graphics,
Applying Animation, Hiding Slides, Creating Speaker Notes and Audience Handouts,
Web, Hyperlink |
PowerPoint 2003
Level 3
Full Day Class |
Created Custom Toolbars, Color Schemes, Tabs and Indents, Importing and
Exporting data to Word and Excel, Using Video and Sound, Animated GIF's,
Organization Charts, Excel Charts, Tables, Modifying Clip Art Graphics and
AutoShapes, Set Animation Timings, Hyperlinks and Action Buttons, Embedded
Fonts, Custom Shows, Meeting Notes, Action Items, Slide Show Timings, Pack and
Go, PowerPoint Collaboration and Net Meeting |
|
PUBLISHER |
Publisher
2003
Level 1
Full Day Class |
The Publisher Window, Starting and Saving New
Publications, Working With Text Frames, Working With Shapes and Pictures, Laying
Out a Flier, Page Layout, Vertical Headlines, Adding Filled Text Frames,
Importing Text Files, Frame Margins, Tab Stops, Working With Graphics, Working
With Tables, Word Art, Spelling, Design Gallery, Border Art, Printing
Publications, Pack and Go |
|
WORD |
Word 2003 Level 1
Full Day Class |
The Word Window, Task Panes, Navigating
Documents, Saving and Opening Files, Selecting Text, Move or Copy Using the
Clipboard, Smart Tags, Create Documents Using Templates, Fonts, Styles, Borders
and Shading, Bullets and Numbering, Headers and Footers, Find and Replace,
Spelling, Grammar, Thesaurus, Folders and Files, Print Preview and Printing |
Word
2003 Level 2
Full Day Class |
Non-printing Characters and Text
Boundaries, Format Paragraph settings, Styles, Columns and Sections, Symbols,
Modifying Graphics, Working with the Drawing Toolbar, Working with Tables,
Creating Charts, Printing Envelopes and Labels, Save as Web Pages, Revisions,
Comments, Compare and Merge Documents |
Word 2003 Level 3
Full Day Class |
Section Breaks and Multiple Footers, Working with
Styles and Formatting, Footnotes and Endnotes, Fields and Cross-references,
Bookmarks, Creating An Index, The Document Map, Creating A Table Of
Contents, Pagination Options, Sort Tables, Text and Graphics, Master Documents
and Subdocuments, Versions, Track Changes, Digital Signatures, Hyperlinks,
Calculating in Word Tables, Linking to Excel, Inserting Charts, Working with
Forms, Working with Macros, Customizing Toolbars and Options, Mail Merge |
|
