Search billions of records on Ancestry.com
   
Website logo - Click to go to Home page



European Computer Driving Licence

Module 5

Module 5 - Databases/Filing Systems
The following is the Syllabus for Module 5, which is the basis for the practice-based test on Databases. The module consists of two sections; the first section involves setting up a new database, and the second involves using an existing database to retrieve and display required information.
Module Goals Module 5 - Databases/Filing Systems , requires the candidate to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The module is divided in two sections; the first section tests the candidate's ability to design and plan a simple database using a standard database package; the second section requires the candidate to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the data-base. The candidate shall also be able to create and modify reports.
Category Skill Set Ref. Task Item
5.1 Getting Started 5.1.1 First Steps with Databases 5.1.1.1 Open a database application.
5.1.1.2 Open an existing database with default layout.
5.1.1.3 Modify a record within an existing database and save.
5.1.1.4 Save a database onto the hard disk or a diskette.
5.1.1.5 Close the database.
5.1.1.6 Use application Help functions.
5.1.2 Adjust Basic Settings 5.1.2.1 Change viewing modes.
5.1.2.2 Modify toolbar display.
5.2 Create a Database 5.2.1 Basic Operations 5.2.1.1 Design and plan a database.
5.2.1.2 Create a table with fields and attributes.
5.2.1.3 Navigate throughout a table.
5.2.1.4 Enter data in a table.
5.2.2. Define Keys 5.2.2.1 Define a primary key
5.2.2.2 Set up an index.
5.2.3 Table Design 5.2.3.1 Modify table layout attributes.
5.2.3.2 Modify field attributes.
5.2.4 Updating a Database 5.2.4.1 Modify data in a table.
5.2.4.2 Delete data in a table.
5.2.4.3 Add records to the database.
5.2.4.4 Delete records in the database.
5.3 Use of Forms 5.3.1 Create a Form 5.3.1.1 Create a simple form.
5.3.1.2 Enter data into the database using simple forms.
5.3.2 Modify Form Layout 5.3.2.1 Format text.
5.3.2.2 Change background colours in form layout.
5.3.2.3 Import an image or graphics file into a form.
5.3.2.4 Change arrangement of objects within form layout.
5.4 Retrieve Information 5.4.1 Basic Operations 5.4 1.1 Load or log onto an existing database.
5.4.1.2 Find a record based on given criteria.
5.4.1.3 Create a simple query.
5.4.1.4 Create a query with multiple criteria.
5.4.1.5 Save a query.
5.4.1.6 Add filters.
5.4.1.7 Remove filters.
5.4.2 Refine a Query 5.4.2.1 Add fields to a query.
5.4.2.2 Remove fields from a query.
5.4.3 Select and Sort 5.4.3.1 Select and sort data based on given criteria.
5.4.3.2 Select and sort data based on common logical operators.
5.5 Reporting 5.5.1 Create Reports 5.5.1.1 Present selected data in a particular sequence on screen and in reports.
5.5 1.2 Modify a report.
5.5.1.3 Create and customise Headers and Footers.
5.5.1.4 Group data in a report-totals, sub-totals etc.

JGC Logo Valid HTML5 Logo HTML5 Logo Valid CSS3 Logo JGC Logo
Copyright logo
This page (ecdlmod5.html) was last modified on Sunday 27/01/2013