Computer Course Descriptions

Version 2007 Access is the perfect computer tool to help you organize and utilize your company's information in a way that saves you time, and helps you to analyze data and make better decisions. This seminar teaches the basics of planning, creating and modifying a database. Participants will create a new table, and will learn about fields, including data types, properties and learning about queries and the QBE grid. Students will learn about simple reports. Please bring ideas for your own database on the last day of class. The instructor will advise you on the best way to set up your database to fit your needs. We also have Intermediate Access.

Go beyond database basics in this intermediate class. Learn about advanced queries, advanced reports (headers, footers, and detail sections), calculations in queries and reports, and form design. Bring your own ideas or actual database design to class on the last day. If you wish, the instructor will advise you on the best way to set up or modify your database for maximum efficiency.  Prerequisite: basic working knowledge of Intro to Access. (Hint: to see if you qualify for this class, please see the course description for Access.)

From Tables, Queries, Forms, and Reports to macros and data collection by email, this class will cover the updates and changes which are now part of Access. This class assumes familiarity with Access 2003.

Learn how to create PDF documents from within Acrobat as well as other programs, create headers, footers, bookmarks, and links, ensure that PDF documents are accessible, apply password security, digitally sign, validate and encrypt PDF files, initiate a review, and create a comment summary file.

Need to create artwork for print or the Web? Our Adobe Illustrator class will cover: how to create simple and complex shapes; add color and text to illustrations; draw paths; utilize libraries; modify and group items; manipulate layers; and much more.

Desktop publishing at a new level—this class will cover the features and functions of how to create a new document, add text and graphics, use master pages, add columns, thread frames, create and apply styles, use layers, and prepare a file for print.

Learn how to create new InDesign documents, place text and graphics, and format text; work with master pages; flow text between frames; specify tab and indent settings; create bulleted lists; adjust space between paragraphs; create and apply paragraph rules, paragraph styles, and character styles; and work with text and graphics in frames.

Our interactive exercises will help you learn the basics of selecting and modifying images, and creating and manipulating layers and other effects. Also learn how to retouch and resize images, and prepare images for use in print and on the Web.

Dreamweaver CS3 provides a powerful yet friendly environment to develop and/or maintain your website. Designed for the beginning site developer/manager, or one who already has website development experience but wants to explore the possibilities of Dreamweaver, this class provides hands-on training. Topics include: exploring the Dreamweaver environment, creating and editing web pages, enhancing web pages, designing a site, connecting web pages and working with images. HTML code will also be discussed briefly during each chapter. (No previous HTML knowledge required).

Provides hands-on activities using Cascading Style Sheets; tables and frames; and creating forms. Prerequisite: Dreamweaver Basic or strong working knowledge of topics taught in introductory Dreamweaver.

Whether you're already using Excel, or considering it for your work or home, this one-day, hands-on workshop will provide lots of extra tips and tricks for working faster and more efficiently in Excel. Participants will begin by exploring Excel basics, then move on to creating simple formulas, formatting cells, and creating and formatting charts all while using the new features of Excel 2007.

Now that you are comfortable with the basics of Excel, you realize there is so much more you can do to facilitate the creation and maintenance of your spreadsheets. This intermediate class is perfect for Excel users who want to upgrade their skill levels. Topics include: charts & graphs; managing large and/or multiple worksheets; the paste special feature; range names; labels in formulas and other functions; managing data; and customizing Excel preferences. Prerequisite: beginning Excel class, or working knowledge of basic Excel skills.

From the Ribbon to tables, formulas, and filters, learn tips and tricks to make this the most useful "tool" in your toolbox. Includes graphics, conditional formatting, and so much more!

Do you have Office 2003 and anticipate upgrading to 2007? Have you already upgraded? Then this class is for you! Designed for those who may need some assistance understanding the new terminology and help finding the "old familiar" in its new location, this class will cover the differences in the changes of the three major products in the Office line.

Whether you are currently using an earlier version of Outlook for your email, or ready to jump into the latest version, Outlook 2007 is here for you. But wait, Outlook is not just an e-mail program, it is a computer management tool to help you organize and manage your messages, appointments, contacts and tasks. Topics include: Autosignatures; hyperlinks; templates; remote mail; appointment scheduling; viewing web pages and other documents; tasks; and journals. Outlook 2007 integrates and shares information with other MS Office products. Sign up today to learn about this versatile program and how it can help you get organized and stay organized!

