Course Code:02.05
Course Subject:Module 5 Using Databases
Course Title:ECDL (5v0) Module 5 Using Databases
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. Understand Databases (Key Concepts)

  1. Understand what a database is.

  2. Understand the difference between data and information.

  3. Understand how a database is organized in terms of tables, records and fields.

  4. Know some of the common uses of large-scale databases like: airline booking systems, government records, bank account records, hospital patient details.

2. Understand Databases (Organisation)

  1. Understand that each table in a database should contain data related to a single subject type.

  2. Understand that each field in a table should contain only one element of data.

  3. Understand that field content is associated with an appropriate data type like: text, number, date/time, yes/no.

  4. Understand that fields have associated field properties like: field size, format, default value.

  6. Understand what an index is. Understand how it allows for faster data access.

3. Understand Databases (Relationships)

  1. Understand that the main purpose of relating tables in a database is to minimize duplication of data.

  2. Understand that a relationship is built by matching a unique field in one table with a field in another table.

  3. Understand the importance of maintaining the integrity of relationships between tables.

4. Understand Databases (Operation)

  1. Know that professional databases are designed and created by database specialists.

  2. Know that data entry, data maintenance and information retrieval are carried out by users.

  3. Know that a database administrator provides access to specific data for appropriate users.

  4. Know that the database administrator is responsible for recovery of a database after a crash or major errors.

5. Use the Application

  1. Open, close a database application.

  5. Use available Help functions.

6. Use the Application (Common Tasks)

  1. Open, save and close a table, query, form, report.

  2. Switch between view modes in a table, query, form, report.

  5. Sort records in a table, form, query output in ascending, descending numeric, alphabetic order.

7. Manage Tables (Records)

  1. Add, delete records in a table.

  2. Add, modify, delete data in a record.

8. Manage Tables (Design)

  1. Create and name a table and specify fields with their data types like: text, number, date/time, yes/no.

  2. Apply field property settings: field size, number format, date/time format, default value.

  3. Create a validation rule for number, date/time, currency.

  4. Understand consequences of changing data types, field properties in a table.

  5. Set a field as a primary key.

  6. Index a field (with, without duplicates allowed).

  7. Add a field to an existing table.

  8. Change width of columns in a table.

9. Retrieve Information (Main Operations)

  1. Use the search command for a specific word, number, date in a field

  2. Apply a filter to a table, form.

  3. Remove the application of a filter from a table, form.

10. Retrieve Information using Queries

  1. Understand that a query is used to extract and analyse data.

  2. Create a named single table query using specific search criteria.

  3. Create a named two-table query using specific search criteria.

  4. Add criteria to a query using one or more of the following operators: = (Equal), <> (Not equal to), < (Less than), <= (Less than or equal to), > (Greater than), >= (Greater than or equal to).

  5. Add criteria to a query using one or more of the following logical operators: AND, OR, NOT.

  6. Use a wildcard in a query, * or %, ? or __.

  7. Edit a query: add, modify, remove criteria.

  8. Edit a query: add, remove, move, hide, unhide fields.

  9. Run a query.

11. Manage Forms

  1. Understand that a form is used to display and maintain records.

  2. Create and name a form.

  3. Use a form to insert new records.

  4. Use a form to delete records.

  5. Use a form to add, modify, delete data in a record.

  6. Add, modify text in headers, footers in a form.

12. Output Reports and Export Data

  1. Understand that a report is used to print selected information from a table or query.

  2. Create and name a report based on a table, query.

  3. Change arrangement of data fields and headings within a report layout.

  4. Present specific fields in a grouped report by sum, minimum, maximum,average, count, at appropriate break points.

  5. Add, modify text in headers, footers in a report.

  6. Export a table, query output in spreadsheet, text (.txt, .csv), XML format to a location on a drive.

13. Print

  1. Change the orientation (portrait, landscape) of a table, form, query output, report. Change paper size.

  2. Print a page, selected record(s), complete table.

  3. Print all records using form layout, specific pages using form layout.

  4. Print the result of a query.

  5. Print specific page(s) in a report, print complete report.