Agriculture, Environment & Animal Care
Qualifications
Vocational Qualifications
Catering, Hospitality & Leisure
Qualifications
Vocational Qualifications
Childcare & Education
Qualifications
Access to HE
Apprenticeships
Vocational Qualifications
Construction, Engineering & Manufacturing
Creative, Design & Digital
Education & Training
Qualifications
Professional Development
English & Maths
Qualifications
English & Maths
Essential Digital Skills
Qualifications
Digital Qualifications
Hair & Beauty
Qualifications
Vocational Qualifications
Health, Science & Social Care
Qualifications
Access to HE
Apprenticeships
Vocational Qualifications
Life Skills & Progression
Qualifications
Digital Qualifications
Personal & Social Development
Personal and Professional Development
Qualifications
Digital Qualifications
Personal & Social Development
Professional Development
Vocational Qualifications
Public & Protective Services
Qualifications
Access to HE
Vocational Qualifications
Safeguarding & Wellbeing
Qualifications
Sales, Marketing & Retail
Supporting SEND
Qualifications
Personal & Social Development
Professional Development
Transport & Logistics
Qualifications
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 our Qualifications

If you would like to teach our qualifications to your learners, submit an enquiry to discuss the best options.

Learners and students

Your questions answered

Learner Info