Intro to MS Access
instructors: James & Laura La Borde

Learn how to use and manage a database. Together we will explore the Access interface and create a database from scratch with tables, forms, reports, and simple queries.

prerequisite: a basic understanding of Windows and file management.

Access Intermediate
instructors: James & Laura LA Borde

Access Intermediate will cover the following topics:

1) Joins / Relationships, includes what they are, the different types and how to create them. You will find out where to view them for the whole database as well as referential integrity
  
2) Multi-Table Queries, includes how to add multiple tables, join them and what happens if you don't join them.
 
3) Action Queries including delete, make table, append and update.
  
4) Intermediate Table Use: including multiple primary keys and modifying an existing table.
 
5) Intermediate Forms: includes display controls, grouped controls, D-Lookup, IIF function and sub-forms.
  
6) Reports: includes multi-table reports, graphics in reports, report templates and sub-reports.

prerequisite: Access 101 or a basic understanding of the Access objects (tables, queries, forms)

Adobe InDesign, Part 1
Instructor: Ed Wiser

this is the first 6 weeks of a 12 week introduction course to Adobe InDesign.
It will fully cover InDesign.
Week one: basic tools.
Week two :Page setup and lay out.
Week three: Illustration and drawing
Week four: Objects
Week five Typography
Week Six Text processing.
The course is designed to give you an in depth understand of how to use InDesign which is fast becoming the industry standard for page layout applications.

Adobe InDesign, Part 2
Instructor: Ed Wiser

This is the second 6 weeks of a 12 week introduction course to Adobe InDesign.
It will fully cover Indesign.

Week 1 Color in InDesign
Week 2 Import and Export images and files
Week 3 Printing
Week 4 Cross Media Applications
Week 5 Long Documents
Week 6 Tips and Tricks

The course is designed to give you an in depth understand of how to use InDesign which is fast becoming the industry standard for page layout applications.

Basic Drawing and Layout in MS Word
Instructor: Sam Stone

This class will teach you how to use MS Word to do your layouts and basic drawing to make posters, newsletters and other things usually done by other programs. The procedure is straight forward and simple and the results will amaze you.

Basic Virtual Office Assistance
Instructor: Tina Campbell

Virtual Assistance or VAs. Its all the rage. But what is it and how do you successfully start this type of business?

Lesson 1: Learning the Lingo - VA, VOP, VOA, etc.
Lesson 2: Setting Up Office - licenses, location, equipment
Lesson 3: What to do? What to do? - Deciding which services to offer
Lesson 4: Pricing and how to set it
Lesson 5: Where to go for help - The best websites on the internet
Lesson 6: I've Hung My Shingle, Now What? - Finding Clients!

No prerequisites

Ebooks for Fun & Profit
Instructor: Debbie Miller

This class will take you through the steps of designing and creating your own ebook for fun or profit. You will learn how to create the pages for your ebook, create a cover for your ebook, set up a web site for your ebook and how to package your ebook.

Requirements:

You need to have knowledge of HTML plus html program. FrontPage will be used in this class to show and explain the HTML of the ebook layout. You also need a good graphics program, plus how to upload pages to the internet. Some marketing procedures will also be covered. Throughout the class teacher will recommend additional products that will help you in creating your ebook. The additional products will be free or purchase required.

Effective Newsletters for your Business
Instructor: Tina Campbell

What you need to know about writing, distributing, and using a newsletter to promote your business. Don't think a newsletter is the right venue to promote your business? Think again! Let's talk about why. Already distributing a newsletter? Is it as effective as it could be for you? Let's make sure!

MS Excel 101
Instructor: Linda Johnson

Note: This class has been updated to include Excel 2007

Learn how to use Excel to create and edit spreadsheets to produce inventory reports, invoices, budgets, customer databases, and more. Topics covered will include a walkthrough of the Excel interface, creating and editing various types of spreadsheets, using different formulas, creating charts, and basic sorting and filtering of data. For a complete syllabus for all the classes please visit Linda's class page

prerequisite: You must have either Excel 97, 2000, 2002, 2003 or 2007 installed on your computer. A basic understanding of Windows file management is necessary. No other versions of Excel will be taught in this class, including Mac versions.

MS Excel, 201
Instructor: Linda Johnson

NOW UPDATED FOR EXCEL 2007

Learn how to REALLY get the most out of your Excel spreadsheets using the more advanced features of Excel, including macros, advanced filters, named ranges, consolidation, pivot tables and pivot charts, web pages, advanced and nested formulas, Goal Seek, validation, and subtotals. Also learn how to accurately print those large spreadsheets.  For a complete syllabus for all the classes please visit Linda's class page

prerequisite: You must have either Excel 97, 2000, 2002, 2003 or 2007 installed on your computer. No other versions of Excel will be taught in this class, including Mac versions. It is highly recommended that students complete Excel 101 first, or at least have a full understanding of all of the basic Excel features taught in the 101 class, including simple IF statements. This class does not include VBA programming.

MS Word 101
Instructor: Linda Johnson

