Skip to topic
    ← Back to course topics

    Database Software — OCN London Vocational Digital Skills & IT

    Database Software explained

    This element focuses on the practical application of non-relational database software to store, manage, and retrieve structured information.

    Read the full explanation

    Learners will develop skills in creating and modifying single-table databases, entering and editing data efficiently, and using built-in tools to run queries and generate reports. Mastery of these skills is essential for organizing information in many administrative, technical, and customer-facing roles.

    Learning outcomes

    1. Create and modify non-relational database tables, Enter, edit and organise structured information in a database, Use database software tools to run queries and produce reports

    Database Software assessment help

    Topic Overview

    The OCNLR Level 2 Award in IT User Skills (ITQ) is a vocational qualification designed to develop practical IT skills for the workplace. It covers essential software applications such as word processing, spreadsheets, databases, and presentation software, as well as fundamental concepts like file management, online collaboration, and digital security. This qualification is ideal for students who want to demonstrate competence in using IT effectively in a professional environment, whether for administrative roles, further study, or career progression.

    This award is part of the IT User Skills (ITQ) suite, which is recognised by employers and educational institutions across the UK. It focuses on real-world tasks, such as creating business documents, analysing data with spreadsheets, and delivering presentations. By completing this qualification, students gain a nationally recognised certification that validates their ability to use IT tools efficiently and safely, making them more employable and confident in digital settings.

    The qualification is structured into units, each covering a specific software application or IT skill. Students must achieve a minimum number of credits by passing assessments that involve practical tasks and written evidence. This modular approach allows learners to tailor their studies to their interests or career needs, while ensuring they meet the required standards for IT proficiency at Level 2, which is equivalent to GCSE grades 4-9.

    Key Concepts
    • →File management: organising, saving, and retrieving files using appropriate folder structures and naming conventions.
    • →Word processing: creating, formatting, and editing documents, including using styles, tables, and mail merge.
    • →Spreadsheets: entering data, using formulas and functions (e.g., SUM, AVERAGE, IF), and creating charts.
    • →Databases: designing tables, queries, forms, and reports to store and retrieve information efficiently.
    • →Digital security: understanding passwords, data protection, and safe online practices to prevent cyber threats.
    Assessment Criteria
    • Award credit for correctly creating a new database table with appropriate field names, data types, and field sizes that match the given data requirements.
    • Award credit for demonstrating accurate data entry and editing, including the use of validation techniques (e.g., input masks, default values) to maintain data integrity.
    • Award credit for successfully constructing and running single-criterion queries that extract relevant records, and for designing a report with grouped data and professional formatting.
    Assessment Guidance
    • 💡Always plan the database structure on paper before use; clearly define fields, data types, and any validation rules you will apply.
    • 💡When running a query, test it with a small sample to verify correctness before applying it to the entire dataset, and ensure you save queries with descriptive names.
    • 💡In the assessment, document each step with screenshots and annotations to provide evidence of your understanding, as this can often secure additional marks even if minor errors occur.
    • 💡Always read the task instructions carefully. Many students lose marks by missing specific requirements, such as using a particular formula or formatting style.
    • 💡Save your work frequently and in the correct file format (e.g., .docx, .xlsx). Examiners will check that you can manage files properly, so use sensible filenames and folder structures.
    • 💡For presentation software, focus on clarity and consistency. Use bullet points, not paragraphs, and ensure your slides have a uniform design. Avoid overloading slides with text or animations.
    Common Mistakes
    • Many learners confuse data types, such as setting numerical fields as text, which prevents sorting or arithmetic operations.
    • A common error is forgetting to set a primary key or unique identifier, leading to potential data duplication and query inaccuracies.
    • When creating reports, learners often fail to preview and adjust layout, resulting in truncated fields or poorly aligned columns that do not meet professional standards.
    • Misconception: 'Spreadsheet formulas are too complex for me.' Correction: Basic formulas like SUM and AVERAGE are straightforward; you just need to understand cell references and the order of operations.
    • Misconception: 'I can just use the default settings in Word; formatting doesn't matter.' Correction: Employers expect professional-looking documents; using styles, consistent fonts, and proper alignment shows attention to detail.
    • Misconception: 'Databases are the same as spreadsheets.' Correction: Databases are designed for storing and querying large amounts of structured data, while spreadsheets are better for calculations and small datasets.
    Frequently Asked Questions
    How long does it take to complete the OCNLR Level 2 Award in IT User Skills?
    The duration depends on your study pace and the number of units you choose. Typically, it takes around 60-90 guided learning hours, which could be a few months if studying part-time. Many students complete it within a single academic term.
    Is this qualification equivalent to a GCSE?
    Yes, the OCNLR Level 2 Award is equivalent to a GCSE at grades 4-9 (previously A*-C). It is recognised by employers and further education institutions as evidence of IT proficiency at Level 2.
    Do I need to have prior IT experience before starting this course?
    No, the course is designed for beginners. However, basic computer skills like using a mouse and keyboard are helpful. The qualification starts with fundamental concepts and builds up to more advanced tasks.
    What software will I need to use for this qualification?
    You will typically use Microsoft Office applications: Word, Excel, Access, and PowerPoint. Some centres may use alternatives like Google Workspace or LibreOffice, but the skills are transferable.
    How is the qualification assessed?
    Assessment is through practical tasks and a portfolio of evidence. You will complete assignments that demonstrate your ability to use IT software for real-world tasks, such as creating a business letter or a spreadsheet with formulas. There are no formal exams.
    Can I study this qualification online?
    Yes, many colleges and training providers offer this qualification online. You will need access to a computer with the required software and an internet connection. Assessments are submitted electronically.
    Unit assessment details

    Loading assessment details…