Mark Rastin

IT Help, Support and Training

Course

Specification

Course Code:

20.05

Course Subject:

ECDL Module 5

Course Title:

Database

Aims:

The student shall understand some of the main concepts of databases and demonstrate the ability to use a database on a computer.

Introduction:

On completion of the course, the student shall be able to create and modify tables, queries, forms and reports, and prepare outputs ready for distribution. The student shall be able to relate tables and to retrieve and manipulate information from a database by using query and sort tools available in the package.

Objectives

The learner will be able to:

Assessment Criteria

The learner has achieved this objective because he/she can:

1. Use the Application

1. Understand what a database is.
   Understand how a database is organised in terms of tables, records, fields, and with field data types, field properties.
   Understand what a primary key is.
   Understand what an index is.
   Understand the purpose of relating tables in a database.
   Understand the importance of setting rules to ensure relationships between tables are valid.

2. Open (and close) a database application.
   Open, log onto an existing database.
   Create a new database.
   Save a database to a location on a drive.
   Use available Help functions.
   Close a database.

3. Change between view modes in a table, form, report.
   Display and hide built-in toolbars.

2. Use Tables

1. Create and save a table and specify fields with their data types.
   Add, delete records in a table.
   Add a field to an existing table.
   Add, modify data in a record.
   Delete data in a record.
   Use the undo command.
   Navigate within a table to next record, previous record, first record, last record, specific record.
   Delete a table.
   Save and close a table.

2. Define a primary key.
   Index a field with, without duplicates allowed.

3. Change field format attributes such as: field size, number format, date format.
   Understand consequences of changing field size attributes in a table.
   Create a simple validation rule for number, text, date/time, currency.
   Change width of columns in a table.
   Move a column within a table.

4. Create a one-to-one, one-to-many relationship between tables.
   Delete relationships between tables.
   Apply rule(s) to relationships such that fields that join tables are not deleted as long as links to another table exist.

3. Manage Forms

1. Open a form.
   Create and save a form.
   Use a form to enter, modify, delete records.
   Go to next record, previous record, first record, last record, specific record using form display.
   Add, modify text in Headers, Footers in a form.
   Delete a form.
   Save and close a form.

4. Retrieve Information

1. Use the search command for a specific word, number, date in a field.
   Apply a filter to a table, form.
   Remove a filter from a table, form.

2. Create and save a single table query, two-table query using specific search criteria.
   Add criteria to a query using any of the following operators: < (Less than), <= (Less than or equals), > (Greater than), >= (Greater than or equals), = (Equals), <> (Not equal to), And, Or.
   Edit a query by adding, removing criteria.
   Edit a query: add, remove, move, hide, unhide fields.
   Run a query.
   Delete a query.
   Save and close a query.

3. Sort data in a table, form, query output, in ascending, descending numeric, alphabetic order.

5. Manage Reports

1. Create and save a report based on a table, query.
   Change arrangement of data fields and headings within a report layout.
   Group data under a specific heading (field) in a report in ascending, descending order.
   Present specific fields in a grouped report by sum, minimum, maximum, average, count, at appropriate break points.
   Add, modify text in Headers, Footers in a report.
   Delete a report.
   Save and close a report.

6. Prepare Outputs

1. Preview a table, form, report.
   Change report orientation: portrait, landscape. Change paper size.

2. Print (Print to File if no printer available) a page, selected record(s), complete table.
   Print all records using form layout, specific pages using form layout.
   Print the result of a query.
   Print specific page(s) in a report, complete report.