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

Training materials for::
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet Explorer
Outlook
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Expression Web
Computer Concepts
ECDL / ICDL Downloads

PLUS MANY MORE ...

ECDL / ICDL Module 5 (Syllabus Four) Courseware
Databases

PLEASE NOTE: The ECDL / ICDL Courseware Library includes versions for Office 2000, Office XP, Office 2003 & Office 2007. Plus versions for Windows 2000, Windows XP and Windows Vista

ECDL | ICDL Courseware Training Manual

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

Other ECDL / ICDL Courseware Training materials

   © 1995-2008 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. Terms & Conditions
   Course content subject to change without notice.

Now download complete samples of all our courses

Download Computer Training Sample Courses

    Consider the benefits of investing in quality computer courseware materials:
    For schools, colleges, professional IT trainers & computer training companies

    You get the duplication rights for all 150+ computer courses when you invest in the 'Courseware Library'

Cheltenham Courseware for Australian Schools & Computer Training Companies | You are not using a JavaScript enabled browser. The JS used on this site is used for presentational purposes only.

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

Other ECDL / ICDL Courseware Training materials

Consider the benefits of investing in quality computer courseware materials: For schools, colleges, professional IT trainers & computer training companies You get the duplication rights for all 150+ computer courses when you invest in the 'Courseware Library'

ECDL / ICDL Module 5 (Syllabus Four) Courseware
Databases

Consider the benefits of investing in quality computer courseware materials:
For schools, colleges, professional IT trainers & computer training companies

You get the duplication rights for all 150+ computer courses when you invest in the 'Courseware Library'