Access 2003 / 2007 Advanced

Automating Database Applications � Designing Forms that Display Custom Menus, Setting Field Properties; Designing Macros; Creating Auto Execute Macros; Applying Security to a Database

5/18/2009
3/30/2009
4/27/2009

Access 2003 / 2007 Beginning

Getting Started with Database Basics � Designing a Database; Apply Properties; Using the Table Wizard; Modify the Design of a Table; Working with the Datasheet; Creating a Form; Using a Query; Building a Report

5/6/2009
3/10/2009
4/30/2009

Access 2003 / 2007 Intermediate Part 1

Creating Forms and Queries � Relationships; Using and Building Queries; Calculated Criteria; Action Queries; Other Special Queries; Creating and Designing Forms; Subforms

5/11/2009
3/16/2009
4/30/2009

Access 2003 / 2007 Intermediate Part 2

Creating Reports � Using Data Stored in other Formats; Creating and Designing Reports; Setting Properties; Using Functions in a Report; Adding Graphics; Creating Charts

5/12/2009
3/24/2009
4/20/2009

Adobe Acrobat 7.0

Properties of a PDF File; Creating a PDF with the PDFWriter; Creating a PDF with the Distiller; Navigating a PDF Document; Security; Using Information from a PDF File; Setting Preferences

5/9/2009
3/13/2009
4/30/2009

Adobe PhotoShop 7.0

Digital Photograph Formats; Resize and Crop Images; Retouch Photographs; Modify the Brightness, Contrast, Color Balance, Hue and Saturation of Images; Save Images in File Formats for Use with Other Applications on the Web

5/18/2009
3/16/2009
4/10/2009

AutoCAD 2006 Essentials

This class is designed for the new AutoCAD user who requires comprehensive training in AutoCAD. It incorporates the features, commands and techniques for creating, editing and printing drawings with AutoCAD. Hands-on exercises throughout explore how to create 2D production drawings. The exercises are provided in bith printed and online format that can be viewed next to AutoCAD. This is a 3 day course. For a full course description, call 800-262-1771

3/3/2009
4/20/2009
4/27/2009

No Outline on file

Crystal Reports 8.5 Advanced

Reviewing Crystal Reports Basics; Custom Sort Order; Creating Parameter Selection; Inserting Parameters Fields; Running Totals and Other Calculations; Creating Subreports; Linking and Unlinking Subreports; Charting and Maps; Crystal Query Designer; Crystal Dictionaries

4/27/2009
5/25/2009
3/26/2009

Crystal Reports 8.5 Introduction

Starting Crystal Reports; Creating a New Report; Report Types; Listing; Zooming; Saving the Report; Standard Reports; Cross Tab Reports; Mail Label Reports; Graph Reports; Top N; Drill Down Report; Preview and Design Tabs; Report Bands; Insert Fields; Insert Groups; Insert Graphic Object; Formatting

4/14/2009
5/15/2009
3/10/2009

Excel 2003 / 2007 Advanced Part 1

Analyzing Data with Advanced Tools � Working with Complex IF Statements; Distribution and the Histogram Tool; Regression and Analysis Tools; Using Statistical and Probability Functions; Financial Functions; Date Functions; Text Functions

3/16/2009
4/17/2009
5/19/2009

Excel 2003 / 2007 Advanced Part 2

Power User/Visual Basic � An Introduction to Macros and Visual Basic; Using Dialog Boxes; Recording Macros; Functions; Using Visual Basic; Building an Application

3/17/2009
4/20/2009
5/20/2009

Excel 2003 / 2007 Beginning

Getting Started with Excel Worksheet Basics � Navigating in a spreadsheet; Inserting & Deleting cells; Entering & Editing Data; Moving, Copying and Deleting Cell Content; Entering Basic Formulas; Using Basic Functions; Using the Chart Wizard

4/13/2009
3/10/2009
5/11/2009

Excel 2003 / 2007 Intermediate Part 1

Data and Worksheet Management -Working with Sheets; Creating and Using a Database; Pivot Tables; Database Functions; Cell Protection; Creating a Basic Macro; Customizing

4/13/2009
3/13/2009
5/14/2009

Excel 2003 / 2007 Intermediate Part 2

