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 Advanced AM5
Courseware

The European Computer Driving Licence

Databases

1. TABLE DESIGN

FIELDS, COLUMNS

To set column data types

To modify column data types

To format Text data type

To format Memo data type

To format Hyperlink data type

To format Currency data type

To format Date/Time data type

To choose appropriate data types

To convert between data types

To change a field to a different data type

To create a lookup in a field

To create a lookup from the values in a table or query

To create a lookup from the values you type in

To edit a lookup in a field

To create a validation rule in a field

To edit a validation rule in a field

To create an input mask in a field

To edit an input mask in a field

To apply default value in a field

To set required fields

RELATIONSHIPS/JOINS

To identify a related table

To create a relationship

To delete a relationship

To create one-to-one and one-to-many join types

To create a one-to-one relationship

To create a one-to-many relationship

To modify one-to-many join type

To create many-to-many relationship

To modify many-to-many join type

To apply inner join

To apply outer join

To apply self join

To set referential integrity

To set cascading options

To create a two-table join

To add another table to the query grid

To add fields from different tables to the query grid

To remove tables from the query builder

2. QUERY DESIGN

QUERY TYPES

To create an Update Query

To create a Delete Query

To create a Make-Table Query

To create an Append Query

QUERY FORMULAS

To calculate totals for a single group

To calculate totals for several groups

To count the values in a specified column using the COUNT function

To sum the values in a specified column using the SUM function

To average the values in a specified column using the AVG function

To find maximum value in a specified column using the MAX function

To find minimum value in a specified column using the MIN function

To create a crosstab query

To create a crosstab query using the Crosstab Query Wizard

To use Wildcards as parameters

To create a calculation in design view

To create an arithmetic expression in a query

To create a logical (conditional) expression in a query

REFINE A QUERY

To find duplicates using the Find Duplicates Query Wizard

To find unmatched values using the Find Unmatched Query Wizard

To find highest range of values in a query

To find lowest range of values in a query

To create a parameter query

To find Null values

To find NOT values

3. FORM DESIGN

CONTROLS

To choose an appropriate control

To place an unbound control

To place a bound control

To create a combo box

To create a list box

To create a check box

To create an option button

To create an option group

To create expression control

To create arithmetic expression control

To create logical (conditional) expression control

To set tab index for controls on a form

To create form headers and footers

To number form pages

SUBFORMS

To use a subform

To add a subform to a form

To bring a subtotal from a subform to a main form

4. REPORT DESIGN

CALCULATIONS

To place controls on a report

To create arithmetic expression control

To create logical (conditional) expression control

To calculate percentage calculation control in a report

To use common functions in calculated fields

To use calculated fields in a report

To concatenate (combine) values in an expression

To create a report with running summaries

PRESENTATION

To create Page Headers and Footers

To create Report Headers and Footers

To group records on a report

To force page breaks after each record

To force page breaks after each group of records

5. MACROS

RECORD & ASSIGN

To create a new macro

To run a macro

To use the Single Step method to run a macro

To attach macros to a form

To attach the macro to a control in the form

To attach macros to a report

To attach the macro to a report event

To attach the macro to a section of the report

To attach the macro to the selected form property

6. IMPORT, EXPORT AND LINK DATA

DATA MANAGEMENT

To import from text files

To import from Excel spreadsheet

To import from dBASE

To import from Paradox

To export data to a spreadsheet file

To export data to a text file

To export data to a dBASE file

To export data to a Paradox file

To link to an external text file

To link to Microsoft Excel spreadsheet

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 Advanced AM5 Courseware

The European Computer Driving Licence

Databases

1. TABLE DESIGN

FIELDS, COLUMNS

RELATIONSHIPS/JOINS

2. QUERY DESIGN

QUERY TYPES

QUERY FORMULAS

REFINE A QUERY

3. FORM DESIGN

CONTROLS

SUBFORMS

4. REPORT DESIGN

CALCULATIONS

PRESENTATION

5. MACROS

RECORD & ASSIGN

6. IMPORT, EXPORT AND LINK DATA

DATA MANAGEMENT

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

ECDL Advanced AM5
Courseware

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