Training Schedule

• Access 2002 Workshops


• Adobe Acrobat Workshops


• Audio-Visual Services


• Dreamweaver MX 2004


• Excel 2002 Workshops


• File Management Workshop


• GroupWise 7 Workshops

• Holy Cross Computing


• Photoshop


• PowerPoint 2002 Workshops


• Visio


• Web Search


• Word 2002 Workshops

Access is a relational database management system.  You  can store, organize and manipulate large collections of data in an  electronic format.  This type of format allows you to extract data with ease.  Access, however, can be a little intimidating when you first begin to employ it.  To use it to its best ability you must become familiar with the fundamentals of database design, concept and terminology as well as the software itself.  This class covers the first crucial steps to creating a database.  You will learn how to create tables and determine what data should reside in the relational tables.  You will then learn how to dissect the data through the use of queries. You will also create a basic form and report.

You will learn how to create forms and reports in Access based on existing tables and queries.  Forms allow you to organize fields from various tables and queries into one simple view.  See how you can then add new records to your database using the simple form.  Reports provide a formal view of your data. You can impress your boss by compiling important information through Access reports!  Time saving tools such as form wizard and report wizard will be used in class.

Access is a relational database management system.  You  can store, organize and manipulate large collections of data in an   electronic format.  This type of format allows you to extract data with ease.  Access, however, can be a little intimidating when you first begin to employ it.  To use it to its best ability you must become familiar with the fundamentals of database design, concept and terminology as well as the software itself.  This class covers the first crucial steps to creating a database.  You will learn how to create tables and determine what data should reside in the relational tables.

The longer you work with Access the more you will want to ask questions of your data. In this class you will learn the different types of queries Access offers. Some queries covered in class are: Calculated Field Query, Parameter Query, Find Duplicate Records Query, Finding Unmatched Record Query, Delete Query, Append Query, Make-Table Query and Update Query.

You will be introduced to the Portable Document Format (PDF) creation process. The participant will use the Microsoft Office applications in conjunction with Adobe Acrobat Distiller process to print in PDF format.

Learn how to use Dreamweaver, a web design program, to create and edit web pages. You will learn the basics of Dreamweaver and web page creation, as well as how to format text, manage graphics, and create links and tables. This versatile tool will be used in collaboration with Holy Cross' new, required, web page template for all official pages of the Holy Cross web site. The class will conclude with instructions on how to publish your page to the Holy Cross web site.

The focus of this class is to create and work specifically with Charts in Excel.  Upon completing the course the student will be able to: create chart sheets and embedded charts, modify chart types, add and delete chart items, move and size chart items, format charts, format data, print charts, add graphic objects, sort data, filter data and query data.

This class is designed for the beginner Excel user. Learn how to enter data and navigate within a worksheet, modify a worksheet, use basic formulas, move and copy data, format a worksheet and print a worksheet.

Excel's formulas and functions provide powerful spreadsheet capabilities. In this workshop, you will build both basic and complex formulas. You will learn how to use common functions such as Sum, Average, Maximum, Minimum and Count, and more complex functions such as IF statements, PROPER, DATE and PMT functions. You will learn how to extract First, Middle and Last names from a single cell, how to remove titles from a cell, how to capitalize the first letter of every word within a cell, and how to use Conditional Formatting.

Learn how excel keeps track of information in lists or databases.  You will create a list, use the data form to add, find, edit and delete records.  Sort a list, use the autofilter to filter a list as well as create an advanced filter.  USe the data validation when entering records into a list.

In a standard excel worksheet you cannot change how the data is organized.  However, there is a built-in tool that allows you to create worksheets that can be sorted, filtered and rearranged dynamically to highlight different aspects of your data.  That tool is the PivotTable.  This workshop will teach you to create and edit PivotTables from an existing worksheet.

If you find yourself performing the same task over and over again, you might want to consider creating a macro to complete the task for you. A macro helps you perform routine tasks by automating them. Instead of manually performing a series of time-consuming, repetitive actions, you can learn how to record a single macro that does the entire task all at once for you.

