ACCESS

Access I
Prerequisites: Windows95/98/2000

Course Content: Overview of basic concepts of relational databases and their components, including field types and planning a new database; introduction to the Access interface; working with databases and tables by creating new databases, using the Table Wizard and editing field properties; adding and deleting records, moving between fields and records, copying and backing up tables; creating forms in Design View, with AutoForm and by using the Form Wizard; working with data using the Find, Filter and Sort features; using and saving Select Queries, sorting a dynaset and using comparison operators in queries; creating reports with the Report Wizard, customizing reports with controls and inserting graphics; finding help in Access.
Duration: Full Day Class

Access II
Prerequisites: Access I - a must!

Course Content: Introduction to the Database Wizard, switchboards, table relationships and the Performance Analyzer; using Primary Keys, indexes, input masks, default and required fields, and the Lookup Function; working with forms by creating navigation controls, command buttons, combo boxes, subforms, tab controls, multi-page forms and form headers and footers; creating Parameter and Multiple Parameter Queries, using functions and calculated field in queries and creating relational queries; working with the Action Queries: Make Table, Update, Append and Delete; creating and customizing reports using grouping, AutoFormat, calculated controls, totals, mailing labels and subreports; creating and storing hyperlinks in tables and on forms, linking to Word documents and using Access to create HTML documents.
Duration: Full Day Class

Access III
Prerequisites: Access I & II - a must!

Course Content:
Duration: Full Day Class

Top of page

EXCEL

Excel I (Basic Worksheets)
Prerequisites: Windows 95/98/2000

Course Content: Getting started, introduction to worksheets, creating a basic worksheet, working with ranges, movement techniques, using functions, moving and copying data, modifying worksheets, additional Excel features, formatting techniques, printing a worksheet, previewing, charting and appendix.
Duration: Full Day Class

Excel II (Charting and Organizing)
Prerequisites: Excel I (Basic Worksheets)

Course Content: Creating charts, modifying a chart sheet, modifying an embedded chart, formatting a chart, auto formats, using graphic objects, advanced charting topics, sorting data, auto filter, advanced filter, data form and appendices.
Duration: Full Day Class

Excel III (Advanced)
Prerequisites: Excel I (Basic Worksheets)

Course Content: Customizing the work area, advanced formula construction, troubleshooting, multiple file linking, outlining and consolidating information, protect and display options, pivot tables and appendices.
Duration: Full Day Class

Top of page

GRAPHICS

Photoshop 7.0 Introduction
Prerequisites: Windows 95/98/2000

Course Content: In this course, you will use Adobe Photoshop to modify scanned photographs. You will use advanced tools for selecting parts of images, and will move, duplicate, and resize images. Additionally, you will use painting tools to modify images, and will perform adjustments to contrast and color balance.
Duration: Full Day Class (High End Priced Class)

Course Content: Understanding Microsoft Publisher, creating a publication, importing graphics and text, layout techniques, working with multiple pages, creating tables, formatting text, using Word Art, adding a Page Wizard object, customizing, using ready-made elements, advanced design techniques.
Duration: Full Day Class

MISCELLANEOUS

Introduction to Computers
Prerequisites:

Course Content:
Duration: Full Day Class

Outlook
Prerequisites: Windows 95/98/2000

Course Content: Overview of Outlook, introduction to mail (creating and sending messages), working with appointments and events, working with contacts, managing tasks.
Duration: Full Day Class

Top of page

POWERPOINT

PowerPoint Introduction
Prerequisites: Windows 95/98/2000

Course Content: Introduction to PowerPoint, beginning a presentation, working with drawing tools, templates and slide masters, graphing, enhancing your presentation, output and presentation options, adding notes, adding transitions and builds, running a slide show.
Duration: Full Day Class

PowerPoint Advanced
Prerequisites: PowerPoint Introduction

Course Content: Presentation guidelines, creating a template, modifying a Word document, working with Word tables, linking and embedding, Microsoft Graph, creating a flow chart, additional PowerPoint features, using branching, play lists, and the PowerPoint Viewer.
Duration: Full Day Class

Top of page

WEB SITE DEVELOPMENT

Dreamweaver Introduction
Prerequisites: Windows 95/98/2000, basic understanding of Internet and browsers

Course Content:
Duration: Full Day Class (High End Priced Class)

FrontPage Introduction
Prerequisites: Windows 95/98/2000, basic understanding of Internet and browsers

Course Content: Learn how to: create and edit web pages; create internal and external links and navigation bars; apply formatting and themes; insert pictures and use pictures as hyperlinks; create, modify and enhance tables; begin to manage your web pages;  import and publish webs.
Duration: Full Day Class (High End Priced Class)

FrontPage Advanced
Prerequisites: FrontPage Introduction

Course Content: Topics include: designing and building a web site; page design and working with frames; creating forms and collecting the data; adding media and functionality; reports and collaboration; animation and style sheets.
Duration: Full Day Class (High End Priced Class)

HTML Design: Introduction
Prerequisites: Windows 95/98/2000, basic understanding of Internet and browsers

Course Content: Overview of HTML, formatting text with HTML, adding local and remote links, adding graphics and sounds, creating lists, creating tables, setting body and background attributes, Web Page design guidelines, adding links to other Internet services, HTML and Web references.
Duration: Full Day Class (High End Priced Class)

HTML Design: Advanced
Prerequisites: HTML Design: Introduction

Course Content:
Duration: Full Day Class (High End Priced Class)

^{New course content!} JavaScript: Enhancing Web Pages
Prerequisites: Some knowledge of HTML and basic programming techniques

Course Content: This course is an introduction to the JavaScript scripting language. Students are introduced to the concepts of the language by adding JavaScript enhancements to a fictitious, multi-page web site: The Stratford County Zoo. Topics covered include: JavaScript: The What, Where and How; JavaScript Basics; Object References and Control Structures; Interactive Images; Dynamic Styles and Positioning; Windows and Frames; and Form Data Verification.
Duration: Full Day Class (High End Priced Class)

Top of page

WINDOWS OPERATING SYSTEMS/NETWORKING

Windows 98: Introduction
Prerequisites:

Course Content:
Duration: Full Day Class

Windows 2000: Introduction
Prerequisites:

Course Content:
Duration: Full Day Class

Windows XP: Introduction
Prerequisites:

Course Content:
Duration: Full Day Class

Top of page

WORD

Word I
Prerequisites: Windows 95/98/2000 or equivalent knowledge; knowledge of word processing helpful but not required

Course Content: Word for Windows basics, navigating in Word, editing text, character formatting, paragraph formatting, controlling page appearance, using proofing tools.
Duration: Full Day Class

Word II
Prerequisites: Word I

Course Content: Advanced formatting and editing techniques, glossary entries, tables, newspaper columns, form letters, templates, macros and mail merge.
Duration: Full Day Class

Word III
Prerequisites: Word I and II

Course Content: Advanced styles, creating templates, creating forms, using graphic effects, creating a report, document layout, sharing documents, creating a custom workplace.
Duration: Full Day Class

Top of page