Course Length: 3 half days Description: An introductory course designed
to teach participants how to create simple databases, create and modify
database objects including tables, forms, reports and queries. You will
use a variety of commands, functions, and Microsoft Office Access 2007
capabilities. Who Should Attend: People who are familiar with Windows. Manual Details: MS Office 2007 Courseware Outlines Instructor: Vijaya Chevendra Course Length: 4 half days Description: This course is designed for
non-programmer users who are familiar with Access and now want to explore
some of the intermediate to advanced skill sets. Participants will
learn how to use some advanced commands to work with forms, reports,
designing tables, manipulating queries, as well as using subforms or
subreports.
Participants will also learn how to use automation techniques to make
objects work together (i.e. create a main form with buttons to
access all other database objects). As well, the use of macros to create
event-driven programming for automating routine processes will be
explored. Who Should Attend: People who are familiar with Windows and have taken the Access 2007 - Level I course, or have equivalent experience. Manual Details: MS Office 2007 Courseware Outlines Instructor: Vijaya Chevendra Course Length: 3 half days Description:
This introductory course teaches participants how to work with worksheets and workbooks to analyze data. Participants will use a variety of Excel features to create, modify and format common business reports such as budgets, inventory reports, invoices, and charts. Who Should Attend: People who are familiar with Windows. Manual Details: MS Office 2007 Courseware Outlines Instructor: Donna Bueckert Course Length: 3 half days Description: Level II introduces participants
to intermediate features used to manipulate specific types of data in
worksheets. You will learn how to apply basic skill sets along with
some intermediate to advanced functions to manage and audit numerical
reports. You will be introduced to various functions to perform
specific types of calculations, customize charts, work with pictures or
shapes in a worksheet, customize formatting for specific types of data,
and look at various features for managing different types of lists
using a table or database format. Who Should Attend: People who are familiar with Windows and have taken the Excel 2007 - Level I course, or have
equivalent experience. Manual Details: MS
Office 2007 Courseware Outlines Instructor: Donna Bueckert Course Length: 4 half days Description: Level III provides techniques to automate common
repetitive tasks that are used in the Excel workbook development.
Participants will learn how to use the Excel built in macro recorder to
create basic macros and the Visual Basic for Applications (VBA) Editor
to enhance, customize and create methods of deployment. This course is run over two weeks so participants can review and practice more between sessions. Who Should Attend: People that have taken Excel 2007 - Level
II course, or have equivalent experience. Manual Details: Customized course material provided. Instructor: Donna Bueckert Course Length: 2 hours Description: This short course introduces
Pivot tables in Excel. Participants will learn how to extract data from
long lists of information and present it in readable forms to create
multidimensional data views. Who Should Attend: People who are very familiar with Excel. Manual Details: Customized course material provided. Instructor: Donna Bueckert Course Length: 2 half days Description: An introductory course designed
to teach participants how to create presentations. You will use a
variety of commands, functions, and Microsoft Office PowerPoint 2007
capabilities. Who Should Attend: People who are familiar with Windows 98/2000/XP. Manual Details: MS Office 2007 Courseware Outlines Instructor: Donna Bueckert Course Length: 2 half days Description: In this course, participants
will learn how to work with slide masters for a consistent look in the
presentation, set up animation schemes or customized animation for
specific objects, create speaker notes or handouts, run or customize
the slide show, and use data from other sources in a presentation
program. Who Should Attend: People who are familiar
with Windows and have taken the PowerPoint 2007 - Level I
course, or have equivalent experience. Manual Details: MS Office 2007 Courseware Outlines Instructor: Donna Bueckert Course Length: 2 half days Description: An introductory course designed
to teach students how to create and edit documents, save, open or close
documents, apply formatting options, set tabs and indents, change the
view mode, manipulate the text using features such as copy and paste,
and preview and then print the document. Who Should Attend: People who are familiar with Windows. Manual Details: MS Office 2007 Courseware Outlines Instructor: Donna Bueckert Course Length: 3 half days Description: This course is designed to teach
intermediate skills that can be combined with basic skills to create
more complex documents. Students will look at features such as
inserting pictures or shapes, setting up columns of information, saving
repetitive pieces of text or graphics for easy access at a later date,
styles, and templates to produce professional-looking business
documents. Who Should Attend: People who are familiar with Windows and have taken Word - Level I or have equivalent experience. Manual Details: MS Office 2007 Courseware Outlines Instructor: Donna Bueckert Course Length: 2 hours Description: In this short course, participants will learn how to produce letters, envelopes and labels for
mailings large or small adding a personalized touch. The list of recipients for the mail merge will
be established using a new or an existing data source stored in formats such as Excel or
other table formats. For frequent mailings, methods on how to maintain the data list and quickly
produce mailing documents will be put into practice. Who Should Attend: People who are familiar with Word. Manual Details: Customized course material provided. Instructor: Donna Bueckert Course Length: 2 half days Description: In this introductory course,
students learn how to create and modify PDF documents using Adobe
Acrobat Professional to organize and share documents in a business
environment, as well as implement electronic document review workflows. Who Should Attend: People
who are familiar with the basic functions of their computer's operating
system. Students should also have basic word processing skills, such as
copying and pasting text, formatting text, and so on. Manual Details: Element K Training Courseware (search catalog for course code 084021S3) Instructor: Donna Bueckert Course Length: 2 half days Description: In this course, participants
will learn how to design a fillable form using the LiveCycle Designer
included in Adobe Acrobat Professional to create interactive PDF forms
to distribute, fill out, and then submit electronically. Participants
will also learn how to organize the collected data in a spreadsheet. Who Should Attend: People who are familiar with Windows and Adobe Acrobat Pro. Manual Details: Customized course material provided. Instructor: Donna Bueckert Course Length: 3 half days Description: This introductory course covers
the basic web page creation and web site management features of
Dreamweaver. You will learn how to create and edit web pages, work with
graphics, create links between files, and maintain a web site. The file
transfer protocol covered is SFTP using the WS_FTP application. NOTE: This course does not include more advanced features such as asp and javascript. Who Should Attend: Participants
should be comfortable with the basic skills of computer use, file
management, and familiar with browsing the Internet. Manual Details: Customized manual included in course cost. Instructor: Vivi Tryphonopoulos Course Length: 2 half days Description: This hands-on workshop is a
continuation of the Dreamweaver-Intro course and introduces templates,
styles, style sheets, library items, and rollovers. Who Should Attend: People who have taken the Dreamweaver-Intro course or have equivalent knowledge. Manual Details: Customized manual included in course cost. Instructor: Vivi Tryphonopoulos Course Length: 1 half day Description: This one half day seminar will
show you how to create and process web forms in Dreamweaver. This session is for Dreamweaver users and knowledge of
transferring files is necessary. Who Should Attend: People who use Dreamweaver and know how to transfer files using a secure file transfer program. Manual Details: Customized manual included in course cost. Instructor: Vivi Tryphonopoulos Course Length: 3 half days Description: This course provides you with
the concepts and skills to use Adobe Photoshop CS5 effectively. You
will learn how to use layers and apply filters to create special
effects. Other topics include image creating/editing enhancement; photo
retouching; and saving images in web, print, and PDF formats. Who Should Attend: This
course is designed for the average computer user who is familiar with
the basic skills of computer use and understands file management. Manual Details: Customized manual part of course cost. Instructor: Vivi Tryphonopoulos ITS Non-Credit Computer Course Descriptions
MICROSOFT - OFFICE SUITES
Microsoft Office 2007 - Access Level I (ACCI07)
Microsoft Office 2007 Access Level II (ACCII07)
Microsoft Office 2007 - Excel Level I (EXI07)
Microsoft Office 2007 - Excel Level II (EXII07)
Microsoft Office 2007 - Excel Level III: Macros
Microsoft Office Excel 2007-Pivot Tables (EXPVT)
Microsoft Office 2007 - PowerPoint Level I (PPI07)
Microsoft Office 2007 - PowerPoint Level II (PPII07)
Microsoft Office 2007 - Word Level I (WDI07)
Microsoft Office 2007 - Word Level II (WDII07)
Word 2007 - Mail Merge (WDMM)
ADOBE - ACROBAT
Acrobat 9.0 Professional - Intro (AA9)
Acrobat LiveCycle Designer (LCD)
ADOBE CREATIVE SUITE - DREAMWEAVER
Dreamweaver CS5 - Intro (DW)
Dreamweaver CS5 - Advanced (DWA)
Dreamweaver Web Forms (DWF)
ADOBE CREATIVE SUITE - PHOTOSHOP
Photoshop CS5 - Intro (PS)
System Information
Connect with ITS
 |
 |
 |
 |
