Learn the basics of this database program. The course provides you with all the basic tools you need as an Access user.

 Basic Windows knowledge required

Topics:

  

Concepts and Access
What is Data? 
What is a Database? 
Basic Concepts The Telephone 
Directory - An Example of a Database
Tables and Relationships 
Types of Relationships 
Why Use an Electronic Database? 
Why Use Access? 

 An Introduction to Access
 Introducing Access Tools 
Starting Microsoft Access 
The Access Application Window 
Concepts, Terminology and Usage
Opening a Database
The Access Database Window
Closing a Database
Opening a Table
The Table Window
Exploring the Table
Table Design View
Introducing Queries
Introducing Forms
Types of Form
Opening an Existing Form
Form Design View
Introducing Reports

Database Design 
Design a Database
Questions To Ask Yourself
Define Your Needs
Basic Design Rules
Determine Relationships
Creating a Database
Using the Table Wizard
Adding Fields Using the Table Wizard
Creating a Table Without a Wizard
Adding Fields to a New Table
Field Properties
The Input Mask Property
Setting a Primary Key
Saving a Table
Adding Records to a Table Datasheet

Formatting an Access Table
Editing Records
Selecting Records With The Mouse
Selection Using The Keyboard
Selecting Fields With The Mouse
 
Selecting Columns Using the Mouse
Deleting Records and Fields
Viewing Datasheet Default Values
Re-ordering Columns Within a Table
Re-Ordering Fields in the Table
Changing Column Width & Row Height
Hiding and Un-hiding Columns
Freezing Columns
Formatting Datasheet Cells
Changing Datasheet Fonts
Copying and Moving Fields & Records
Another Look at the Database Window
Printing

Locating and Replacing Information 
A Simple Search
Wildcards
Finding Specific Values
Find and Replace
Sorting Records
What is a Filter?
Filtering Records By Selection
Filtering Records By Form

Creating Simple Queries
What are Queries?
Opening an Existing Query
Creating Queries, 
Using the Simple Query Wizard
Queries & the Wizard
The Query Grid

Introducing Forms
Introduction to Forms 
Basic Form
Layout Types 
Creating a Form
Using AutoForm
Creating a Form
Using the Form Wizard
Different Waysof Viewing Form

Reports 
Introduction to Reports 
Opening and Viewing Reports
Printing Reports
Creating a Report 
Using AutoReports
Creating Reports 
Using the Report Wizard
 

 

 
  

Method:

Hands on computer use. Individual computer for each participant. Manual provided.

Duration:

3 hours (Access Level One 2007 is 2 x 3 hours)

(One/two daytime session or one/two evening session of 3 hours)

Price:

