Course Outlines

For a list of all courses and a brief outline for each, see below.

All courses at SystemCraft include:
Morning tea, lunch and afternoon tea. (Please let us knowof any special catering requirements.)
A bound manual with step by step instructions and exercises.
A Certificate of Achievement.
Attendees are entitled to four weeks of telephone support up to the level of the course attended .
Underground secure parking is available.

Course Durations and times:
All courses run for one full day. Microsoft Application courses run from 9:30am to 5:00pm, and all others run from 9am to 5pm.

Payment Terms:
Courses must be paid in full before the course commencement date.

Confirmation:
We will confirm your booking by letter.Request to cancel or transfer a booking must be sent in writing, by mail or fax. You may cancel any time up to five working days prior to the course commencement date. Substitutions can be made up to the course starting date. The minimum number of participants to each course is 4. In the event of not reaching the minimum number of enrolments, Systemcraft reserves the right to re-schedule a date for the course to take place.


Courses Offered: Access 97 Intro Access 97 Advanced Access 2000 Intro Access 2000 Advanced Excel 97 Intro Excel 97 Advanced Excel 2000 Intro Excel 2000 Advanced Frontpage98 Intro GroupWise Client	NetWare Administrator Powerpoint 2000 Intro SES Administrator Outline Windows 95 Intro Windows 98 Intro Word 97 Intro Word 97 Advanced Word 2000 Intro Word 2000 Advanced


Access 97 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to databases. It will teach you the basic skills to create and use a database system. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to databases - Screen elements, menus, toolbars, shortcut menus, Undo, Help and the Office Assistant - Entering and editing data - Creating a database and using the Database Wizard - Creating tables with the Table Wizard or intelligent tables - Autoform, Form Wizard, Autoreport, Report Wizard - Creating a Select Query - Relationships and creating a table in Design View - Moving, copying, renaming and deleting - Column widths, row heights and fonts - Field properties, Field builder and working in Table Design View - Lookup Wizard - Finding, replacing and sorting data - Working with controls in forms and reports - Simple reports and mailing labels Previous Knowledge: Students should already be familiar with PCs and Windows but no database experience is necessary.


Access 97 (Advanced)	list of courses \| top of page
Description: This workshop is designed for people who are already familiar with the basic features of Access 97. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Relationships, primary key, referential integrity and joins - AutoLookup, filtering and indexes - Field and table properties - Operators, expressions and functions - Calculations in forms and reports - Selecting records in queries - Multi-table formsForm properties, form sections, form tabs and form appearance - Option groups, combo boxes and command buttons - Creating forms and reports without a Wizard - Sorting and grouping - Form letters with Access and Word - Importing, exporting and attaching - Creating, running and editing macros - Command buttons and customised toolbars Previous Knowledge: Students should already have completed an Introductory course in the basic features of Access 97. They should also have practical experience in using the product.


Access 2000 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to databases. It will teach you the basic skills to create and use a database system. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to databases - Screen elements, menus, toolbars, shortcut menus, Undo, Help and the Office Assistant - Entering and editing data - Creating a database and using the Database Wizard - Creating tables with the Table Wizard or intelligent tables - Autoform, Form Wizard, Autoreport, Report Wizard - Creating a Select Query - Relationships and creating a table in Design View - Moving, copying, renaming and deleting - Column widths, row heights and fonts - Field properties, Field builder and working in Table Design View - Lookup Wizard - Finding, replacing and sorting data - Working with controls in forms and reports - Simple reports and mailing labels Previous Knowledge: Students should already be familiar with PCs and Windows but no database experience is necessary.


Access 2000 (Advanced)	list of courses \| top of page
Description: This workshop is designed for people who are already familiar with the basic features of Access 2000. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Relationships, primary key, referential integrity and joins - AutoLookup, filtering and indexes - Field and table properties - Operators, expressions and functions - Calculations in forms and reports - Selecting records in queries - Multi-table formsForm properties, form sections, form tabs and form appearance - Option groups, combo boxes and command buttons - Creating forms and reports without a Wizard - Sorting and grouping - Form letters with Access and Word - Importing, exporting and attaching - Creating, running and editing macros - Command buttons and customised toolbars Previous Knowledge: Students should already have completed an Introductory course in the basic features of Access 2000. They should also have practical experience in using the product.


Excel 97 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to spreadsheets. It covers the essential features people need in day-to-day use of Excel. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to spreadsheets and terminology - Components of the Excel screen - Moving around a worksheet and selecting cells - Entering text, numbers and formulas - Editing data, undo, redo and repeat - Drag and drop, cut, copy and paste - Adjusting column widths and row heights - Aligning data, choosing fonts and number formats - AutoSum, AutoFill, AutoCalculate and AutoFit - Creating simple charts - Common functions - Automatic and manual calculation - Finding and replacing data - Borders, shading, AutoFormat and Format Painter - Locating and managing files Previous Knowledge: Students should already be familiar with PCs and Windows 95 but no spreadsheet experience is necessary.