Quick Reporting Tools and Charting � Goal Seek and Solver; Scenario Manager and Views; Auditing Tools; Creating Charts; Changing Chart Types; Formatting Charts; Drawing Tools and Objects

5/5/2009
3/3/2009
4/9/2009

FrontPage 2003 / 2007 Advanced

Managing Your Site and Adding Advanced Features � Reviewing and How to Approach your Web Design; Maintaining your Site using Special Features in FrontPage Explorer; Web Site Promotion; Getting Listed with Directories and Search Engines; Adding Active Content with ActiveX and Java; Using Databases in the Web; Creating your own themes

3/11/2009
5/8/2009
4/9/2009

FrontPage 2003 / 2007 Beginning

Getting Started with Web Site Basics � Designing a Web Page; Using the Wizard; Adding Pages to the Site; Moving, Copying and Deleting Information; Formatting; Hyperlinks; Backgrounds and Themes; Tasks

5/6/2009
3/9/2009
4/7/2009

FrontPage 2003 / 2007 Intermediate

Adding Special Features to Your Site � Using Office Documents; Publishing to a Web Site; Working with an Image; Adding Video and Sound; Working with Tables; Stylesheets; Creating Forms; Special Effects

3/10/2009
4/8/2009
5/7/2009

InfoPath 2003 / 2007

InfoPath versus Paper Forms, Text Documents, Web Forms or Custom Solutions; Building a Form; Data Sources; Formatting a Form; Editing a Form; Color Schemes; Form Design Controls; Publish Forms (AM Session)

4/7/2009
5/5/2009
3/23/2009

Inventor Essentials

This course is designed for the new user who requires comprehensive training in Inventor. This hands-on foundation course covers the basic Autodesk Inventor features used to create, edit, document and print parts or assemblies. Students learn about basic features by referencing print documentation and using real-world exercises. This course is designed for students to learn the basics of mechanical 3D computer-aided design using Autodesk Inventor. Students will learn how to navigate the gesture-based user interface and receive overviews of the basic sketching, part-modeling and assembly modeling techniques. The course also includes a general review of the tools used for creating mechanical drawings. This is a 4 day course. For a full course description, call 800-262-1771

3/27/2009
5/22/2009
4/7/2009

No Outline on file

Lotus Notes 6.0 Calendar and Scheduling

Working with the Calendar; Scheduling Appointments; Setting Alarms; Customizing the Calendar Profile; Setting up Meeting Notices and Track Responses (PM Session)

3/16/2009
4/13/2009
5/11/2009

No Outline on file

Lotus Notes 6.0 Mail

Creating and Sending Memos & Phone messages; Formatting, Reading and Replying to Mail Messages; Deleting & Categorizing Mail; Creating Distribution Lists (AM Session)

3/16/2009
4/13/2009
5/11/2009

Microsoft Office 2007 Transition

Office 2007 Environment; Smart Tags; Using the New Features of Word including Reading Layout, Translating Words, Apply Formatting with Task Pane and Locking Styles; Using the New Features of Excel including Borders by Drawing, Evaluating a Formula, Managing Links and Republishing to the Web; Using the New Features of PowerPoint including Creating a Diagram, Adding a Motion Path, Creating Multiple Masters, Compare and Merge Presentations and Package a Presentation; Using the New Features of Access including Improving Efficiency in a Database, Saving an Object as a Data Access Page, Applying a Theme and Backing up a Database; Introduction to InfoPath including Navigating in InfoPath, Using Forms, and Sharing and Managing Information

4/24/2009
3/24/2009
5/22/2009

No Outline on file

Microsoft Publisher 2003 / 2007

Publication Basics; Creating a Publication; Navigating in Publisher; Using Frames and Objects; Working with the Background; Using Text; Inserting Pictures and Objects; Enhancing the Publication; Printing the Publication

5/25/2009
4/27/2009
3/30/2009

OneNote 2003 / 2007

Organize Notes; Capture Notes in Various Formats; Reuse Notes; Prioritize Action Items; Sharing Notes (PM Session)

3/18/2009
5/11/2009
4/3/2009

PhotoDraw 2.0

Getting Started with the Basics – PhotoDraw Basics; Creating, Inserting and Modifying Objects; Adding Text; Scanning a Photo; Working with Digital Photos; Clipart; Pictures for the Web

3/23/2009
5/6/2009
4/7/2009

