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

ECDL Module Five

The European Computer Driving Licence

Databases

1. USING THE APPLICATION

DATABASE CONCEPTS

What is data?

What is a database?

What is a relational database?

What is a table?

What is a record?

What is a field?

What is meant by 'Field data types'?

What is meant by 'Field properties'?

What is a primary key?

What is an index?

Why relate tables?

Design and document your database!

Questions to ask yourself

Define your needs

Basic design rules

FIRST STEPS WITH DATABASES

To start Access

To close Microsoft Access

To open a database

To create a new database

To save a database

To save a database file to a diskette

What is the Microsoft Office Assistant?

To display the Microsoft Office Assistant

To hide the Microsoft Office Assistant

To disable the Microsoft Office Assistant

To use "What is this" Help

The Help drop down menu

Help Menu - Microsoft Access Help command

Help Menu - Office on the Web

Help Menu - Activate Product

Help Menu - Detect and Repair

Help Menu - About Microsoft Access

To close a database

ADJUST SETTINGS

To switch between views when using tables, forms or reports

To switch between Design and Datasheet View

To display or hide a toolbar (using the View menu)

To display or hide a toolbar by right-clicking

2. TABLES

MAIN OPERATIONS

To create a table and specify field data types.

To add records to a table.

To delete records within a table

To add a field to an existing table.

To add data to a record

To modify data within a record

To delete data within a record

To use the Undo command

To navigate through a table to edit records

To move to a field using the mouse

To move through the table using the keyboard

To move from record to record using the scroll bar and mouse

To move to a specific record using the Edit menu

To move to a specific record using the keyboard

To delete a table

To save a table

To close a table

DEFINE KEYS

To define a primary key (automatically when creating a table)

To define a primary key (manually after a table has been created)

Index a field without duplications allowed

Modifying the way a field is indexed

TABLE DESIGN/LAYOUT

To change field format attributes.

Make sure that your field size attributes are long enough!

To create a validation rule for a number

To create a validation rule for text

To create a validation rule for a date or time

To create a validation rule for currency

To change the width of a column

To move a column(s)

TABLE RELATIONSHIPS

To create a one-to-one relationship between tables

To create a one-to-many relationship between tables

To delete a relationship between tables

To enforce referential integrity

3. FORMS

WORKING WITH FORMS

To open a form

To create a form using the AutoForm Wizard

The Form Wizard

To create a form using Form Wizard

To enter data into a form

To modify data using a form

To delete records using a form

To navigate through a form

To add text into headers or footers within a form

To modify the header or footer text within a form

To delete a form

To save a form

To close a form

4. RETRIEVE INFORMATION

MAIN OPERATIONS

To begin a search

To search using wildcard characters

To find a specific value

To find another occurrence of the same value after you have closed the dialog box

What is a filter?

To filter records in a table datasheet by selection

To filter records in a table datasheet by form

To apply the filter

To remove the filter

QUERIES

What are queries?

To create a query using the Simple Query Wizard

To select fields which you wish to add to your simple query

To create a query without the wizard

To use the query grid

To run a query

To search using wildcard characters

To add criteria to a query

To remove criteria from a query

To add a field to a query

To remove a field from a query

To move a field in a query

To hide a field in a query

To show a field in a query

To run a query

To delete a query

To save a query

To close a query

SORT RECORDS

Sorting records

To sort records in a table datasheet

To sort records in a form or query

5. REPORTS

WORKING WITH REPORTS

Introduction to reports

To create a columnar report using AutoReport Wizard

To create a tabular report using AutoReport Wizard

To create a report using Report Wizard

To select which fields to add to a report

To add grouping levels to a report

To sort records within a report

To determine the layout of a report

To determine the style of a report

To name a report

To alter the position of fields and headings in a report

To group information in a report

To calculate statistics for groups in a report

To add text to a report header or footer

To modify text within a report header or footer

To delete a report

To save a report

To close a report

6. PREPARE OUTPUTS

PREPARE TO PRINT

To preview a table, form or report, prior to printing

To change a reports orientation

PRINT OPTIONS

To set what you want to print

To print a query

To print a table, query or report to a file

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.

Computer Courseware Library for Schools, Collages, Universities & IT Trainers
A complete set of training materials for computer trainers & computer training organizations

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

ECDL Module Five

The European Computer Driving Licence

Databases

1. USING THE APPLICATION

DATABASE CONCEPTS

FIRST STEPS WITH DATABASES

ADJUST SETTINGS

2. TABLES

MAIN OPERATIONS

DEFINE KEYS

TABLE DESIGN/LAYOUT

TABLE RELATIONSHIPS

3. FORMS

WORKING WITH FORMS

4. RETRIEVE INFORMATION

MAIN OPERATIONS

QUERIES

SORT RECORDS

5. REPORTS

WORKING WITH REPORTS

6. PREPARE OUTPUTS

PREPARE TO PRINT

PRINT OPTIONS

Computer Courseware Library for Schools, Collages, Universities & IT Trainers A complete set of training materials for computer trainers & computer training organizations

ECDL 4.5 / ICDL 4 Courseware
European Computer Driving Licence

Computer Courseware Library for Schools, Collages, Universities & IT Trainers
A complete set of training materials for computer trainers & computer training organizations