Excel 97 (Advanced)	list of courses \| top of page
Description: This workshop is designed for people who are already familiar with the basic features of Excel 97. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Styles and templates - Ranges, array formulas and Paste Special - Changing defaults, options, customising toolbars and number formats - Hiding worksheets, rows & columns and zeros - Sorting and finding records - What-if analysis - Look-up tables and data tables - Protecting files, workbooks, worksheets and cells - Editing and formatting charts - Creating, editing and updating links in worksheets - Pivot tables - Database functions, sub-totals, grand totals and the Conditional Sum Wizard - Introduction to macros - Analytical tools such as goal seeking and Solver Previous Knowledge: Students should already have completed an introductory course in the basic features of Excel 97. They should also have practical experience in using the product.


Excel 2000 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to spreadsheets. It covers the essential features people need in day-to-day use of Excel. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to spreadsheets and terminology - Components of the Excel screen - Moving around a worksheet and selecting cells - Entering text, numbers and formulas - Editing data, undo, redo and repeat - Drag and drop, cut, copy and paste - Adjusting column widths and row heights - Aligning data, choosing fonts and number formats - AutoSum, AutoFill, AutoCalculate and AutoFit - Creating simple charts - Common functions - Automatic and manual calculation - Finding and replacing data - Borders, shading, AutoFormat and Format Painter - Locating and managing files Previous Knowledge: Students should already be familiar with PCs and Windows 95 but no spreadsheet experience is necessary.


Excel 2000 (Advanced)	list of courses \| top of page
Description: This workshop is designed for people who are already familiar with the basic features of Excel 2000. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Styles and templates - Ranges, array formulas and Paste Special - Changing defaults, options, customising toolbars and number formats - Hiding worksheets, rows & columns and zeros - Sorting and finding records - What-if analysis - Look-up tables and data tables - Protecting files, workbooks, worksheets and cells - Editing and formatting charts - Creating, editing and updating links in worksheets - Pivot tables - Database functions, sub-totals, grand totals and the Conditional Sum Wizard - Introduction to macros Previous Knowledge: Students should already have completed an introductory course in the basic features of Excel 2000. They should also have practical experience in using the product.


FrontPage 98 (Introduction)	list of courses \| top of page
Description: This practical workshop is designed for people who are new to Frontpage. It will teach you how to create and publish web sites. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to FrontPage 98 and its major elements - FrontPage Explorer - FrontPage Editor - Creating a New Web with a Wizard - Creating a New Web from Scratch - Inserting text from existing documents into Web pages - Enhanced Layout with Tables and Frames - Page layout with page templates and use of tables - Incorporating graphics into your Web pages - Repeating "standard" information on each page using frames - Editing Existing Webs & Using Navigation Bars - Importing a partially completed Web from an Intranet Creating a dynamic navigation scheme with Navigation Bars - Recording the number of times your Web site is accessed with a Hit Counter - Soliciting feedback about your Web with a Feedback Form - Finding and repairing broken hyperlinks - Removing unwanted Webs from FrontPage Previous Knowledge: You should have Windows 95 knowledge and have experience with a Web browser.


Groupwise Client	list of courses \| top of page
Description: Description?? Course Content: - Content?? Previous Knowledge: Previous Knowledge??


Netware Administrator	list of courses \| top of page
Description: Description?? Course Content: - Content?? Previous Knowledge: Previous Knowledge??


Powerpoint 2000 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to presentation graphics. It covers the essential features people need in day-to-day use of Powepoint. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to presentation graphics - Working with each of Powerpoint's views - Screen elements, shortcut menus, toolbars, zoom, help - Creating a new presentation, adding slides and the AutoContent Wizard - Working with text - Editing and formatting a presentation - Changing the slide layout and selecting a template - Slide setup, printing and the spelling checker - Drawing simple objects, AutoShapes and clip art - Format Painter, colours, lines, patterns and shading - Colour schemes and background colours - Editing the Slide Master - Slide shows including transitions, timings, animation effects, the Slide Navigator and hidden slides - Graph concepts, terminology, data sheets & chart types - Organisation charts - Editing graphic objects and clip art Previous Knowledge: Students should be already be familiar with PCs and Windows but no presentation graphics experience is necessary.


SES Administrator	list of courses \| top of page
Description: Description?? Course Content: - Content?? Previous Knowledge: Previous Knowledge??


