The Cheltenham Courseware 'Computer Courseware Library'

Consider investing in a complete library of computer courseware titles. We provide the computer training materials, you deliver the IT training. A low one-off investment gives you over 150 course titles inc, Windows Vista and Microsoft Office 2007 courseware. There is a separate ECDL / ICDL Courseware Library available. Train as many people as you like for as long as you like. SIMPLE!

Don't just get one course, get over 150 courses as a complete 'Computer Courseware Library'. We provide the courseware, you deliver the training Details

Microsoft Office 2007 Courseware

Windows Vista Courseware

ECDL 4.5 / ICDL 4 Courseware
European Computer Driving Licence

Windows XP Courseware

Microsoft Office 2003 Courseware

Microsoft Office XP Courseware

Other courses

Microsoft Access 2007
Foundation Level Training Courseware

Training Course Outline.

Access 2007 | FIRST LOOK

Creating and opening an Access database.
Using views.
Modifying settings within Access
Using the Access Help facility

ACCESS 2007 | DATABASE CONCEPTS

What is a database?
What is a relational database?
Tables
Records
Fields
Field data types
Field properties
Primary key
Index
Table relationships
Setting rules to ensure valid relationships

Access 2007 | TABLES

Creating and saving a table
Specifying field data types.
Adding and deleting records
Adding fields
Modifying data within a record.
Navigating within a table
Deleting a table.
Defining Keys
Defining a Primary key.
Indexing a field with or without duplicates allowed.
Changing field format attributes
Simple validation rules
Creating a one-to-one and a one-to-many relationship
Deleting relationships
Applying rules to relationships

Access 2007 | FORMS

Creating, opening, saving deleting and closing forms.
Navigating through records
Form headers and footers.

Access 2007 | QUERIES

Finding data within a field.
Applying a filters
Creating and saving a single table query
Use two table querys
Using operators within queries
Editing, running and deleting a query.
Saving and closing a query.
Sorting records

Access 2007 | REPORTS

Creating and saving a report
Grouping data under a specific field
Displaying fields in a grouped report
Headers, Footers

Access 2007 | PRINTING ISSUES

Previewing a table, form or report
Changing orientation and paper size
Printing options within Access

Why write your own computer training manuals?
Save time, effort and money and get all the training courses you need from Cheltenham Courseware.
We write the computer training materials - You concentrate on delivering IT training.