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

 

Synopsis
European 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 European Computer Driving Licence objectives using Microsoft Access on a personal computer that uses a Windows operating system. The ECDL 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 European Computer Driving Licence examination.

Time
4 hours

Product Code: EIDL05
After completing European 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)
European Computer Driving Licence: Understanding Information Technology (EIDL01)
European Computer Driving Licence: Using the Computer and Managing Files (EIDL02)
European Computer Driving Licence: Word Processing (EIDL03)
European Computer Driving Licence: Creating and Using Spreadsheets (EIDL04)
European Computer Driving Licence: Building and Delivering Presentations (EIDL06)
European Computer Driving Licence: The World Wide Web and Electronic Mail (EIDL07)

"European Computer Driving Licence" and ECDL and Stars device are registered trade marks of the European Computer Driving Licence Foundation Limited in Ireland and other countries. MindLeaders.com, Inc., is an independent entity from the European Computer Driving Licence Foundation Limited, and not affiliated with the European Computer Driving Licence Foundation Limited in any manner. This course may be used in assisting students to prepare for the European Computer Driving Licence Examination. Neither the European 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.