Windows 95 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to Windows. It gives a comprehensive introduction to Windows 95 and will enable students to become productive with the product. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to PCs and Windows - Working with menus, shortcut menus and toolbars - Starting and leaving Windows - Desktop icons and shortcut icons - Taskbar, Start button, Start menu - Switching between applications - Maximising, minimising, restoringMoving and re-sizing windows - Tiling and cascading - Moving and copying with the Clipboard and drag and drop - Working with files and folders - Help and Wizards - File management - Find command - My Computer and Windows Explorer - Recycle bin - Printing and controlling print jobs Previous Knowledge: This course does not assume any prior knowledge of computers or Windows. However, it would be beneficial to have experience with a keyboard.


Windows 98 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to Windows. It covers the essential features people need in day-to-day use of Windows. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Starting and leaving Windows - Dialogue boxes, windows, taskbar, menus, mouse, shortcut menus, shortcut keys, toolbars and icons - Moving, copying, drag and drop and the Clipboard - Resizing, tiling and cascading - Help, Wizards and undo - My Computer - Windows Explorer - Recycle bin and finding files - Printing and controlling print jobs - Control panel, properties and desktop shortcuts - WordPad and Paint - Outlook Express - DOS programs, Run command, multimedia, Notepad - Explorer Bar, thumbnails, shortcurts, Quick View, Clipboard Viewer and scraps - Hard disk maintenance, anti-virus software and backups Previous Knowledge: Students should already be familiar with PCs but no operating system experience is necessary.


Word 97 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to word processing. It covers the essential features people need in day-to-day use of Word. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to word processing - Viewing modes, screen elements, toolbars, ruler, zoom, shortcut menus, Help and the Office Assistant - Opening, saving and closing a document - Typing text, selecting text, tabs, indents and page breaks - Moving and copying text - Character formatting - Paragraph formatting such as indenting and alignment - Undo, Repeat and Redo - Printing and Print Preview - Locating and managing files - AutoText, Autoformat, templates and the Letter Wizard - Format painter, paragraph spacing, line spacing and setting tabs - Merging with a mailing list - Section breaks, margins and paper size - Creating and formatting tables Previous Knowledge: Students should already be familiar with PCs and Windows95 but no word processing experience is necessary.


Word 97 (Advanced)	list of courses \| top of page
Description: This workshop is designed for people who are already familiar with the basics features of Word 97. It will enable students to realise the full potential of the product. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Creating, editing and using templates - Controlling page breaks - Creating and using forms - Creating and formatting text columns - Changing the structure of tables - Formulas in tables - Envelopes, labels, drop caps and coloured text - Highlighter, document properties and symbols - Sorting tables and text - Special Effects with drawings, WordArt and watermarks - Creating, editing and applying styles - Merging with mailing labels - Filtering and sorting in a merge - Recording, running and editing simple macros - Table of contents and cross-references - Working with section breaks and page numbers - Master Documents Previous Knowledge: Students should already completed an introductory course in the basic features of Word 97. They should also have practical experience using the product.


Word 2000 (Introduction)	list of courses \| top of page
Description: This workshop is designed for people who are new to word processing. It covers the essential features people need in day-to-day use of Word. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: - Introduction to word processing - Viewing modes, screen elements, toolbars, ruler, zoom, shortcut menus, Help and the Office Assistant - Opening, saving and closing a document - Typing text, selecting text, tabs, indents and page breaks - Moving and copying text - Character formatting - Paragraph formatting such as indenting and alignment - Undo, Repeat and Redo - Printing and Print Preview - Managing files and using Collect and Paste - AutoText, Autoformat, templates and the Letter Wizard - Format painter, paragraph spacing, line spacing and setting tabs - Merging with a mailing list - Headers and footers, margins and paper size - Creating and formatting tables Previous Knowledge: Students should already be familiar with PCs and Windows 95 or 98 but no word processing experience is necessary.


Word 2000 (Advanced)	list of courses \| top of page
Description: This workshop is designed for people who are already familiar with the basics features of Word 2000. It will enable students to realise the full potential of the product. You will have your own individual PC, and work through with a highly experienced trainer. Course Content: Creating, editing and using templates Controlling page breaks Creating and using forms Creating and formatting text columns Formulas in tables Envelopes, labels, drop caps and coloured text Highlighter, document properties and symbols Sorting tables and text Autoformat, WordArt and watermarks Creating, editing and applying styles Merging with mailing labels Filtering and sorting in a merge Recording, running and editing simple macros Table of contents and cross-references Multi-level numbering for paragraph and headings Working with section breaks, headers and footers Master Documents Previous Knowledge: Students should already completed an introductory course in the basic features of Word 2000. They should also have practical experience using the product.