CFR Systems Computer Training

 

Courses for November 2003

Our Training Courses are grant assisted to 100% by Scottish Enterprise Borders, making them excellent value for money.  A range of courses, outlined below, are available during the last week in February, if you are interested in reserving a place please phone or e-mail for further information;

 Small Business Gateway:    0845 6096611  for bookings.

Courses for November 2003

Held in Duns, 36 Market Square

* 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

 [go top]

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

[go top]

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

 [go top]

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

 [go top]

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  

 [go top]

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

 [go top]

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

 [go top]

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

Copyright CFR Systems. All rights reserved.
Last revised: February 25, 2004