Education Online - Career Education --- e-learning for Everyone.

 

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.
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.