Always searching for your documents or files? Learn to employ Windows Explorer to organize your computer files.  Learn how to create &  name folders to store you files in a manner that makes the most sense to you . Learn how to move your files into your new folders.

GroupWise® 7 is a fully integrated, easy-to-use messaging system that offers a wide range of powerful communication and collaboration capabilities. The purpose of this class is to familiarize novice users with GroupWise to better understand its functionality (class can also serve as a refresher for current GroupWise users). The primary goal is to master email techniques, although a brief overview of the calendar options is included.

Students will explore in-depth calendar functions such as different views of the calendar. Scheduling an appointment, marking an appointment private, using the auto-date function, changing an appointment after it has been sent. Changing email messages to appointments, accepting or declining appointments, checking the status of an appointment. Setting alarms for appointments, printing appointments, tasks and reminder notes and assigning tasks and notes.

The student will learn how to create and enable an out of the office reply to incoming email messages.  You will  learn how to create a rule that will decline any appointments, tasks and notes sent during the out of office period.  You will also learn how to Deactivate/Disable the rule. During the Proxy half of the class, You will learn how to grant others access to your mailbox and calendar.  You will learn how to delete people from the access list as well.

This class introduces the employee to how the Holy Cross' computer networking system (Novell) works.  You will learn about network drives, how to log in, how to install a network printer, and how to use the Novell Application Launcher (NAL).  An introduction to GroupWise 7, Holy Cross' emailing system, is covered in the second half of this class.  You will learn how to send and receive emails, how to attach documents to an email, and how to open attachments.

Photoshop is a "digital darkroom" for creating and manipulating images.  This class will introduce you to the basic elements of the program including: 
Toolbox and palettes 
Image resolution and size
Selections 
Photo retouching 
Using type and basic layers 
Saving images for the web

Learn the basics of PowerPoint from elementary slide creation to adding sound and visual effects to your multimedia presentation.

This class is designed to assist the participant in developing and organizing presentation information and styles.  Topics covered during this informational session will be: identifying your audience, the effects of color in a presentation, adding graphics to emphasize points, using transitions and builds, plot points (identifying pivotal moments in the presentation), and summarizing your presentation.

The participant will learn how to create common diagramming needs such as flowcharts and organizational charts. You will also learn how to format and connect shapes within each diagram.

In this session, you will learn to search the web more efficiently and evaluate the content of the pages you find.  Topics covered include:
--What Search Engines Are and How They Work
--Types of Search Engines and When to Use Them
--Ratings and Reviews of Search Engines
--Search Tips Using Three Popular Search Engines (Yahoo! Google) including:
--Boolean Logic
--Field Searching
--Resources for Search Engine Information
--Why We Need to Evaluate Web Sites
--Ways to Evaluate Web Sites (Popularity, Seals of Approval, etc.)

Learn how to use headers and footers within your documents.  Also, learn how to include page numbers within the Footer of a long document.

The focus of this class is to create and work specifically with Tables in Word.  Upon completing the class the student will be able to:
Identify parts of a table, Create a table, Enter data, Edit Data, Insert/Delete rows and column, Split/Merge Cells, Split/Merge Tables, Move/Copy data, Add borders and shading, Sort data, Perform Calculations, Create Table Headers, Convert Text to Table and Convert Table to Text.

Explore the Word 2002 window and learn how to use various word processing tools.  Utilize the task pane window and smart tags while you create a new Word document.  Format an existing Word document, save the file as a Word document and as another file type, edit text, create columns and tables, utilize the spell checker and thesaurus, and  create an outline with Word.

Topics covered include:
The three components of mail merge: the main document, the data source file, and the merged file.  Learn how to  create form letters, envelopes and labels, and enter & sort records.  Perform merges directly to the printer, to a new document or as an email message.

You will learn how to add cross-references, bookmarks, a table of contents, and an index.

Learn when to use section breaks instead of page breaks when you want to combine Landscape and Portrait pages within one document.