PowerPoint 2003 / 2007 Advanced

Advanced Presentation Concepts � Creating a Presentation; Creating Custom Templates; Using Word Documents and Excel Spreadsheets in PowerPoint; Master Slides; Advanced Presentation Techniques

3/19/2009
5/15/2009
4/16/2009

PowerPoint 2003 / 2007 Beginning

Getting Started with Presentation Basics � Creating a Slide Presentation; Orientation to Views; Drawing Tools; Bulleted Slide; Organization Chart Slide; Graph Slides; Inserting Clip Art; Running the Slide Show

4/8/2009
3/20/2009
5/5/2009

Project 2003 / 2007 Advanced

: Beyond the Project Implementation Phase � Review of Introduction Topics; Exchanging Project Plan Data with Other Applications; Save Project Plan Information as a Web Page; Enter Task Progress Information; Filter Tasks in a Project Plan; Create a Custom Table; Hyperlink Documents to Tasks; Create and Modify a Custom Report; Create a Project Plan Template; Share Resources; Create a Master Project Plan

3/25/2009
5/20/2009
4/22/2009

Project 2003 / 2007 Beginning

Getting Started with Project Management � Navigating in Project; Creating a Project; Working with the Outline; Linking Tasks; Editing the Project; Assigning Resources; Gantt Chart Wizard; Page Setup and Printing

4/9/2009
3/17/2009
5/19/2009

No Outline on file

Using Visual Basic

(2 day Course) – What is Visual Basic for Applications; the Visual Basic Editor; Opening, Saving and Closing a Program; Statements, Declarations, Procedures, Functions, Modules and Variables; Conditional Statements, Loop Statements, and With Statements; Forms; Debugging and Error Handling; Arrays and Collections; Programming in Word, PowerPoint, Excel and Access.

4/9/2009
3/18/2009
5/20/2009

No Outline on file

Visio 2003 / 2007 Advanced

Using Data and Advanced Diagramming Techniques � Reviewing the Basics; Size and Scale of Page; Size and Scale of Objects; Custom Shapes; Custom Properties; Creating Reports; Visio Diagrams in Microsoft Office; Data Driven Charts and Reports; Adjusting Layers; Using Smart Shapes; Creating Templates; Visio and the Web

4/20/2009
3/11/2009
5/14/2009

Visio 2003 / 2007 Beginning

Creating Professional Diagrams � Becoming familiar with Visio; Create a drawing; Creating Objects and Text; Creating an Organization Chart; Create a Network Diagram; Templates; Working with Stencils

4/17/2009
3/10/2009
5/13/2009

Windows XP Beginning: Basic Concepts

Understanding the Concept of Windows XP Operating System; Creating Program and Document Shortcuts; Working with the new Right Mouse Pop-up Menus; Launching, Moving and Copying Information from One Window to Another; Maintaining Files; Using My Computer & Network Neighborhood; Using Windows

5/7/2009
3/30/2009
4/6/2009

Word 2003 / 2007 Advanced

Desktop Publishing including Graphics � Tables; Setting up Newspaper Columns; Footnotes; WordArt; Drawing Tools; ClipArt; Charts

3/26/2009
5/27/2009
4/22/2009

Word 2003 / 2007 Beginning

Getting Started with Document Basics � Creating & Saving Documents, Navigation in a Word Document, Help, Applying & Removing Character & Paragraph Formatting, Using Tabs and Modifying a Table Structure, Headers & Footers, Inserting Page Breaks, Using the Proofing Tools, Creating Envelopes & Labels

5/11/2009
4/13/2009
3/10/2009

Word 2003 / 2007 Intermediate Part 1

Tables and Mail Merge � Review of Beginning Material; Creating and Editing a Table; Creating and Editing a Mail Merge; Customizing Bullets and Number Lists; Multilevel List; Special Symbols; Paragraph and Page Borders; Watermarks; Customizing

3/11/2009
4/14/2009
5/12/2009

Word 2003 / 2007 Intermediate Part 2

Creating and Editing Large Documents � Create, Modify and Format Tables; Use Table AutoFormat; Sorting; Perform Calculations; Merge a Document with Data; Create Numbered & Bullet List; Add Borders & Shading; Create Watermarks

3/12/2009
4/15/2009
5/13/2009