Version 2007. Overhead transparencies are becoming a thing of the past. Nowadays, you are expected to have the know-how to create a dynamic computer slide show presentation. This class will give you the foundation you need. Now you can learn how to create professional-looking slides and handouts to use in meetings and other presentations. Topics include: PowerPoint basics; creating and editing text; graphics; and different views modes. PowerPoint includes many features that make presentations a breeze. Sign up today and discover how this fun and useful program can make at least one part of your life easier.

Now that you know the basics of PowerPoint, you want to add an even more professional touch to all your presentations. Now you can! You'll get right into creating and managing charts; customizing presentation schemes and templates; editing notes and handout masters; adding special effects (including sounds, video and animation); and advanced techniques of setting up your slide show. Learn all this and more in this one-day hands on seminar. Prerequisite: beginning PowerPoint class, or working knowledge of basic PowerPoint skills.

Topic coverage includes rearranging and deleting slides, modifying graphics, and adding media clips. Students will also learn how to work with SmartArt graphics, tables, and animations. This course also explores various delivery options, including custom slide shows and file distribution.

Students will learn how to create a new project file, create and modify task lists, create a Work Breakdown Structure, and work with task relationships. They'll also learn how to create a base calendar, assign resources to tasks, create task calendars, and create and modify tables. Students will use filters and groups, and they'll sort task and resource data. Finally, they will learn how to resolve resource conflicts.

Version 2007. Are you tired of making those ho-hum fliers and brochures? Publisher makes it easy to create, customize and publish unique publications for print and online. In this class we’ll cover basic publications skills; text enhancement; drawing objects and Word Art; using and editing graphics; text frames; and tables. We’ll explore the different templates and create eye-catching, professional publications with this fun, user-friendly software.

From setting up a QuickBooks company to paying the bills and printing the reports at the end of the process, our QuickBooks 2008 class is for you. Topics will also include entering customer, employee, and vendor information; writing checks; transferring money; and reconciling your accounts; as well as credit cards; sales forms; payments and deposits; and billing. Prerequisite: working knowledge of computers and Windows environment.

Continue where you left off in the Beginning QuickBooks class. Topics will include inventory, sales tax, payroll, special invoicing, tracking time and mileage, and customizing invoices and forms. Prerequisite: beginning QuickBooks class, or working knowledge of basic QuickBooks skills.

Need to add pizzazz and interest as you present information at your business meetings? With Visio, you can design charts and graphs for technical or business processes; create calendars; and use the many other versatile Visio tools to present your business information in a powerful and professional manner. `

Have you recently purchased a computer running Vista or are you just overwhelmed by the new Windows Vista operating system? Our Vista Fundamentals is designed for you! We’ll explore the Vista Desktop; discuss differences between XP and Vista; work with multimedia files including the Pictures folder and the Photo Gallery; adjust settings using the Control Panel; try out some Gadgets and the Sidebar; and much more. Our goal is to make you more comfortable with this modern, attractive, and intuitive operating system.

Using a word processor is a fundamental means of communication whether you are a student, office worker, or grandparent (or anyone else!). This beginning level class is for those with little or no word processing experience and/or those who would just like to learn Word. Join us in exploring topics such as: basic document skills; character, paragraph and document formatting; different document views; numbers and bullets; headers and footers; and printing. Packed with tips and tricks for getting the most out of your word processor, this class is for you!

If you're a Word level 1 user, you're probably itching for more information! We'll cover Tables, Borders and Shading, Drawing Objects, Graphics, and Columns. We find the power of AutoCorrect, AutoText, and Templates, and learn file management within Word.

Version 2007. Online forms are becoming more useful in this Internet Age. The ability to create these forms has become easier with the use of MS Word. We'll create forms including text forms, check boxes, drop-down lists and templates, and then learn to protect the form and/or the document. Prerequisite: beginning Word class, or working knowledge of basic Word  skills.

Version 2007. Need to send letters or documents to the masses? Need to send the same letter to different people at different times and don’t want to have to “recreate the wheel?” Mail merge is the tool! Create your main document once, then either import or create a list of recipients—merge them together and, like magic, you have a mass mailing! Works great for labels, envelopes, and fax documents, too! You can even create a directory or catalog using mail merge. Join us for this useful class designed for the Word user who already knows the basics but is looking for that extra edge!