International Computer Driving Licence

Synopsis
International Computer Driving Licence: Creating and Using Databases shows users how to work with a database application to create a database; create, use, and change a data entry form; retrieve information; and create reports.

This course describes how to meet International Computer Driving Licence objectives using Microsoft Access on a personal computer that uses a Windows operating system. The ICDL test can be taken with any database application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

Audience
This course is for those who have never used a computer and those who have some computer experience but no formal qualification proving their knowledge or skills. It is also for those preparing to take the International Computer Driving Licence examination.

Time
4 hours

Product Code: ICDL05

After completing International Computer Driving Licence: Creating and Using Databases, the user should be able to:

Open and close a database

Revise and save records

Use application help

Create a database

Update a database

Create, use, and revise a data entry form

Create and refine a query

Select and sort data

Create and edit a report

Getting Started
Starting a database application

Revising and saving records

Adjusting settings

Changing table view mode

Using application help

Closing a database and exiting from the application

Creating a Database
Planning a database

Creating the database framework

Setting a primary key

Entering table data

Using Data Entry Forms
Creating and using a data entry form

Changing form layout

Importing an image file

Retrieving Information from a Database
Finding a record

Filtering and sorting data

Creating a query

Refining a query

Creating Reports
Producing a report for selected data

Modifying a report

This course has the following features:

Exercises that allow users to practice database skills

A file containing the text of the exercises

Simulations that allow users to practice course skills, even if they don't have access to the real application

A glossary

A Skill Assessment

Familiarity with basic Windows functions (windows, icons, menus, scroll bars, mouse)

International Computer Driving Licence: Understanding Information Technology (ICDL01)

International Computer Driving Licence: Using the Computer and Managing Files (ICDL02)

International Computer Driving Licence: Word Processing (ICDL03)

International Computer Driving Licence: Creating and Using Spreadsheets (ICDL04)

International Computer Driving Licence: Building and Delivering Presentations (ICDL06)

International Computer Driving Licence: The World Wide Web and Electronic Mail (ICDL07)

"International Computer Driving Licence" and ICDL and Stars device are registered trade marks of the International Computer Driving Licence Foundation Limited in Ireland and other countries. MindLeaders.com, Inc., is an independent entity from the International Computer Driving Licence Foundation Limited, and not affiliated with the International Computer Driving Licence Foundation Limited in any manner. This course may be used in assisting students to prepare for the International Computer Driving Licence Examination. Neither the International Computer Driving Licence Foundation Limited nor MindLeaders.com, Inc., warrants that the use of this course will ensure passing the relevant Examination.

Microsoft® Windows® and/or other Microsoft products referenced herein are either trademarks or registered trademarks of Microsoft Corporation.

All other trademarks are the property of their respective owners.