$225/(450 for 2007 V)  (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 

 

 

If you need to improve on your existing Access skills this course is ideal. Manipulating Forms, Reports and Switchboards are some of the topics included.

Basic Access knowledge required – Attending the Access Intro course would be a major advantage

Topics:
Relationships
Defining Relationships
Opening the relationship window
Adding tables to the relationship window
Making relationships
Referential integrity
Editing relationships

More on Queries
Logical operators in queries
Text in Criteria - wildcards
Multiple criteria and alternative criteria
Calculated fields
Summary queries
Update queries
Append queries
Make-table queries
Creating Calculated fields
Using the expression builder

More about creating forms
Creating forms without using the form wizard

The form design view window
Manipulating form design
Types of control

The toolbox
Creating a combo box control
Changing form properties
Using forms with sub-forms
Creating a form with a sub form
Controlling data input
Changing tab order
Adding command buttons
Adding page breaks
Switchboards

More on Reports
Using the label wizard
Using the chart wizard
Grouping levels in reports
Creating a report without a wizard
Creating controls
Setting properties

 

 

Method:

Hands on computer use. Individual computer for each participant. Manual provided.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 

 

 

Participants will require a sound understanding in the use and creation of an Access relational database.

Beyond basic database creation incorporates the following advanced topics.

Intermediate Access knowledge required

Topics:

· Advanced Table and Queries

Ø Inserting Objects and Links to Tables

Ø Advanced Select Queries

Ø Action Queries

· Advanced Forms

Ø Using Form Wizards

Ø Properties of Forms

Ø Using Controls

Ø Form Templates

· Advanced Reports

Ø Advanced Reports

Ø Subreports

Ø Multiple Column Reports

Ø Saving Reports as HTML

· Working with Macros

Ø What is a Macro?

Ø Events and Macros

Ø Using Conditions in Macros

· Database Administration

Ø Working in Multi-User Environments

Ø Converting Databases

· Database Security

Ø The Access Security Model

Ø Setting a Database Password

Ø Securing your Database

Method:

Hands on computer use. Individual computer for each participant. Manual provided.

Duration:

6 hours

(Two daytime session or two evening session of 3 hours)

Price:

$450 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 

  

Learn the basics of this powerful spreadsheet program. This course provides you with all the basic tools you need.

 Basic Windows knowledge required

Topics:

WHAT IS EXCEL?
Microsoft Excel 2003
Using Excel as a Spreadsheet
Using Excel as a Database
Analyzing Data
Microsoft Web Site
EXCEL FILE TYPES
Spreadsheet files
Online Publishing files
XML files
Template files
EXCEL ENVIRONMENT
Working with the Excel window
Using the Formula Bar
Using the Task Pane
Using the New Workbook Pane
Using the Clipboard Pane
Using the Basic Search Pane
Using the Insert Clip Art Pane
Using the Status Bar
Exiting Excel 2003
TOOLBARS
Using Toolbars
Showing a Toolbar
Hiding a Toolbar
Moving a Toolbar
Using the Standard Toolbar
Using the Formatting Toolbar
OFFICE ASSISTANT
Understanding the Microsoft Office Assistant
Using Tips of the Day
Displaying the Office Assistant
Displaying Tips
Hiding the Office Assistant
Customizing the Office Assistant


WORKBOOKS AND WORKSHEETS
CREATING AND OPENING WORKBOOKS
Creating a new Workbook
Creating a new Workbook using a template
Opening an existing Workbook
WORKING WITH WORKBOOKS
Understanding Workbooks and Worksheets
Minimizing a Workbook
Saving Workbooks
Saving a backup copy
Saving Summary Information
Closing Workbooks
WORKING WITH WORKSHEETS
Zooming the Worksheet View
Renaming Worksheets
Changing the Sheet Tab color
Inserting Worksheets
Reordering Worksheets
Deleting Worksheets
Customizing Worksheet Views
WORKING WITH CELLS
Understanding Cells and Ranges
Understanding the Active Cell
NAVIGATING WITHIN A WORKSHEET
Navigating to a specific Cell
Moving around the Worksheet
Moving within a selection
NAVIGATING THE WORKBOOK
Navigating between Worksheets using the mouse
Moving between Worksheets using the keyboard
Moving from one Workbook to another

Method:

Hands on computer use. Individual computer for each participant. Manual provided.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 

 

If you need to improve on your existing Excel skills this course is ideal. Charts and Formula and Function Wizards are some of the topics included.

Basic Excel knowledge required

Topics:

· Working With Large Worksheets

Ø Viewing, Customising and Printing

Ø Common Excel Functions

Ø Auditing

· Productivity Tools

Ø Creating Templates

Ø Data Consolidation

Ø AutoCorrect and AutoComplete

Ø Search and Replace

Ø Workbook, Worksheet and Cell Protection

· Working With Lists

Ø Maintaining, Sorting and Filtering Lists

Ø Subtotalling

Method:

Hands on computer use. Individual computer for each participant. Manual provided.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 

 

If you need to edit and analyze complex data or incorporate complex built-in functions this course will provide you with these advanced skills.

 Intermediate Excel knowledge required

Topics:

· Templates and Styles

· Importing Data

· 'What If' utlities including Pivot Tables

· Macros and Custom Controls

· Macros

· Security and Proofing

· Consolidation

Method:

Hands on computer use. Individual computer for each participant. Manual provided.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 

Learn how to design, create and manage attractive, eye catching web sites.

Basic Word Processing and Graphic Design Skills Required

Topics:

· The Internet and the WWW

· Getting Started

· Planning a web

· Viewing a Web

· Creating a Web

· Creating Pages

· Editing Text

Method:

Hands on computer use. Individual computer for each participant.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 

Learn how to design, create and manage attractive, eye catching web sites.

Intro to FrontPage 2003 required

Topics:

· Enhancing your pages

· Hyperlinks

· Standardizing page formats

· Using Images

· Using Components

· Using Forms

· Publishing a web

· Course Workshop

Method:

Hands on computer use. Individual computer for each participant.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 Requites:

Learn how to use Outlook in an office environment to manage your day to day communication requirements.

Internet/Email introduction course Required

Topics:

· Introduction to Outlook 2003

· Contacts Folder

· Electronic mail

· Calendar folder

· Tasks folder

· Outlook today folder

· Journal folder

· Notes folder

· Deleted items folder

Method:

Hands on computer use. Individual computer for each participant.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice

 

 

 Requites:

Learn how to use MS Word 2007 in an office environment to manage your day to day document requirements.

Basic Computer Skills or Introduction to Computer

Topics:

· Setting MS Word 2007 Options

· Creating a New Document

· Open and Exisiting Document

·Type text into a Document

· Edit Text

· Move around a Document

· Find and Replace Text

· Check a Document's Spelling and Grammar

· Print a Document

Method:

Hands on computer use. Individual computer for each participant.

Duration:

3 hours

(One daytime session or one evening session of 3 hours)

Price:

$225 (GST INCLUSIVE)

Course details including dates, times and prices are subject to change without notice