Learn all the basics of using Microsoft Word to create letters and stationery, newsletters, flyers, business cards, term papers, and more. Topics covered will include a walkthrough of all the features in the interface, word and paragraph formatting, using tables and columns, inserting and formatting clipart, mail merges, wordart and other graphics, creating tables of contents and indexes, and making your own templates and default styles.  For a complete syllabus for all the classes please visit Linda's class page

prerequisite: You must have either Word 97, 2000, 2002, or 2003 installed on your computer. A basic understanding of Windows file management is necessary. No other versions of Word will be taught in this class, including Mac versions. This class is for Word, NOT Microsoft Works.
 

MS Word, 201
Instructor: Linda Johnson

Learn how to REALLY get the most out of Word using it's more advanced features, including advanced Mail Merge features, fields and forms, protection, track changes, comments, captions, indexes, macros, columns and column breaks, custom styles, footnotes and endnotes, bookmarks and hyperlinks, and web pages.  For a complete syllabus for all the classes please visit Linda's class page

prerequisite: You must have either Word 97, 2000, 2002, or 2003 installed on your computer. No other versions of Word will be taught in this class, including Mac versions. It is highly recommended that students complete Word 101 first, or at least have a full understanding of all of the basic Word features taught in the 101 class, including mail merges. This class does not include VBA programming. This class is for Word, NOT Microsoft Works.

MS PowerPoint
Instructor: Linda Johnson

Learn how to create captivating slide show presentations. Topics will include a walkthrough of the PowerPoint Interface, creating slides with bulleted lists, charts, graphics, sounds, tables, organizational charts, and flow charts. We will also learn how to effectively transition slides and animate objects.  For a complete syllabus for all the classes please visit Linda's class page

prerequisite: You must have either PowerPoint 97, 2000, 2002, or 2003 installed on your computer. A basic understanding of Windows file management is necessary. No other versions of PowerPoint will be taught in this class, including Mac versions.

PowerPoint Advanced
Instructor: Kathy Jacobs

Advanced PowerPoint: Doing animations with PPT 2002 or 2003 Learn how and when to use the advanced animation capabilities of PPT to create presentations that impress your audience. Techniques presented will be for both speaker-led presentations and stand-alone (kiosk) presentations.
Over the six sessions, we will cover the following topics:
- Combining animations and effects (2 sessions)
- Using animation on your slide masters
- Understanding the animation timeline
- Understanding and using triggers
- Creating your own motion paths
Classes will be presented as a combination of articles and PowerPoint presentations showing techniques. You will be creating a variety of presentations during the class.

Pre-requisite: Linda Johnson's PowerPoint class or equivalent knowledge. You must have either PowerPoint 2002 or 2003 installed on your computer. A basic understanding of Windows file management is necessary. No other versions of PowerPoint will be taught in this class, including Mac versions.

Typography , Level 1
Instructor: Tawanna Battee-McDonald

Typography is an essential element in good design. It sets the design, it supports the design. It IS the design. Attention to typography detail and knowing how to utilize proper typography skills is what set designers apart. In the Typography level 1 course you will start with learning the history of type and progress to the basic fundamental typography. Knowing what a dumb quote is, or why it happens and other mishaps in typography can boost your design skills in using type!

Prerequisites: Students must have a good working knowledge of how their computer and operating system works, how to open, save and find files, and must have and familiarize themselves with a word program such as Adobe InDesign, Quark Xpress, AppleWorks, or Microsoft Word.

After finishing this course you will know entry level skills in typography. This course will teach you the brief history of type, units of type, the anatomy of type, your how identify typefaces correctly, features of type, typewriting vs typesetting, and learning what is good type and bad type.

Week1
Brief History of Type

Week 2
Units of Type

Week 3
The anatomy of type
Identifying individual typeface characteristics

Week 4
Italics, Bold, Oblique, Expert numbers

Week 5
Typesetting vs Typewriters

 Week 6
Good type and Bad Type

Quark Express Basics
Instructor: Charlene Russ

Download the 30 day demo here. DO NOT INSTALL until after the class begins since it is only 30 days.

This course will introduce the student to this prominent page layout and development tool. The student will learn the basics of the complex Quark Express interface and learn how to create simple documents in Quark. This is an introductory course well suited to those students who’ve never used a page layout program previously. At the conclusion of the course the student will be able to create basic documents using Quark Express. A variety of creative projects will be assigned throughout the course and the students will be given tests on the interface. Additionally, a PDF option will be available to students wishing to print out or save lesson files.

Lesson One: Quark and its uses
1) Standard Quark Applications
2) Interface: Overview and Customization

Lesson Two: The Palettes

1) Tools
2) Measurements
3) Page Layout and Style Sheets
4) Colors Palette
5) Text and Layers

Lesson Three:

1) Creating a new file and changing Layout properties
2) Moving around the interface

Lesson Four: Creating an Advertisement

1) Student will use the tools and color palette

Lesson Five: Basics of Master Pages

1) About Master Pages
2) Creative Application in Publications

Lesson Six: Design Techniques and Layout

1) Working with Tables
2) Using Images
3) Drawing Tools and Text Elements
4) Tips and Tricks