Teccme

TECCME offers training in all Microsoft Office products, with locations in Augusta and Westbrook. For more information or to set up a course with us, please email info@teccme.com or call 879-9950.

Access, Level 1

This course assumes little or no prior database experience. You should have some experience working on a Windows based computer. This course will cover:

· relational database concepts and terminology

· designing a database

· creating tables

· understanding data types and using them correctly

· creating queries and understanding their roles in databases

· creating and modifying data entry forms and reports

· modifying the database structure

Access, Level 2

This course assumes that you have taken the Access Level 1 course or possess the equivalent knowledge. This course will cover:

· learning powerful queries, including: parameter, multitable, crosstab, summary, update, make-table, delete, and append queries

· adding calculations to queries, forms, and reports

· developing complex forms, including form/subform relationships

· adding advanced controls to forms, including combo and list boxes, option buttons, command buttons, and images

· developing complex reports, including summary reports

· exporting and importing data between Access and other programs

· working with hyperlinks and creating web pages with Access

Prerequisites: Access Level 1 or equivalent experience.

Excel, Level 1

This course assumes little or no prior spreadsheet experience. You should have some experience working on a Windows-based computer. This course will cover:

how to identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both
how to create a basic worksheet by entering text, values, and formulas
how to create formulas by using Excel’s built-in functions
how to move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons
how to change the appearance of worksheet data by using a variety of formatting techniques
how to prepare a document for printing by using the spell checking feature and a variety of printing options
how to use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets
how to save an Excel workbook as a Web page

Prerequisites: Basic PC skills.

Excel, Level 2

This course assumes that you have taken the Level 1 course or possess the equivalent knowledge. This course will cover:

how to create charts that graphically represent worksheet data
how to modify charts
how to customize charts by applying formatting
how to enhance worksheets and charts by using the drawing tools to add graphic objects
how to sort information in a list by using the Data, Sort command
how to locate information quickly in a list that meets specified conditions by using the Advanced filter feature

Prerequisites: Excel Level 1 or equivalent experience.

Outlook Level 1

This course teaches the basic functions and features of Outlook 2003. Each student has their own PC and completes hands-on labs in the class and will have a great learning experience with their instructor leading the class. This course will teach students to:

Explore the Outlook environment; use Outlook features; use and customize Outlook Today; and use the different help options.
Configure different e-mail accounts; use the Inbox to read, create, and send messages; reply to, format, and check spelling of messages; read and save attachments; and forward, delete, and move messages.
Set delivery options for messages; set up and use Search Folders; flag messages; set up the read receipt option for messages; customize page setup; print a message; set up and use an address book; and use the mail merge feature to merge messages.
Use the Contacts folder to manage e-mail addresses and create distribution lists; categorize contacts; use the Master Category List to create categories; and assign categories to contacts.

Prerequisites: Basic PC Skills

Outlook Level 2

This course teaches the advanced functions and features of Outlook 2003. Each student has their own PC and completes hands-on labs in the class and will have a great learning experience with their instructor leading the class.

This course will teach students to:

Create custom toolbars, customize the menu bar and Navigation pane, use advanced search options, set and remove filters, and sort, group, and set rules for messages.
Learn how to work with notes, the Journal, advanced Calendar features, and message templates
Change the default appearance of messages by using templates and create and use forms.
Integrate tasks with contacts and import and export data between Outlook and other Microsoft Office applications.
Create a public folder, post, modify, and delete an item from a public folder, delete a public folder, share the Inbox, Calendar, Contacts, and Tasks folders with other users, and use offline folders.
Work with newsgroups and Outlook security features.

Prerequisites: Outlook Level 1 or equivalent experience

PowerPoint, Level 1

This course introduces you to the skills and techniques for developing presentations. The course is designed for anyone who has completed a Windows course or has equivalent experience. This course will cover:

· how to create, edit, and save a presentation

· how to work with presentations

· how to add visual effects to slides

· how to work with text

· how to work with masters, templates, and color

· how to present an informative slide show

Prerequisite: Basic PC knowledge.

PowerPoint, Level 2

This course introduces you to the various editing tools to create effective presentations, create organizational charts, and export presentation slides. This course is designed for anyone who has completed PowerPoint Level I or its equivalent. This course will cover:

· how to work with text and custom templates

· how to work with objects

· how to add visuals, sound, and animation

· how to use new features of PowerPoint

· how to customize PowerPoint

Prerequisites: Basic PC skills and PowerPoint Level 1 or equivalent experience.

Word, Level 1

This course is designed for anyone who has completed a Windows course or has the equivalent experience. This course will cover:

· how to create and save a document

· how to open, edit, and close a document

· how to work with text

· how to change the layout of a document

· how to check spelling and grammar

· how to set and remove tab stops

· how to create left, hanging, and right indents

· how to use numbers and bullets

· how to work with headers and footers

· how to use AutoCorrect

· how to use AutoText

· how to use additional features of Word

Prerequisites: Basic PC skills.

Word, Level 2

This course introduces you to the skills that can make everyday word processing tasks easier and quicker. This course is designed for anyone who has completed Level 1 of Word or who has the equivalent experience. This course will cover

· how to review basic operations and work with documents

· how to insert dates, times, and symbols into a document

· how to use Auto Format

· how to use styles and templates

· how to work with columns and tables

· how to apply borders and shading

· how to use formatting techniques

· how to use mail merge

· how to create mailing labels and envelopes

· how to select and sort records using filters

· how to create AutoText entries and macros

Prerequisites: Word Level 1 or equivalent experience.

Copyright © 2005, TeccME, 88 Bedford St., Portland, Me 04101. All rights reserved.
Calendar courtesy of WebCalendar.
JavaScript Menu (showhidemenu.js and menuarray.js) provided free courtesy of www.howtocreate.co.uk.