Employability and Enterprise

Agriculture, Environment & Animal Care

Vocational Qualifications

Catering, Hospitality & Leisure

Vocational Qualifications

Childcare & Education

Access to HE
Apprenticeships
Pre-Access to HE
Vocational Qualifications

Construction, Engineering & Manufacturing

Access to HE
Vocational Qualifications

Creative, Design & Digital

Access to HE
Vocational Qualifications

Education & Training

Professional Development

Hair & Beauty

Vocational Qualifications

Health, Science & Social Care

Access to HE
Apprenticeships
Pre-Access to HE
Vocational Qualifications

Life Skills & Progression

Personal & Social Development

Personal and Professional Development

Personal & Social Development
Professional Development
Vocational Qualifications

Public & Protective Services

Access to HE
Vocational Qualifications

Safeguarding & Wellbeing

Supporting SEND

Personal & Social Development
Professional Development

Transport & Logistics

Access to HE
Vocational Qualifications

Overview

Framework:
RQF
Level:
Level 3
Unit No:
T/502/4556
Credits:
6
Guided learning hours:
45 hours

Unit Learning Outcomes

1.

Plan, create and modify relational database tables to meet requirements.

Assessment Criteria

  • 1.1
    Explain how a relational database design enables data to be organised and queried.
  • 1.2
    Plan and create multiple tables for data entry with appropriate fields and properties.
  • 1.3
    Set up and modify relationships between database tables.
  • 1.4
    Explain why and how to maintain data integrity.
  • 1.5
    Respond appropriately to problems with database tables.
  • 1.6
    Use database tools and techniques to ensure data integrity is maintained.

2.

Enter, edit and organise structured information in a database.

Assessment Criteria

  • 2.1
    Design and create forms to access, enter, edit and organise data in a database.
  • 2.2
    Select and use appropriate tools and techniques to format data entry forms.
  • 2.3
    Check data entry meets needs, using IT tools and making corrections as necessary.
  • 2.4
    Respond appropriately to data entry errors.

3.

Use database software tools to create, edit and run data queries and produce reports.

Assessment Criteria

  • 3.1
    Explain how to select, generate and output information from queries according to requirements.
  • 3.2
    Create and run database queries to display, amend or calculate selected data.
  • 3.3
    Plan and produce database reports from a multiple-table relational database.
  • 3.4
    Select and use appropriate tools and techniques to format database reports.
  • 3.5
    Check reports meet needs, using IT tools and making corrections as necessary.

Offer this Unit

If you would like to offer this unit, you can book a meeting with us to discuss the best options.