Relational Database

This unit is expiring
The expiry date of this unit is 31/07/2026.

Overview

Framework:
Access to HE
Level:
Level 3
Unit No:
QU014306
Credits:
3
Guided learning hours:
Not available

Qualification Grading Type

Graded

Grade Descriptors

  • GD3-Application of skills
  • GD7-Quality

Unit Learning Outcomes

1.

Be able to identify the data structure to hold information in a database.

Assessment Criteria

  • 1.1
    Create tables and establish relationships between them.
  • 1.2
    Design a data entry form.
2.

Be able to process information in a database.

Assessment Criteria

  • 2.1

    Create queries to combine data from multiple tables.

  • 2.2
    Perform calculations based on information in queries.
  • 2.3
    Display information from tables on a form.
3.

Be able to present database information in reports.

Assessment Criteria

  • 3.1
    Create menu and sub-menu reports for a database and attach actions to them.