Courses for December 2004
Held in Duns, 36 Market Square
| Course Title | Date | Course Times |
| Introduction to Microsoft Word - Word 1 | Thursday, 2nd December | 9.30am - 12.30pm |
| Introduction to Microsoft Word - Word 2 | Thursday, 2nd December | 1.30pm - 4.30pm |
| Introduction to Microsoft Access - Access 1 | Friday, 3rd December | 9.30am - 12.30pm |
| Introduction to Microsoft Access - Access 2 | Friday, 3rd December | 1.30pm - 4.30pm |
| Workshop Session | Monday, 6th December | 1.30pm - 4.30pm |
| Introduction to Microsoft Excel - Excel 1 | Tuesday, 7th December | 9.30am - 12.30pm |
| Introduction to Microsoft Excel - Excel 2 | Tuesday, 7th December | 1.30pm - 4.30pm |
| Introduction to Email | Wednesday, 8th December | 9.30am - 12.30pm |
| Intermediate Microsoft Word - Word 3 | Wednesday, 8th December | 1.30pm - 4.30pm |
| Intermediate Microsoft Excel - Excel 3 | Thursday, 9th December | 9.30am - 12.30pm |
| Workshop Session | Thursday, 9th December | 1.30pm - 4.30pm |
* All participants receive a
notes booklet to accompany each course.
Synopsis for Training Courses
This course is designed to provide the basic skills required to understand e-mail. It is designed for those recently connected to the Internet and/or would like to understand how e-mail works.
PROGRAMME
1.
Introduction
2.
What is -E_Mail?
2.1. Description
2.2. Components
of the Internet
2.3. The
Internet Explosion
3.
Getting connected?
3.1. Computer
3.2. Modem
3.3. Telephone
Line
3.4. Finding
an ISP
3.5. Time
3.6. Software
4.
E-Mail
4.1. E-mail
Addresses
4.2. Customising
your E-mail software
4.2.1. Setting up
Accounts
4.2.2. Columns
4.2.3. Address Book
4.3. Sending
and Receiving E-mail
4.4. Attachments
4.5. Forwarding
and Replying to Messages
4.6. Managing
E-mails
4.6.1. Inbox Assistant
4.7. Web
Based E-Mail
Microsoft Word 97/2000 will be used for this course which is designed to provide the basic skills required to understand your word processor. Topics that will be covered include:
PROGRAMME
1.
Introduction to Word Processing
2.
Getting Started
2.1.
Title Bar
2.2.
Menu Bar
2.3.
Toolbars
2.4.
Ruler
2.5.
Status Bar
2.6.
Scroll Bars
2.7.
View Options
3.
Creating and Saving a Document
3.1.
“Save” v’s “Save As”
4.
Editing a Document
4.1.
General Points to Note
4.2.
Moving around a document
4.3.
Editing a Document
4.4.
Selecting/Highlighting Text using the Mouse
4.5.
Spelling and Grammar
5.
Enhancing Your Work
5.1.
‘Formatting’ Toolbar
5.2.
Styles
5.3.
Fonts
5.4.
Bold, Italic, Underscore, Highlight
5.5.
Alignment
5.6.
Bullet Points and Numbered Lists
5.7.
Indenting Text
5.8.
Borders and Shading
5.9.
Tabs
5.10.
Paragraph spacing
6.
Views
7.
Printing
7.1.
Print Preview
7.2.
Page Setup
7.3.
Printing Envelopes
Introduction to Word (2) -
˝day
Microsoft Word 97/2000 will be used for this course which is designed to provide the skills required to get more out of your word processor. Topics that will be covered include:
PROGRAMME
1. Introduction
2. Drawing Tools
3. Adding Illustrations
3.1 Scaling an image
3.2 Applying a border to an image
4. Styles
5. Symbols
6. Auto Correcting
6.1 Auto format as you type
6.2 Auto text
7. Custom Dictionaries
8. Page Breaks & Section Breaks
9. Working with Large Documents
9.1 Table of Contents
9.2 Footnotes
10. Tracking Changes
Intermediate Word (3) -
˝day
Microsoft Word 97/2000 will be used for this course which is designed to provide the skills required to get more out of your word processor. Topics that will be covered include:
PROGRAMME
1.
Introduction
2.
Enhancing Your Work
2.1.
Columns
2.2.
Headers and Footers
2.3.
Sections
3.
Tables
3.1.
Selecting Data in a Table
3.2.
Sizing Columns and Rows
3.3.
Auto Format
3.4.
Manually Formatting a Table
3.5.
Inserting Rows and Columns
3.6.
Deleting Rows and Columns
3.7.
Merging and Splitting Cells
4.
Templates
4.1.
Creating a Document based on a Template
4.2.
Creating Your Own Template
5.
Mail Merge
5.1.
Main Document
5.2.
Data Source
5.3.
Merge
6.
Settings
Microsoft Excel 97/2000 will be used for this course which is designed to provide the basic skills required to understand your spreadsheet package. Topics that will be covered include:
PROGRAMME
1.
What is a Spreadsheet
1.1.
Spreadsheet Terminology
2.
Spreadsheet Design
3.
Spreadsheet Window
3.1.
Spreadsheet Elements
4.
Moving Around a Spreadsheet
5.
Entering Data
5.1.
Text- Labels
5.2.
Numbers - Values
5.3.
Formulas
5.4.
Entering Series
6.
Editing a Spreadsheet
7.
Formatting
8.
Saving a document
9.
Printing
Introduction to Excel (2)
- ˝day
Microsoft Excel 97/2000 will be used for this course which is designed to provide the skills required to get more out of your spreadsheet package. Topics that will be covered include:
PROGRAMME
1.
Introduction
2.
Navigating around large spreadsheets
2.1. Scroll
Bars
2.2. Zoom
2.3. Freeze
Titles
2.4. Split
Box
3.
Cell Reference
3.1. Relative
Cell Reference
3.2. Absolute
Cell Reference
4.
Working with Large Spreadsheets
5.
Sorting Data
6.
Charting
7.
Default settings
Intermediate Excel (3)
- ˝day
Microsoft Excel 97/2000 will be used for this course which is designed to provide the skills required to get more out of your spreadsheet package. Topics that will be covered include:
PROGRAMME
1.
Introduction
2.
Multiple Sheets
2.1. Rename a Worksheet
2.2. Copy a Worksheet
2.3. Move a Worksheet
2.4. Delete a Worksheet
2.5. Entering Data
2.6. Cell Referencing
3.
Advanced Formula
3.1. Sumif
3.2. Countif
3.3. If, Then, Else Formula
3.4. Calculation Operators in Formulas
3.5. Logical Functions
3.6. Mod
3.7. Int
3.8. Round
3.9. Is Functions
3.10. Conditional Formatting
3.11. Common Error Messages
4.
Importing Data
5.
Data Handling
5.1. Using Filters
5.2. Data Form
6.
Worksheet Options
6.1. Automatically Open a Worksheet When Excel Starts
6.2. Hiding a Row/Column
6.3. Comments
6.4. Tracking Changes
7.
Protecting Sheets
7.1. Limit Viewing and Editing of a Individual Worksheet
7.2. Limit Changes to an Entire Workbook
7.3. Password Protection
8.
Exporting to Word
8.1. Copy Cells to a Word Document
9.
Advanced Printing Options
9.1. Scaling
9.2. Fit To
9.3. Set Print Area
9.4. Gridline
9.5. Print Titles
9.6. Headers & Footers
10. Default Settings
Microsoft Access 97/2000 will be used for this course which is designed to provide the basic skills required to be able to create a simple database. Topics that will be covered include:
PROGRAMME
1.
What is a Database?
2.
Designing Your Database
3.
Database Terminology
3.1. Relational
Database
3.2. One-to-Many
3.3. One-to-One
4.
Creating a New Database
4.1. Database
Window
4.2. Creating
Tables
4.2.1. Field Name
4.2.2. Data Type
4.2.3. Description
4.3. Field
Properties
4.3.1. Format
4.3.2. Input Mask
4.3.3. Caption
4.3.4. Default Value
4.3.5. Validation Rule and
Text
4.3.6. Required
4.3.7. Allow Zero Length
4.3.8. Indexed
4.4. Primary
Key
5.
Adding Records
5.1. Deleting
Records
5.2. Editing
Records
6.
Sorting & Finding Data
6.1. Sorting
6.2. Finding
7.
Filtering
Introduction to Access (2) -
˝day
Microsoft Access 97/2000 will be used for this course which is designed to provide the skills required to be able to manage data in your database. Topics that will be covered include:
PROGRAMME
1.
Introduction
2.
Forms
2.1. Creating
Forms
2.2. Form
Controls
2.3. Form
Properties
2.4. Customising
Forms
3.
Queries
3.1. Creating
a Query
3.2. Calculations
in Queries
3.3. Summarising
Data
3.4. Printing
a Query
4.
Reports
4.1. Creating
Reports
4.2. Customising
Reports
4.2.1. Report Header and
Footer
4.2.2. Page Header and
Footer
4.2.3. Detail
4.2.4. Other Sections
4.3. Sorting
and Grouping
4.4. Toolbox
4.5. Field
List
5.
Office Links
5.1.
Mail Merge with MS Word
6.
Default Settings
These sessions are limited to 2 people and tailored to suit the requirements of the participants. Requirements, covering up to 4 areas, for these sessions need to be notified at least one week in advance of the session.
Contact us to find out more information about any of these courses or to discuss any specific training needs that you have.
Email: training@cfrsystems.co.uk