--- ECDL / ICDL courseware using Microsoft Access XP, 2000 and 2007 courseware training manuals for IT trainers including ECDL syllabus 4 and ICDL Syllabus 5.0 training courses for ICDL Module five

ECDL Courseware & ICDL Courseware Training Materials

ECDL /ICDL
Standard Edition
For use outside the UK

ECDL 5 / ICDL 5

ECDL / ICDL Module 1
Concepts of Information Technology (IT)

ECDL / ICDL Module 2
Using the Computer & Managing Computer Files

ECDL / ICDL Module 3
Word Processing

ECDL / ICDL Module 4
Spreadsheets

ECDL / ICDL Module 5
Databases

ECDL / ICDL Module 6
Presentations

ECDL / ICDL Module 7
Information & Communication

Advanced ECDL / ICDL
Syllabus 2

Advanced ECDL / ICDL AM3
Word Processing

Advanced ECDL / ICDL AM4
Spreadsheets

Advanced ECDL / ICDL AM5
Database

Advanced ECDL / ICDL AM6
Presentation

ECDL | European Computer Driving Licence

ICDL | International Computer Driving Licence

Please view our other computer courseware titles including
Windows 7 and Microsoft Office 2010 training materials

ECDL / ICDL Module 5 (Syllabus Four) Courseware
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

Please visit the ECDL website for more information.

ECDL | European Computer Driving Licence
ICDL | International Computer Driving Licence

ECDL / ICDL Courseware Training Materials

Customisable Courseware
No Annual Renewal Fees
Unlimited Number of Users
Unlimited Reprinting Rights
PLUS Intranet Versions

ECDL Training

ECDL / ICDL

ECDL / ICDL Module 5 (Syllabus Four) CoursewareDatabases

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

ECDL / ICDL Courseware Training Materials

ECDL / ICDL Module 5 (Syllabus Four) Courseware
Databases