[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | I-TEAM/SES CONFERENCE |
|
| Moderator: | TNPUBS::EWART |
|
| Created: | Wed May 10 1995 |
| Last Modified: | Wed Nov 27 1996 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 49 |
| Total number of notes: | 126 |
24.0. "Training Needs" by DEMON::GOVONI () Mon Sep 25 1995 15:38
Hello,
Pat Baker's capability center, NSCC, has a committee working on the group's
training needs. The training team, headed by Evelyn McKay, has put together
this Q2 training calendar.
Since other capability centers face some, or all, of the same training issues,
I'm posting this calendar to let everyone know what is available. Some courses
and materials are generally available to anyone. Other courses, due to
time and resource constraints, might not be available to anyone external to
NSCC. These particular courses are taught by subject matter experts who
also have their own projects.
Regards,
bob
PS - Before sending any questions to me, I am not a member of this committee
and probably could not answer them.
From: TNPUBS::BOOKIE::NSCC_TRAIN "20-Sep-1995 1512" 20-SEP-1995 15:14:15.18
To: @[NSCC_TRAIN.DIS]NSCC
CC: NSCC_TRAIN
Subj: Q2 Training Calendar for NSCC
The NSCC Q2 training calendar is attached to this message. The calendar
contains a list of various tools training options, both new and existing.
The first five pages of the calendar include summary information and
the remainder of the [long] document consists of abstracts, registration
information, and so on.
Please take advantage of these training events, which are collected here to
meet the specific needs of our CCC. Send comments and questions to the
training implementation team at ORION::NSCC_TRAIN.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NSCC Q2FY96 Training Announcement, Options, Calendar, and Abstracts
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Purpose This announcement lists the Q2FY96 training options for NSCC
contributors. Its purpose is to provide advanced notice so
training interventions can be incorporated into work
schedules.
Background During Q4FY95, Pat Baker commissioned a study of NSCC training
needs. The study identified ten areas of training that NSCC
contributors considered important. In order of priority, they
are:
o Online development tools
o PC environment
o WWW design and development
o Online help design and development
o Production submission
Basic level programming
o Multimedia design and development
o UNIX for OpenVMS
o Technical subject matter
o Usability design
Under Pat's sponsorship, an implementation team was formed to
identify and/or acquire training interventions to support each
of the areas listed.
Ongoing During each quarter, the training implementation team will
assessment of distribute a questionnaire to reassess the training needs and
priorities and priorities of NSCC. Based on its findings, additional training
needs options will be identified and a new calendar will be
published for the preceeding quarter.
Scope of The Q2FY96 training options focus on online development tools.
training The other areas of training will be offered later in FY96.
options
Comments and Send comments and questions to the training team at
questions BOOKIE::NSCC_TRAIN. After attending training listed
in this announcement, please send a note to say
whether or not it met the stated objectives.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NSCC Q2FY96 Training Options and Calendar
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Training formats The tools training options listed below are grouped by format.
Choose the format or formats that best suit your learning
style and work schedule. The following formats are available:
o Tutoring
o Online tutorials and self-paced courseware
o Informational events
o Books, papers, and job aids
o User groups (TBS)
o Hot lines (More TBS)
o Flex-time, facilitated learning centers
o Classroom training
o Notesfiles, and infobases
Abstracts All available abstracts that describe the training options
are listed in the last section of this document. Some
abstracts are preliminary. They will be finalized and mailed
to NSCC contributors as training events approach.
Registration Registration procedures differ depending on the training
format and the organization or individual sponsoring the
training. Refer to abstracts for specific times, dates,
locations, and registration procedures.
To register for TCDG (Technical Competency Development Group)
courses, set host to MILRAT. Username is COURSES. Password is
TRAINING. TCDG assumes you have Pat Baker's approval prior to
enrolling.
Cancellation If you cannot attend a session for which you are registered,
please notify the instructor as early as possible or find
another NSCC contributor to attend in your place.
Location of A copy of this document is located at
this document BOOKIE::USER2:[NSCC_TRAIN.PUBLIC]. The file name
is Q2FY96_TRAINING_CALENDAR.TXT.
<< NOTE >>
Abstracts are listed in the last section of this document.
================================================================================
TUTORING
--------------------------------------------------------------------------------
Topic Tutor Site Date(s) To Schedule:
--------------------------------------------------------------------------------
RoboHelp Gerry Fisher LKG Wednesday TNPUBS::FISHER
afternoon DTN: 226-5986
starting Oct. 18
Andy Janus LKG Monday DELNI::JANUS
afternoon DTN: 226-6230
starting Oct. 25
Doc-to-Help Jim Carrig Flexible Starting Mid Oct. TNPUBS::CARRIG
MS-Office Suite TCDG SHR Oct. 11, Nov. 20 DTN: 237-2554
Dec. 5
================================================================================
ONLINE TUTORIALS and SELF-PACED COURSEWARE
--------------------------------------------------------------------------------
Title Site How to Obtain/Schedule
--------------------------------------------------------------------------------
Self-paced Doc-To-Help:
Creating Manuals and Flexible Starting mid Oct. contact Jim Carrig
Online Documents at TNPUBS::CARRIG
Self-paced Doc-To-Help: Flexible Starting mid Oct. contact Jim Carrig
Advanced Techniques at TNPUBS::CARRIG
Framemaker Tutorial Flexible Contact Evelyn McKay at ORION::MCKAY
Powerpoint NA See Powerpoint HELP menu: Contents
Quick Preview
MS Office Suite (DOS,
Windows, Word, Access,
Excel, Powerpoint) Flexible? TCDG's DTN: 237-2554
MS Office Self-paced
Video (MS-office suite,
MS Project, Access) SHR TCDG's DTN: 237-2557
ZKO 381-1820
================================================================================
INFORMATIONAL EVENTS
--------------------------------------------------------------------------------
Event Date(s) Topic(s) How to Register
--------------------------------------------------------------------------------
EISE Expo Oct. 11-12 Windows 95 NA
User Information/
Publishing Tools
Information Design
Trends
Submission Procedures
and Distribution
Channels
Designing Sep. 29 A variety of design Send mail to
for the topics, including: DONVAN::Rowlette
Internet audience analysis,
graphics, usability,
and standards
Bristol Concepts
Overview (1 hour) Nov. 2 During NSCC
meeting
================================================================================
BOOKS, PAPERS, and Job Aids
--------------------------------------------------------------------------------
Title How to Obtain
--------------------------------------------------------------------------------
WFWV6_BOOKBUILDING_SUBMISSION_GUIDE.PS Copy from KOOLIT::USER21:[PUBLIC.ATOOLS]
"SES WFW Bookbuilding & Submission"
Seminar Handouts Copy ALL_HO.PS from above directory
================================================================================
USER GROUPS
--------------------------------------------------------------------------------
Name Chairperson How to Contact
--------------------------------------------------------------------------------
TBS
================================================================================
HOTLINE
--------------------------------------------------------------------------------
Name Area(s) of Expertise Availability How to Contact
--------------------------------------------------------------------------------
Jack Downing MM Viewer, Doc2Help, RoboHelp, M-W-F DEMON::DOWNING
Paint, Shed, Bit Edit, building
helpfiles for Windows 95
Bob Young MS Word Monday, 10-12 BOOKS::YOUNG
Wednesday, 10-12
================================================================================
FLEX-TIME, FACILITATED LEARNING CENTERS
--------------------------------------------------------------------------------
Topics (Basic and Advanced) Format Site Hours How to Register
--------------------------------------------------------------------------------
Windows Self-paced w/ MRO2 8-5 See description
Word facilitation MKO1 in last section
Powerpoint NIO
Excel
Access
(& others)
================================================================================
CLASSROOM TRAINING
--------------------------------------------------------------------------------
Title Length Presentor/Vendor Site Date(s)
--------------------------------------------------------------------------------
Day at the Office: 1 Day TCDG TAY Oct. 4
(Overview of Word, SHR Nov. 1
Powerpoint, excel) SHR Dec. 8
Another Day at the Office: 1 Day TCDG SHR Oct. 27
Advanced Dec. 14
SuperOffice: Integrating
MS-Applications 1 Day TCDG TAY Oct. 5
Introduction to Word 6.0 1 Day TCDG ZKO Oct. 24
TAY Oct. 25
Intermediate Word 6.0 1 Day TCDG ZKO Oct. 9
TAY Oct. 13
Advanced Word 6.0 1 Day TCDG TAY Oct. 18
Advanced WFW Bookbuilding TBD Janet Clifford TBD Mid-Dec.
TBD Mid-Jan.
Intro to Powerpoint 4.0 1 Day TCDG TAY Oct. 17
ZKO Oct. 20
Intro to Excel 5.0 1 Day TCDG TAY Oct. 6
Intermediate Excel 5.0 1 Day TCDG TAY Oct. 12
Advanced Excel 5.0 1 Day TCDG TAY Oct. 20
Intro to MS-Project 4.0 2 Day TCDG SHR Oct. 19-20
SHR Dec. 6
Intro to MS-Access 2.0 2 Day TCDG SHR Oct. 9-10
SHR Nov. 2-3
SHR Dec. 6
Intermediate MS-Acess 2.0 2 Day TCDG SHR Nov. 9-10
SHR Dec. 18-20
================================================================================
NOTES FILES and INFOBASES
--------------------------------------------------------------------------------
Subject Location
--------------------------------------------------------------------------------
Powerpoint COWPOK::POWERPNT
WFW Template Files & User Guides Copy KOOLIT::USER21:[PUBLIC.ATOOLS]
Information Mapping Templates READMEFIRST.TXT for filenames. (The
Print Drivers and Related Files READMEFIRST.TXT file is contained in
Sample WFW Documents the last section of this document.)
WFW Help Files (Tips and Techniques)
WFW Internet Assistant
PC Job Aids
Adobe Illustrator TRINITY::ADOBE_ILLUSTRATOR
Documentation Standards GEMVAX::RIDER:[DOCSTDS]
Word for Windows BOOKIE::WINWORD
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TRAINING ABSTRACTS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<< NOTE >>
Training abstracts are grouped by format.
Some are preliminary. Final versions will
be distributed by presenters as events
approach.
================================================================================
TUTORING
================================================================================
Title: RoboHelp
Format: Individual and small group tutoring
Description:
The RoboHelp tutoring sessions will each be 2-hour sessions in the
tutor's office. Each session will be limited to 2 or 3 students so that
the session can be geared at exactly the right level for each student.
Students should have a good working knowledge of Microsoft Word. Training
will be based on the latest software (currently RoboHelp Version 3.0 and
MS Word V6.0-c.
Registration information:
Tutoring sessions will begin in mid-October for two hour periods on
Mondays or Wednesdays, as needed, starting with Wednesday October 18th.
To sign up, please contact:
Gerry (TNPUBS::FISHER, DTN 226-5986, LKG2-2) or
Andy (DELNI::JANUS, DTN 226-6230, LKG2-1)
Make sure you tell Andy or Gerry what level of training you need. Sessions
will each be limited to three students."
--------------------------------------------------------------------------------
Title: Creating Manuals and Online Documents
Format: Individual and small group tutoring
Tool: Doc-To-Help
Topics (preliminary):
o The Process of Creating an Online Document
o The Process of Creating an EDMS-compliant Manual
o Working with Tables
o Working with Graphics
o Inserting Cross References and Hypertext Links
o Converting Your Project Into Help
o Locating and Correcting Errors
Tutor: Jim Carrig
Location: Flexible
Registration: Contact Jim @ TNPUBS::Carrig
--------------------------------------------------------------------------------
FREE! 1 ON 1 DESKTOP Q & A SESSION (30 Mins.) $FREE prereq:NONE
Oct 11, call for appointment DTN237-2554 #APHQA-01 PC Classroom #1
Nov 20, " #APHQA-04 PC Classroom #1
Dec 5, " #APHQA-06 PC Classroom #1
Here is an opportunity for to get some FREE individual time with an instructor
(Bob Lavin of Ultimate Consulting)who can help you with topics YOU need help
with, in the Microsoft Office Suite of products,(DOS,Windows,Word,Access,Excel,
Powerpoint). If you have the need to create special tables in Word, or prepare
a complex chart, but you haven't been able to find help to do it; this may be
your opportunity to do so in a one-on-one session. Slots will be limited to
30-minutes. Call to reserve a seat at SHR DTN 237-2554.
================================================================================
ONLINE TUTORIALS and SELF-PACED COURSEWARE
================================================================================
Title: Creating Manuals and Online Documents
Format: Self-paced course
Tool: Doc-To-Help
Topics (preliminary):
o Introduction to Doc-To-Help
o The Process of Creating an Online Document
o Start Your Practice Help Project
o Working with Tables
o Working with Graphics
o Inserting Cross References
o Creating a Glossary Term and a Margin Note
o Indexing with Doc-To-Help
o Preparing Your Project for Conversion
o Converting Your Project into Help
o Looking Under the Hood
o Locating and Correcting Errors
o Using the Navigator and the Setup Wizard
Location: Flexible
To obtain course: Contact Jim Carrig @ TNPUBS::Carrig
--------------------------------------------------------------------------------
Title: Doc-To-Help: Advanced Techniques
Format:Self-paced course
Tool: Doc-To-Help
Topics (preliminary):
o Changing the Look of Your Project
o Graphics in Help
o Hypertext Links and Related Topics (See Alsos)
o Working with Macros and Secondary Windows
o Segmented Hypergraphics
o Creating Context Sensitive Help for an Application
Location: Flexible
To obtain course: Contact Jim Carrig @ TNPUBS::Carrig
--------------------------------------------------------------------------------
Title: Framemaker
Format: Online tutorial
Location: Flexible
Abstract/Description:
Two copies of the software, each including the built-in tutorial, will be
available for training purposes. The software will be issued like a libary
loan for a period of one week or until another person needs it, whichever is
longer. The Training Team cannot supply system support so please make any
installation arrangements yourself or with your system manager. You will need
access to a PC to run Framemaker. Orders are expected to arrive in early
October; you can book in advance.
To obtain tutorial: Contact Evelyn at [BOOKIE::]McKay
--------------------------------------------------------------------------------
SELF-PACED MS-OFFICE COURSES $80 (MS-Office Suite, with Project & Access)
Is it difficult for you to take a whole day off for training? Do you prefer to
work alone and go at your own pace? Take advantage of the VIDEO courseware
available at either SHR(DTN237-2554) or ZKO(381-1820). Simply call to reserve
time at your convenience at either site and work in a separate office without
interruptions. The cost is low and you can make unlimited trips back to work on
the same course WITHOUT being charged again until you are comfortable with the
application. We also offer "hotline" user assistance and you receive a workbook
and practice disk to keep for reference.
--------------------------------------------------------------------------------
================================================================================
INFORMATIONAL EVENTS
================================================================================
Title: "Designing for the Internet"
Format: Panel discussion
Description:
A panel discussion on "Designing for the Internet", covering a variety of topics
from text, graphics, and media design, to usability and standards.
Time: Friday, September 29
9:30-12:00
Place: LKG, Harbor C.R.
Audience: Novice and experienced Internet information providers
Agenda: 9:20 - 9:30 Introduction
Janet Piazza
9:30- 9:50 Analyzing Your Internet Audience
Browsers, level of skill, providing help
Terry Sherlock
9:50-10:10 Text Considerations
Chunking/linking, navigation, tables,
HTML 3.0, Netscape extensions
Terry Sherlock
10:10-10:30 Graphics Considerations
Graphics formats and tradeoffs, browsers,
resolution, color
Phil Fotos
10:30-10:45 BREAK
10:45-11:05 Media Considerations
Helper Apps (types, size, availability),
media formats, alternatives
Jack Jurras
11:05-11:25 Usability
Processes for initial design, gathering
feedback, testing
Mike Paciello
11:25-11:45 Standards
How to conform to corporate standards
Don Skarzenski
11:45-12:00 Q&A
Pre-requisite: It is strongly recommended that anyone who is new to
Internet design should reserve and watch the videos
of Terry Sherlock's presentation on "Putting Information
on the Internet" prior to attending this panel
discussion. To reserve the videotapes, contact
Sherri Rowlette (DONVAN::)
RSVP: Send mail to DONVAN::ROWLETTE to reserve your seat.
--------------------------------------------------------------------------------
================================================================================
FLEX-TIME, FACILITATED LEARNING CENTERS
================================================================================
There are now three PC COMPETENCY TRAINING CENTERS!
MRO2 (Marlboro, MA)
Phoenix Room MR02 Lower Level
MROA::PCTRAIN
DTN: 297-4464
MKO1 (Merrimack, NH)
Gilmanton 6 Conference Room MKO2-1/G26
MKOTS3::PCTRAIN
DTN: 264-0759
NIO (Salem, NH)
Training Room NIO-1/J20
SALEM::PCCOMP
DTN: 285-2960
New AND Experienced Users! We have the latest in software applications and a
PROVEN SUCCESSFUL - Unique approach to training!
CREATE YOUR OWN TRAINING SCHEDULE!
**********************************
MRO Training
Center The Americas Development & Learning Delivery Group, is
pleased to announce the opening of the third Digital
"PC Competency Training Center" - opened June 13, 1995
at the MRO2 facility.
NOTE: The Merrimack and Salem PC Competency Training Centers
will remain open!
Who Should Anyone using laptop/desktop PC applications as part of their
Attend work activities.
Software The PC Competency Center currently has the following Microsoft
Applications software applications available in basic AND advanced levels:
o Windows o Excel
o Word o Access
o PowerPoint
o and More!
Integrated This Interactive Learning Environment is a training
Approach to methodology which provides a learning environment allowing
Learning students to work at their own pace.
It consists of:
o A Facilitator present at all times to
answer questions
o Multi-Sensory Approach to learning
o Actual on-line PC Applications
o SELF-PACED, MODULARIZED STUDENT MATERIALS
o Audio Cassettes
o State-of-the-art Digital Personal Computers
o Pre-tests and training needs assessments as
requested
o Proficiency tests upon course completion
Flex Time FLEX TIME SCHEDULING allows students to schedule training
at their convenience and availability. There are no
predetermined schedules, so there are no missed classes.
Students make their own schedules.
********************************
PC COMPETENCY TRAINING CENTER
********************************
HOURS: 8:00 A.M. TO 5:00 P.M.
(Flex-time schedule) - 2,3 or 4 hour time slots
are recommended.
COST: $145 per course
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
REGISTRATION: The registration form is attached. Registrations
are now being accepted. Registrations can be made
by phone or E-mail
Confirmations will be made via phone or E-mail.
*************************************************
REGISTRATION FOR PC COMPETENCY TRAINING CENTER
*************************************************
REGISTER BY
E-MAIL: SEND E-MAIL TO: MROA::PCTRAIN for MRO
MKOTS3::PCTRAIN for MKO
SALEM::PCCOMP for NIO
SUBJECT: PC Training Course Request
Note: You may edit this section to return your
registration information.
INCLUDE: TRAINING CENTER LOCATION: _________________
NAME: ________________________________________
BADGE: _______________________________________
LOCATION: ____________________________________
COST CENTER: _________________________________
DTN PHONE: ___________________________________
COURSE(s) REQUESTED: _________________________
_________________________
_________________________
DATE AND TIME REQUEST FOR FIRST SESSION:
_________________________
Please note that it is only necessary to indicate
a date and time for the first session at this time.
You will schedule future sessions as needed. Courses
generally run 10 - 12 hours. Please select a starting
2,3 or 4 hour time slot; 8-10, 8-12, 9-11, etc.
NOTE:
CROSS CHARGE Each course you register for will be
charged to your cost center. You will
create your own schedule for attendance
and completion.
PHONE: MRO: DTN: 297-4464
MKO: DTN: 264-0759
NIO: DTN: 285-2960
Walk In: You are welcome to stop in to look over our training
rooms and register in person.
MRO: Phoenix room -Level LA
MKO: Gilmanton 6 Cr MKO1-1/G26
NIO: Training Conference Rm NIO1-1/J20
--------------------------------------------------------------------------------
================================================================================
CLASSROOM TRAINING
================================================================================
TITLE: Day at the Office - (Overview of Word, Powerpt, Excel)
SCHEDULE: 10/ 4/95 to 10/ 4/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross Training Rm CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 9/20/95 COST: $135
SCHEDULE: 11/ 1/95 to 11/ 1/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #1 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/18/95 COST: $135
SCHEDULE: 12/ 8/95 to 12/ 8/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #2 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 11/22/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHOA-14
A DAY AT THE OFFICE (MS OFFICE -WORD 6.0, EXCEL 5.0, POWERPOINT 4.0)
Format: 1 day lecture/lab
PREREQUISITES
An "Introduction to Windows" class, or a working knowledge of Windows and the
use of the mouse.
COURSE OVERVIEW
For those of you who would like a general overview of the Microsoft Office
Software Package, this class is for you! This course has been designed to focus
on the needs of the casual user of Microsoft Office (i.e. Microsoft Windows,
Word, Excel, and Powerpoint). Upon completion of this one-day training class you
will be able to:
COURSE OUTLINE
o Move thru and manipulate multiple windows with the mouse and the keyboard.
o Understand the concepts of the file manager
o Build and organize the structure of the individual directory and file needs
o Create, edit and format simple Word documents, and build numbered or bulleted
list.
o Create a simple Excel spreadsheet to include formatted labels, values and
simple formula.
o Modify the worksheets appearance and adjust columns and rows.
o Create a simple Excel chart
o Create a simple Powerpoint presentation
COURSE OBJECTIVE
For those of you who need more training in Advanced features such as, Creating
Groups and Items in Windows, Linking to a Network, Word Tables, Columns and
Templates, Graphics Manipulation, Excel Chart Enhancement and Linking Multiple
Worksheets, and using Powerpoint, it is advised to attend the individual FULL
day course that is offered for the individual Application.
You can take this course in order to see which application would best fit your
needs, and then take the full day of training on that particular application.
--------------------------------------------------------------------------------
TITLE: Advanced Day at the Office - SHR
SCHEDULE: 10/27/95 to 10/27/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #2 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/13/95 COST: $135
SCHEDULE: 12/14/95 to 12/14/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #2 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 11/30/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full.
DESCRIPTIONS and OBJECTIVES for COURSE APHOB-06
ADVANCED DAY AT THE OFFICE
Format: 1 day lecture/lab
PREREQUISITES
Successful Completion of the "A Day at the Office" course, or equivalent.
COURSE DESCRIPTION
The casual user will now compliment their knowledge learned in "A Day at the
Office" with added features to Word 6.0, Excel 5.0 and Powerpoint 4.0. This
course is not designed for the Advanced user of these products. For the
advanced level, it is advised to attend the individual full day courses that are
offered.
COURSE OUTLINE:
Word
o Review
o Long Documents
o Headers/Footers
o Multiple Documents
o Cutting/Pasting
o Clip Art
o Templates
o Styles
o Glossaries
Excel
o Review
o Absolute/Relative Values
o Date
o If Statement
o Linking Worksheets
o Charts
o Data Series
PowerPoint
o Review
o Extracting an Outline
o Masters
o Templates
o Media Types
o Color Schemes
o Transitions/Builds
o Presenters Notes/Audience handouts
Working Together
o Excel to Word
o Excel to PowerPoint
o Word to PowerPoint
Final Summary and Review
--------------------------------------------------------------------------------
TITLE: SUPER OFFICE! - Integrate Your MS Applications - TAY
SCHEDULE: 10/ 5/95 to 10/ 5/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross T.R. . CLASS SIZE: 12
INSTRUCTOR: Professional Development Group
ENROLLMENT CLOSING: 9/25/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHOC-08
SUPER OFFICE! - INTEGRATE YOUR MS APPLICATIONS
FORMAT: 1-DAY LECTURE/LAB
PREREQUISITES:
You should have a good knowledge and experience in each of the following
packages:
- Intro Access or equivalent
- Intermediate Excel or equivalent
- Intermediate Word or equivalent
- Introduction to Powerpoint or equivalent
COURSE DESCRIPTIONS:
This one-day course will show you how to use tools from each of the Microsoft
Office packages to create an integration process. You will see the advantage of
linking your data between the applications. This will show you how to create
linked data which will automatically update as the source changes speeding up
your day-to-day efficiency. This course will show you the power of Microsoft
office.
COURSE OBJECTIVES:
- Moving information between Microsoft Office
- Creating OLE linking and embedding
- Understanding OLE 1.0 versus OLE 2.0
- Editing the linked objects in applications
- Inserting a file versus linking
- Importing/exporting tools in Access and Excel
- Using MSQuery in Excel to extract data from an Access database
COURSE OUTLINE:
ACCESS:
Creating table with Make Table query. Using the import/export setup options to
download data from another source type. Querying the data to be properly
categorized through a chart of accounts. Exporting the information and
comparing it to data from previous quarters in Excel.
EXCEL:
Import a text file of account numbers and account balances into Excel, Comparing
Excel's import wizard to Access and understanding the advantages of each. Using
external data from Access and bringing it into Excel creating a live link.
Consolidating the account balances to conform to the financial reports.
Comparing the account balances on a year to year basis and graphing in Excel.
Creating templates which will provide consistent layouts for reporting purposes.
WORD:
Linking objects and charts from Excel into a Word document which will
automatically update as Excel changes. Understanding link fields in Word.
Taking advantage of frames for the linked or embedded object. Viewing and
updating links. Using templates for those documents which are used every
quarter.
POWERPOINT:
Creating a Powerpoint presentation which will automatically update as the Excel
data changes. Linking Word documents into a presentation to create slides.
PROJECT:
Taking information from Microsoft project and placing in powerpoint, word excel
or access.
--------------------------------------------------------------------------------
TITLE: Introduction to Word 6.0
SCHEDULE: 10/24/95 to 10/24/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: ZKO1-3 FORRESTER CR CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/10/95 COST: $135
SCHEDULE: 10/25/95 to 10/25/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross Training Rm CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/11/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHWA-18
INTRODUCTION TO WORD 6.0
Format: 1 day lecture/lab
PREREQUISITES
o Overview of PC Applications course or
o Microsoft Windows 3.1 course
COURSE DESCRIPTION
This course teaches the student the basic features of using Microsoft Word for
Windows as they relate to everyday tasks such as creating and printing a
document.
COURSE OBJECTIVES:
o understand the basic features of Microsoft Word for Windowso create, save,
retrieve and edit documents
o format characters, paragraphs and complete documents
o print a document and work with the Windows Print Manager
COURSE OUTLINE
o Introduction to Word for Windows
o Accessing and Using Word for Windows
- requirements/installing/windows applications menu/executing
commands/help
o Using Word for Windows Practice Session
o Managing Word for Windows Documents
- creating and saving a document/closing a document
window/deleting a document
o Editing Your Document
- selecting and deleting text/undoing a command/repeating a
command/moving text
- copying text/searching and replacing text/checking your
spelling
o Managing and Editing Documents Practice Session
o Formatting Characters
- using the ribbon/selecting options from the ribbon/character
formatting
o Formatting Paragraphs
- using the ruler/changing paragraph alignment, tab settings,
and line spacing
o Formatting Complete Documents
- page layout/margin ruler/top and bottom margins/paper
size/print orientation
o Formatting Practice Session
o Printing a Document
- printing your document/previewing/page numbering/headers and
footers
o Working with Multiple Windows
- understanding multiple windows/opening multiple
windows/arranging windows
o Windows and Printing Practice Session
o Cut & Paste Demo
-------------------------------------------------------------------------------
TITLE: Intermediate Word 6.0
SCHEDULE: 10/ 9/95 to 10/ 9/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: FORRESTER CR (ZKO1-3) CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 9/25/95 COST: $135
SCHEDULE: 10/13/95 to 10/13/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross T.R. CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 9/28/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHWD-09
INTERMEDIATE WORD 6.0
Format: 1 day lecture/lab
PREREQUISITES
o Introduction to Word
COURSE DESCRIPTION
This course is designed for the user familiar with the basics of Word for
Windows. During this class, students will learn how to merge, sort, and use the
thesaurus. They will also learn to format paragraphs by adding shading and
borders and enhance entire documents by working with multiple sections, columns,
and styles. The course also explains how to use the following features new Word
for Windows: the grammar checker, the envelope generator, and the bullets and
Numbering command, which allows the user to turn a series of paragraphs into a
Bulleted or numbered list.
COURSE OBJECTIVES
o Merge documents and print envelopes
o Sort items in your document
o Add borders, shading, bullets, and numbers to paragraphs
o Work with styles, columns, and multiple sections
o Use the grammar checker and thesaurus
COURSE OUTLINE
Creating Tables
o Inserting a table
o Adding text
o Inserting and deleting columns and rows
o Changing column width
o Adding lines and borders
o Merging cells
o Using indents and tabs in a table
Merging Documents
o Intro to Merging
o Creating a Data file
o Creating a Main Document
o Merging Documents
o Printing Envelops
Using Styles
o Working with Standard Styles
o Creating your own styles
Using Templates
o Creating a document using a Word template
o Editing a template
Using Find File
o Searching for documents with the Find File
o Managing document files
Final Summary and Review
--------------------------------------------------------------------------------
TITLE: Advanced Word 6.0 - TAY2
SCHEDULE: 10/18/95 to 10/18/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross Training Rm CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/ 4/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHWE-06
ADVANCED WORD 6.0
Format: 1 day lecture/lab
PREREQUISITES
o Introduction to Word and
o Intermediate Word
COURSE DESCRIPTION
This class is designed for students who want to learn the advanced features of
Microsoft WORD for Windows. These features include creating a table of
contents, creating an index, creating footnotes, creating an outline of a
document, creating tables, and using the glossary. In addition, students will
learn to import, export, link and embed files and objects into WORD for Windows
documents, as well as create and run macros and createand use document
templates.
COURSE OBJECTIVES
o Use a variety of WORD for Windows fields
o Enhance documents with a table of contents, an index, and footnotes
o Outline documents
o Create and use tables
o Import, export, link and embed files and objects into WORD for Windows
documents
o Use the glossary
o Create and use macros
o Create and use document templates
COURSE OUTLINE
Working with Fields
o Entering and displaying fields
o Making changes to fields
o Formatting fields
Advanced document enhancements
o Creating and editing footnotes
o Selecting items in your outline
o Viewing your outline
o Adding numbers to your outline
o Modifying your outline
Working with tables
o Creating a table
o Changing the table design
o Adding borders
o Working with text in tables
o Converting text into a table
o Creating a simple spreadsheet
Transferring Data
o Saving documents in other formats
o Importing graphics and pictures
o Positioning a graphic
o Linking information
o Embedding information
Recording and Using Macros
o Recording and running a Macro
o Changing a Macro
o Auto Macros
o Using the MACROBUTTON Field Code
Working with Document Templates
o Creating Document templates
o Editing a document template
o Using a document template
o Using the FILLIN field with a template
--------------------------------------------------------------------------------
TITLE: Introduction to Powerpoint 4.0
SCHEDULE: 10/17/95 to 10/17/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY1-1 Bourne Bridge T.R. CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/ 3/95 COST: $135
SCHEDULE: 10/20/95 to 10/20/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: FORRESTER CR (ZKO1-3) CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/ 6/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHPA-14
INTRODUCTION TO POWERPOINT 4.0
Format: 1 day lecture/lab
PREREQUISITES
o Microsoft Windows or a working knowledge of Microsoft
Windows.
COURSE DESCRIPTION
This course is designed to familiarize you with PowerPoint for Windows. Upon
completion of this training, you will be able to create, edit, save and print or
show a presentation. In addition, you will learn to use the drawing tools, work
with symbols, and create graph charts.
Topics Include:
Getting Started with PowerPoint
* Opening and Closing a Presentation
* Changing the View and Saving a Presentation
* Moving between Slides
* Using Different Views
* The Toolbars
* Using Help and Cue Cards
Developing a Presentation
* Creating a New Presentation
* The AutoContent Wizard
* The Pick a Look Wizard
Working With Text Slides
* Adding Text to a Slide
* Selecting and Editing Text
* Formatting Text (Alignment and Attributes)
* Understanding the Ruler
* Using Spell Check
Using the Drawing Tools
* Drawing and Selecting Objects
* Resizing and Reshaping Objects
* Moving and Duplicating Objects
* Formatting Objects
* Grouping and Ungrouping Objects
* Rotating and Flipping Objects
Understanding Microsoft Graph
* Creating a New Graph
* Formatting the Graph
Using Slide Masters
Creating Slide Shows
Final Summary and Review
--------------------------------------------------------------------------------
TITLE: Introduction to Excel 5.0 - TAY2
SCHEDULE: 10/ 6/95 to 10/ 6/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross Training Rm CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 9/22/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHEA-18
INTRODUCTION TO EXCEL 5.0
Format: 1 day lecture/lab
PREREQUISITES:
Introduction to Microsoft Windows or a working knowledge of Microsoft Windows.
COURSE DESCRIPTION
In this class the student will learn how to enter and exit EXCEL, create and
save a worksheet, use basic formulas, enhance the appearance of their worksheet,
and print it. Students will also learn how to use many of the tools on the
Standard and Formatting toolbars.
COURSE OBJECTIVES:
o start, exit and get help in EXCEL
o select cells and ranges
o enter and edit information
o name, save, close, open, and delete files
o manage multiple windows
o create formulas and use EXCEL functions, such as SUM,
AUTO-SUM, and AVERAGE
o clear, delete, and insert worksheet information
o move and copy information
o format numbers
o change font and font size and add bold and italics
o change the size of columns and rows and text alignment
o add borders to emphasize a range of information
o spell-check your worksheet
o set margins and add headers and footers
o print your worksheet
COURSE OUTLINE
Accessing and using EXCEL
o learn to use the worksheet, selecting sells
o entering and changing information
o entering text, dates and times, numbers and formulas
o managing EXCEL files
o closing a document window and opening a new worksheet or an existing file
Managing Multiple Windows
o deleting a file and exiting EXCEL
o using functions to calculate numbers
o using functions to calculate numbers
o selecting ranges and using EXCEL functions
o totaling a range of numbers
o automatically totaling a range of numbers
Manage Worksheet Information
o introducing shortcut menus
o moving, copying, clearing and deleting information
o changing the appearance of your worksheet
o using multiple toolbars
--------------------------------------------------------------------------------
TITLE: Intermediate Excel 5.0 - TAY2
SCHEDULE: 10/12/95 to 10/12/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross T.R. CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 9/28/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full.
DESCRIPTIONS and OBJECTIVES for COURSE APHEE-15
INTERMEDIATE EXCEL 5.0
Format: 1 day lecture/lab
PREREQUISITES
o Introduction to Excel
COURSE DESCRIPTION
This class is designed for the user who knows the basics of Microsoft Excel
and who wants to learn database and graphing features.
COURSE OBJECTIVES
o Create a database
o Use the data form to work with information in a database
o Number and sort records in a databaseo Find and extract records in a
database
o Create, save, open, and print a chart
o Embed a chart on a worksheet
o Format a chart
o Create a picture chart
COURSE OUTLINE
Database Management
o The Excel Database
o Database technology
o Creating a database
o The data form
o Sorting a database
o Numbering Records
Sort Keys
o Performing the sort
o Sorting a database
o Finding records with the data form
o Finding records with the criteria range
Text Criteria
o Comparison criteria
o Computed criteria
o Multiple search criteria
o Deleting and extracting records
o The extract range, performing the extract
o Extracting from a database on another worksheet
o DAVERAGE, DGET, DMAX, DMIN, DSUM
o Database Functions
Excel Charts, Creating a Chart, selecting a chart type
o Using the ChartWizard
o Saving, opening and printing a chart
--------------------------------------------------------------------------------
TITLE: Advanced Excel 5.0 - TAY2
SCHEDULE: 10/20/95 to 10/20/95 LENGTH: 8.00
TIME: 9:00 to 5:00
LOCATION: TAY2-1 Holy Cross Training Rm CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/ 6/95 COST: $135
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION If you must cancel, please do so PRIOR to 10 working days of
POLICY: course start date, or your CC will be charged in full
DESCRIPTIONS and OBJECTIVES for COURSE APHEF-09
ADVANCED EXCEL 5.0
Format: 1 day lecture/lab
Prerequisites:
o Introduction to Windows - or working knowledge of Windows
o Introduction to Excel - or working equivalent
o Intermediate Excel - or working equivalent
COURSE OVERVIEW:
This course has been designed for those who have been using Excel and now have
the need to expand their knowledge. Excel's advanced capabilities will be
exercised throughout this session and will enable you to add many new features
to your Excel applications. You will learn how to automate your applications
for speed as well as design techniques for ease of use.
COURSE OBJECTIVES:
o Accessing Excel's powerful built-in functions
o Sorting a list and avoiding the most common fatal errors
o Handling large spreadsheets in spreadsheet design
o Adding and formatting text with the Toolbar
o Tricks and techniques in pushing functions to their limits
o Creating a "What if?" application to aid in your decision
making
o Using the outline feature to organize your spreadsheets
o Producing linking formulas that access data in multiple files
COURSE OUTLINE:
Quick Review
o Are you creating worksheets the hard way?
o Exploring tips and tricks for better worksheet design
o Using quick key commands for speed
o Designing faster worksheets and custom numeric formats
Worksheet Design
o Documenting your worksheet for yourself and other users
o Using tables to aid in worksheet editing
o Protecting sensitive information with passwords
o Auditing worksheets for accuracy
o Learning workspace concepts and applications
o Organizing and summarizing your worksheets with the outline
tool
Database Functions
o Taking advantage of the searching process
o Sorting without problems
o Exploring data tables and how they can be used as a decision
making tool
o Creating a data series of numbers
o Using "Pivot Table" to set up dynamic reports
o Filtering data from a database using specified criteria,
including wildcards
Excel Functions
o Tapping the resources of Excel's built-in functions
o Using the IF function effectively
o Using LOOKUP tables for multiple choices
o Considering dates and aging
o Discovering arrays and their powerful applications
o Exploring additional functions
Combining Worksheets
o Exploring how Excel relates worksheets
o Opening multiple documents to relate your worksheets
o Joining data from several spreadsheets
o Linking spreadsheet cells with other files to create dynamic
applications
o Accessing data in multiple files
o Moving information from one worksheet to another
o Creating formulas that update multiple files automatically
o Using the Workbook effectively
--------------------------------------------------------------------------------
TITLE: Introduction to MS-Project 4.0 - SHR
SCHEDULE: 10/19/95 to 10/20/95 LENGTH: 16.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #1 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/ 5/95 COST: $270
SCHEDULE: 12/ 6/95 to 12/ 7/95 LENGTH: 16.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #1 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 11/22/95 COST: $270
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION WITHDRAW 2 WEEKS PRIOR TO START DATE TO AVOID CHARGES
POLICY:
DESCRIPTIONS and OBJECTIVES for COURSE TTHJA-08
INTRODUCTION TO MS-PROJECT 4.0
Format: 2 day lecture/lab
PREREQUISITES
o The overview of PC Applications course or a basic understanding of
the personal computer
o MS Windows
COURSE DESCRIPTION
This two-day course introduces you to the concepts of project management as
applied to managing the tasks necessary to complete various projects. During the
course, you will learn how to create Gantt charts, outline the tasks which make
up a project and prepare a schedule. Microsoft Project for Windows allows you
to assign resources and costs to each task, tally the various costs and flag
resource schedule conflicts. After the schedule conflicts have been identified,
Microsoft Project for Windows provides the means of resolving the conflicts
through resource leveling. This course will teach you how Microsoft Project for
Windows operates and prepare you for managing your own projects.
COURSE OBJECTIVES
Introduction to Project Management
* Getting Started with Project Management
Project for Windows
* Starting Microsoft Project
* Changing the Active Window Pane
* The Project Toolbars
* Accessing Help and Cue Cards
* Opening an Existing Project
* Exiting Microsoft Project
Creating a Simple Project
* Listing Tasks and Durations
* Saving a Project File
* Project Statistics
* Entering Recurring Tasks
* Assigning Relationships
Introduction to PERT Charts
* Entering and Editing Tasks in the PERT Chart View
* Changing a Task's Relationship to Its Predecessor
Introduction to Gantt Charts
* Changing Appearances
* Timescale Changes
* Font and Attribute Changes
* Changing Gantt Bars
Outlining Projects
* Promoting and Demoting
* Linking
Adding and Assigning Resources
* The Resource Edit Form
* The Resource Sheet
* Assigning Resources to Tasks
* Assigning One Resource to Several Tasks
Working with Calendars
* Base and Resource Calendars
* Assigning a Calendar to a Project
* Assigning Calendars to Resources
Handling Overallocation Errors
* Resource Conflicts
* Leveling Resources
* Undo Leveling
* Reassigning Work to Other Resources
Baselines
* Setting the Baseline
* Using Output from the Baseline
Filters
* Defining a Filter
* Creating Custom Filters
* Testing for Multiple Conditions
* Create Custom Interfaces for Filters
Final Summary and Review
--------------------------------------------------------------------------------
TITLE: Introduction to MS-Access 2.0 - SHR
SCHEDULE: 10/ 9/95 to 10/10/95 LENGTH: 16.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #2 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 9/25/95 COST: $270
SCHEDULE: 11/ 2/95 to 11/ 3/95 LENGTH: 16.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #2 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/20/95 COST: $270
SCHEDULE: 12/12/95 to 12/13/95 LENGTH: 16.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #2 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 11/28/95 COST: $270
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION WITHDRAW 2 WEEKS PRIOR TO START DATE TO AVOID CHARGES
POLICY:
DESCRIPTIONS and OBJECTIVES for COURSE TTHAA-24
INTRODUCTION TO ACCESS 2.0
Format: 2 day lecture/lab
PREREQUISITES
**It would be useful to have spreadsheet knowledge prior to taking this course**
AND - One or more of the following:
o Microsoft Windows
o Overview of Personal Computers for Windows
o A working knowledge of Windows and experience using a mouse
COURSE OVERVIEW
This class is designed for students who want to learn the basic features of
Microsoft Access for Windows. These featuresinclude opening Microsoft Access,
navigating tables and forms, using Help and Cue Cards, and adding and saving
data in forms and tables. In addition, students will learn to create, modify,
and save queries, forms and reports, as well as print forms, reports, or the
results of a query.
COURSE OBJECTIVES
o Open & Close Microsoft Access
o Navigate database tables and forms
o Use Help and cue cards
o Add and save data in forms and tables
o Create, modify, and save queries, forms, and reports
o Print forms, reports, or the results of a query
COURSE OUTLINE
Intro to Access
o The introductory screen
o Understanding Access databases
o Accessing Commands
o Opening a database
o Closing a database
o Creating a new database
o Getting Help
o Exiting Microsoft Access
Working with Tables
Creating a table
o Adding data to a table
o Moving around in a table
o Editing records
o Changing the table design
o Changing the order of fields
o Changing column width
o Changing row height
o Using find and replace
o Printing a table
o Closing a table
o Deleting a table
Creating a Query;
o Viewing a query
o Creating a New Query
o Creating a Query Expression
o Modifying a Query's Structure
o Saving a Query
o Printing a Dynaset
Working with forms
o Intro. to forms
o Creating a form with form wizards
o Viewing data with a form
o Entering data in a form
o Resizing Controls
o Saving a form
o Printing a form
o Closing a form
Working with Reports
o Creating a Report
o Modifying a Report
o Printing a Report
o Saving a Report
--------------------------------------------------------------------------------
TITLE: Intermediate MS-Access 2.0 - SHR
SCHEDULE: 11/ 9/95 to 11/10/95 LENGTH: 16.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #2 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 10/26/95 COST: $270
SCHEDULE: 12/18/95 to 12/19/95 LENGTH: 16.00
TIME: 9:00 to 5:00
LOCATION: SHR3-2, PC Classroom #1 CLASS SIZE: 12
INSTRUCTOR: Compuworks
ENROLLMENT CLOSING: 12/ 4/95 COST: $270
TO REGISTER: Set host to MILRAT; Username: COURSES; Password: TRAINING
CANCELLATION WITHDRAW 2 WEEKS PRIOR TO START DATE TO AVOID CHARGES
POLICY:
DESCRIPTIONS and OBJECTIVES for COURSE TTHAB-17
INTERMEDIATE MS-ACCESS 2.0
PREREQUISITES
o Introduction to Access
**Please note that your working experience along with an Intro to Access class
is vital to the success of this course**
DESCRIPTION
This class is designed for students who want to learn to query and create unique
expressions, use a filter to query a form, add and delete fields in forms and
reports, and move controls in forms and reports. In addition, students will
learn to edit and format label text in forms and reports, add unbound label
text, change the default settings, create an unbound control, create a tabular
form, create a report with grouped data, and create mailing labels. And moving
information between other programs.
COURSE OBJECTIVES
o Query and create forms from multiple tables
o Use expressions and operators in queries
o Perform calculations on data that you query
o Create unique expressions
o Use a filter to query a form
o Add and delete fields in forms and reports
o Move controls in forms and reports
o Edit and format label text in forms and reports
o Add unbound label text in forms and reports
o Change default settings for controls in forms and reports
o Create an unbound control in forms and reports
o Create a tabular form
o Create a report with grouped data
o Create mailing labels
COURSE OUTLINE
Querying Multiple Tables
o Understanding relational databases
o Setting the primary key
o Indexing a table
o Creating a relationship between two tables
o Setting up a query for multiple tables
o Showing information from multiple tables
Performing Calculations with queries
o Using expressions
o Performing Calculations
o Calculation operators
o Creating calculation fields
o Calculating totals in queries
o Including criteria in calculation queries
o Creating unique expressions
Working with filters
o Understanding filters
o Saving a filter
o Creating a filter from a query
Customizing forms
o Adding and deleting form fields
o Moving controls
o Separating controls and labels
o Editing label text
o Formatting label text
o Adding unbound label text
o Working with control properties
o Creating an unbound control
o Creating a tabular form
o Creating a form with a subform
Designing reports
o Creating a report with grouped data
o Modifying the design of the report
o Resizing report sections
o Changing sorting or grouping options
o Using expressions in a report
o Adding lines to a report
================================================================================
NOTES FILES and INFOBASES
================================================================================
KOOLIT::USER21:[PUBLIC.ATOOLS]
SES_FILES_READMEFIRST.TXT
Last Updated 6/8/95
Bookbuilding and Submission Using Word for Windows Version 6.x guide
=====================================================================
WFWV6_BOOKBUILDING_SUBMISSION_GUIDE.PS
5/31/95 "SES WFW Bookbuilding & Submission" seminar handouts
============================================================
ALL_HO.PS
Standards Documentation Listing
===============================
STANDARDS_DOCS.TXT A list of some of the available standards
documentation.
Standards documentation is contained in
the following directory:
GEMVAX::RIDER:[DOCSTDS]
SES/IDC Word for Windows Templates Files and User Guides
=========================================================
Filename Description Version, if applicable
-------- ----------- ----------------------
7X9HH_V2.DOT 7x9 Hanging Head Version 2.x
Template File
7X9HH_V6.DOT 7x9 Hanging Head Version 6.x
Template File
7X9MA_V2.DOT 7x9 Margin Art Version 2.x
Template File
7X9MA_V6.DOT 7x9 Margin Art Version 6.x
Template File
85X11_V2.DOT 8.5x11 Version 2.x
Template File
85X11_V6.DOT 8.5x11 Version 6.x
Template File
IDCUG_V2.PS Template User Guide Version 2.x
IDCUG_V6.PS Template User Guide Version 6.x
TEMPLATE_REL_NOTES.TXT Template Release notes Version 6.x
Digital Information Mapping Template
====================================
Filename Description Version, if applicable
-------- ----------- ----------------------
OFFRSGML.DOT 7x9 or 8.5x11 Version 2.x
Information Mapping
Template file
OFFRGUID.PS 7x9 or 8.5x11 Version 2.x
Information Mapping
User Guide
DEC.DOT 7x9 or 8.5x11 Version 6.x
Information Mapping
Template File
DECGUIDE.PS 7x9 or 8.5x11 Version 6.x
Information Mapping
User Guide
Print Drivers, and Related Files
================================
Filename Description Version, if applicable
-------- ----------- ----------------------
ADOBE.ZIP Adobe Print Driver Version 2.1.1
PKUNZIP.EXE PKUNZIP executable
WINDRIVER.PS Installing Windows Print Drivers
User Guide
Sample Word for Windows Documents
=================================
SAMPLE_AGENDA.PS Meeting announcment/agenda
Created using the Word for Windows V6.0c
agenda 'wizard'.
AGENDA.DOC Word for Windows source file for the
SAMPLE_AGENDA document.
SAMPLE_PLAN_SPEC.PS Sample project plan/specification document.
Created using Word for Windows V6.x and
the DEC.DOT template.
PLANSPEC.DOC Word for Windows source file for the
SAMPLE_PLAN_SPEC document.
Microsoft Word for Windows Help Files
=====================================
Filename Description
-------- -----------
2TEMPLTS.PS Using templates supplied with Word 1.x and 2.x
in Word 6.0
FIELDS.PS Fields; What's New with Fields
GPFAULT.PS Troubleshooting General Protection Faults
OPTIMIZE.PS How to Optimize the Performance of Word 6.0
SAVE6.PS Word 6.0 File Saving and SHARE.EXE issues
SETUP6.PS Word 6.0 Setup issues
WORD.PS New features of Version 6.x
WORDINI6.PS Word 6.0 WINWORD6.INI settings
WTIPNTRK.PS Word tips and techniques (volumne 1)
WTPNTRK2.PS Word tips and techniques (volumne 2)
Microsoft Word for Windows Internet Assitant
============================================
WORDIA.EXE Executable file for Word internet assistant
You must have Word for Windows Verion 6.0a
or later installed on your PC in order to
install and use the Internet Assistant.
PC Jobaids
==========
SUBJECT: PC Job Aids Available
----------------------------------------------------------------------
Overview The Technology and Tools PC team of the ID Resource
Group has developed several PC job aids. These job
aids will assist users with the following:
* Transferring files over the network
* Compressing and decompressing files
* Using the IDCLOGON procedure
* Using PATHWORKS
* Checking for viruses
The job aids have been reviewed and tested by the
team and by a system support representative. These
job aids are now available for your use.
NOTE: System and network configurations vary, so
these job aids may not be applicable in all cases.
Files H2WTXT.PS Text/PS Files HOME to WORK
W2HTXT.PS Text/PS Files WORK to HOME
W2HDOC.PS DOC/PPT Files WORK to HOME
IDCLOGON.PS Connecting to Network Using IDCLOGON
PATHWRKS.PS Connecting to Network Using PATHWORKS
PKUNZIP.PS Using PKUNZIP
PKZIP.PS Using PKZIP
INSFPROT.PS Installing F-PROT
USEFPROT.PS Using F-PROT
Descriptions The following table describes each job aid.
===========================================================================
Job Aid Title Description
===========================================================================
Transferring Files
---------------------------------------------------------------------------
Transferring .DOC or .PPT Describes the necessary steps to transfer a
Files from WORK to HOME Microsoft Word or PowerPoint file from your
W2HDOC.PS VMS account at work to your PC at home using
Kermit32.
Transferring .TXT or .PS Describes the necessary steps to transfer an
Files from WORK to HOME ASCII (text) or PostScript file from your
W2HTXT.PS VMS account at work to your PC at home using
Kermit32.
Transferring .TXT or .PS Describes the necessary steps to transfer an
Files from HOME to WORK ASCII (text) or PostScript file from your
H2WTXT.PS PC at home to your VMS account at work using
Kermit32.
===========================================================================
Job Aid Title Description
===========================================================================
Compressing and Decompressing Files
---------------------------------------------------------------------------
Using PKZIP Describes how to use the PKZIP command.
PKZIP.PS This command is used to compress large
files to conserve disk space. Typically you
would PKZIP a file or group of files which
creates a .ZIP file. You would do this to
transfer a number of files at one time. In
addition, you would pkzip a large file that
is too big to fit onto a diskette.
Using PKUNZIP The PKUNZIP command is used to decompress
PKUNZIP.PS or explode (unzip) a file that has been
zipped (by using PKZIP). Typically you
would pkunzip a .ZIP file.
Using the IDCLOGON Procedure
---------------------------------------------------------------------------
Connecting to the Network Describes an alternative method to using the
with IDCLOGON USE PATHWORKS command. The advantage to using
IDCLOGON.PS the IDCLOGON and AUTOEXEC.BAT files is that
you are identified as the owner of:
* PC files on a VMS cluster and have control
over the file protection
* Print jobs from PC to a networked printer:
- View the files in the print que using VMS
- Delete print jobs using VMS
- User name appears on print header page
Using PATHWORKS
---------------------------------------------------------------------------
Using PATHWORKS to Describes how to use PATHWORKS V4.0, 4.1,
Connect to a VMS System and 4.2 to connect to a VMS system. Using
PATHWRKS.PS PATHWORKS allows users to access directories,
applications, and printers on a VMS system.
Checking for Viruses
---------------------------------------------------------------------------
Installing F-PROT Describes how to install F-PROT and how to
INSFPROT.PS use it. F-PROT is the official Digital
checking softtware. It detects and disinfects
Using F-PROT various types of viruses on the local disk
USEFPROT.PS and on diskettes.
============================================================================
Questions If you have comments or suggestions regarding these
PC job aids, please post a reply to note 279 in the
IDC Notes Conference.
| T.R | Title | User | Personal
Name | Date | Lines
|
|---|