Database software — WJEC-CBAC Vocationally-Related Qualification Digital Skills & IT Revision

    This element introduces the rudimentary skills of managing structured information within a database application. Learners will practise entering new record

    Topic Synopsis

    This element introduces the rudimentary skills of managing structured information within a database application. Learners will practise entering new records, editing existing data, and using basic organisational tools like sorting and filtering to arrange data meaningfully. The practical outcome is the ability to generate simple reports that present a subset of data, demonstrating foundational digital literacy applicable to personal record-keeping or introductory office tasks.

    Key Concepts & Core Principles

    Exam Tips & Revision Strategies

    Common Misconceptions & Mistakes to Avoid

    Examiner Marking Points

    Database software

    WJEC-CBAC
    vocational

    This subtopic introduces learners to the fundamental skills required to interact with a simple database. Students will learn to accurately enter and edit data within a structured format, such as a table or form, using common software tools. These skills are essential for organizing information in everyday digital tasks, such as maintaining contact lists or inventory records.

    26
    Learning Outcomes
    46
    Assessment Guidance
    52
    Key Skills
    26
    Key Terms
    59
    Assessment Criteria

    Assessment criteria

    WJEC Entry Level Award for IT Users (Entry 1)
    WJEC Entry Level Certificate for IT Users (Entry 1)
    WJEC Entry Level Award for IT Users (Entry 2)
    WJEC Level 1 Award for IT Users (ITQ)
    WJEC Entry Level Certificate for IT Users (Entry 2)
    WJEC Level 1 Certificate for IT Users (ITQ)
    WJEC Entry Level Award for IT Users (Entry 3)
    WJEC Entry Level Certificate for IT Users (Entry 3)

    Topic Overview

    The WJEC Entry Level Award for IT Users (Entry 2) is a vocationally-related qualification designed to introduce students to fundamental digital skills. It covers essential IT tasks such as using a computer safely, creating and editing documents, sending emails, and navigating the internet. This qualification is ideal for beginners who want to build confidence in using technology for everyday tasks, whether at home, school, or in the workplace.

    The course is structured around practical, real-world activities that help students develop basic digital literacy. Topics include file management, word processing, online communication, and staying safe online. By completing this award, students demonstrate that they can perform simple IT tasks independently, which is a crucial foundation for further study in digital skills or for entering the workforce.

    This qualification fits into the wider subject of Digital Skills & IT by providing a stepping stone to higher-level qualifications, such as the WJEC Level 1 Award for IT Users. It ensures that students have the core competencies needed to use technology effectively and responsibly, preparing them for more advanced digital challenges in education and employment.

    Key Concepts

    Core ideas you must understand for this topic

    • →File Management: Understand how to create, save, open, and organise files and folders on a computer or device.
    • →Word Processing: Use a word processor to create simple documents, format text (bold, italic, font size), and insert images or tables.
    • →Online Communication: Send and receive emails, including attaching files and understanding basic email etiquette.
    • →Internet Navigation: Use a web browser to find information, navigate websites, and understand the difference between a search engine and a website address.
    • →Online Safety: Recognise common online risks (e.g., sharing personal information, cyberbullying) and know how to stay safe, such as using strong passwords and logging out of accounts.

    Learning Objectives

    What you need to know and understand

    • Enter and edit structured information in a database., Use database software tools.
    • Enter and edit and organise structured information in a database., Use database software tools to produce reports.
    • Enter and edit and organise structured information in a database., Use database software tools to produce reports.
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • Identify appropriate data types and field properties for a given scenario
    • Enter data into a database accurately using efficient data entry methods
    • Edit, update, and delete records to maintain data integrity
    • Organise data by applying sorts and filters to meet specified criteria
    • Design and run simple queries to extract relevant information
    • Produce a formatted report that presents query results appropriately for a given purpose
    • Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • Design a simple database table with appropriate fields and data types.
    • Enter and edit data accurately using forms and datasheets.
    • Apply sorting and filtering to organise records.
    • Construct basic queries to retrieve specific data subsets.
    • Produce formatted reports with selected fields and summaries.
    • Enter data accurately into a database table using appropriate data types and field names
    • Edit existing records to correct or update information
    • Organise data by sorting and filtering according to given criteria
    • Use query tools to extract specific subsets of information from a database
    • Produce simple tabular or summary reports from database queries
    • Identify different database components such as tables, records, and fields
    • Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports

    Assessment Criteria

    Key criteria assessors look for in your portfolio

    • Award credit for demonstrating the ability to open a pre-existing database file using the software interface.
    • Award credit for accurately typing data into designated fields within a form or table.
    • Award credit for successfully editing existing records, such as updating a name or adding a number.
    • Award credit for using basic tools like 'save' and 'close' appropriately to secure data.
    • Award credit for demonstrating the ability to open a database file and navigate between records.
    • Award credit for accurately entering new data into designated fields within a simple table or form.
    • Award credit for editing existing data entries, such as correcting a name or updating a number, without corrupting other records.
    • Award credit for using basic organisation features like sorting records alphabetically or filtering by a single criterion.
    • Award credit for producing a simple report using the software's report wizard or template, selecting appropriate fields and checking for correct formatting.
    • Award credit for correctly opening a given database table and navigating to a specific record or entering a new record into the appropriate fields with typographical accuracy.
    • Look for evidence of editing an existing record, such as updating a field value and saving the change, ensuring no accidental deletion of adjacent records.
    • Assess the ability to organise data by applying a single-level sort (e.g., alphabetical by surname) or a simple filter (e.g., showing only entries from a specific category).
    • For report production, credit should be given for using a built-in report tool to select relevant fields, generate a preview, and output the report without empty or misaligned columns.
    • Enter and edit data accurately in a database.
    • Organise data using sorting and filtering.
    • Create queries to extract specific information.
    • Produce formatted reports from database data.
    • Apply data validation and integrity rules.
    • Award credit for accurately inputting a new record into a database table, with no errors in field content.
    • Evidenced ability to locate and edit an existing record, changing at least one field value correctly.
    • Successful use of a database tool (e.g., report wizard) to produce a printed or digital output that extracts relevant data from one or more tables.
    • Demonstrates organising data by applying a basic sort (e.g., alphabetical order) or filter to a column.
    • Evidence of creating a table with appropriate field names and data types
    • Demonstration of accurate data entry, including the use of forms if available
    • Records are correctly updated and saved after editing
    • Sort orders and filters applied correctly to achieve required output
    • Query results accurately reflect specified criteria
    • Report layout is clear, includes relevant data, and is fit for audience
    • Award credit for entering at least five complete records into a database table with all mandatory fields populated accurately, evidenced by a screenshot or printout.
    • Award credit for editing an existing record to update a field (e.g., changing a contact number or address) without introducing data duplication or corruption.
    • Award credit for organising data by applying a logical sort order (e.g., alphabetical by surname) and using appropriate data types and field lengths as specified in the assignment brief.
    • Award credit for using database software tools to extract information by creating and running a simple query with a single criterion (e.g., all customers in a specific city), producing a filtered dataset.
    • Award credit for producing a formatted report from extracted data, including a title, column headings, and basic layout adjustments suitable for printing or presentation.
    • Award credit for accurately entering data into specified fields without errors such as typos or incorrect data types.
    • Award credit for demonstrating editing skills by modifying existing records, such as updating a contact number or correcting a misspelled name.
    • Award credit for organizing data by sorting records alphabetically, numerically, or by date as per task requirements.
    • Award credit for applying a basic filter to display only records meeting specified criteria (e.g., all customers from a certain city).
    • Award credit for generating a simple report that includes selected fields, appropriate headings, and is formatted for clarity.
    • Award credit for demonstrating accurate data entry by inputting records without typographical errors and in the correct fields.
    • Recognize the ability to edit existing records correctly, modifying, deleting, or updating information while maintaining data integrity.
    • Credit should be given for organising data effectively, such as sorting records alphabetically/numerically or filtering to display specific subsets.
    • Assess the capability to use the software’s reporting tools to produce a clear, formatted report that meets specified requirements (e.g., selected fields, appropriate layout).
    • Enter data consistently using correct data types (text, number, date, etc.).
    • Demonstrate ability to edit existing records without corrupting data integrity.
    • Use sort and filter functions to arrange data logically for given scenarios.
    • Create a query that returns only records meeting specified criteria (e.g., all customers in a postcode area).
    • Generate a report that includes appropriate fields, clear headings, and any required subtotals or formatting.
    • Award credit for accurately following a brief and producing outputs that match the expected structure.
    • Award credit for demonstrating accurate data entry with no typographical errors
    • Evidence of successfully editing at least one record to correct a mistake or update a field
    • Ability to sort records alphabetically or numerically as instructed
    • Correct application of a single filter criterion to display only relevant records
    • Generation of a simple report that includes selected fields and a title
    • Understanding of the relationship between tables and queries
    • Award credit for demonstrating accurate data entry with no typographical errors in at least 5 new records.
    • Award credit for successfully editing at least 3 existing records, changing field contents without corrupting other data.
    • Award credit for correctly sorting a table by a specified field (e.g., alphabetically by surname) and saving the sorted view.
    • Award credit for applying a simple filter to display only records that meet a given criterion (e.g., all customers in a particular city).
    • Award credit for producing a basic report that includes selected fields and a title, and is printed or exported correctly.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Always double-check that you have selected the correct field before typing; use the tab key to move between fields efficiently.
    • 💡Practice navigating between records using the arrow buttons before attempting to edit, to avoid accidental changes.
    • 💡Before submitting, review each record to ensure all data is entered correctly and saved.
    • 💡Always practice with a sample database before attempting the assessment; familiarity with the software's interface is key.
    • 💡When entering data, double-check that you are in the correct field to avoid common data entry errors.
    • 💡For reports, use the preview function to check layout and ensure all required information is visible before printing or saving.
    • 💡If an assessment task asks you to edit data, make sure you explicitly show the before and after states in your evidence screenshots or notes.
    • 💡Practise the full cycle: open database, add two records, edit one, sort by a given field, and generate a report from filtered data; time yourself to build confidence.
    • 💡Before finalising any data entry, verify spelling and numeric accuracy—examiners will check for common sense errors like duplicate entries or impossible dates.
    • 💡When asked to produce a report, first consider which fields are essential; use the software’s report wizard and always preview to ensure all columns fit on one page.
    • 💡Practice using different data types (text, number, date).
    • 💡Learn how to create simple queries with criteria.
    • 💡Understand report layout options.
    • 💡Always proofread your data entry for spelling and numerical accuracy before saving, as some assessment criteria require error-free content.
    • 💡Familiarise yourself with the ‘Undo’ function (Ctrl+Z) to quickly reverse accidental mistakes during data entry.
    • 💡When producing a report, preview it before printing or submitting to ensure all required fields are displayed and formatted legibly.
    • 💡Familiarise yourself with the specific database software's interface before the assessment
    • 💡Practice creating reports using the software's wizard to understand layout options
    • 💡Always double-check query criteria against the task requirements to ensure accuracy
    • 💡Use clear, descriptive field names to make reports more understandable
    • 💡Take time to proofread any manually entered data before final submission
    • 💡Before starting any database task, always review the assignment brief or scenario to understand exactly what data is required and how it should be structured; this prevents avoidable rework.
    • 💡When demonstrating editing, take a before-and-after screenshot or note the change timestamp to clearly evidence your actions to the assessor.
    • 💡For queries, build them step-by-step and test each criterion individually before combining them; this makes troubleshooting much easier and shows systematic approach.
    • 💡When producing a report, use the software's built-in report wizard or templates to ensure a professional layout, then customise only necessary elements to save time and reduce error.
    • 💡Always double-check data entry for accuracy before final submission; even small typos can be penalized.
    • 💡Practice using the software's built-in tools for sorting and filtering, as these are frequently assessed.
    • 💡When asked to produce a report, read the instructions carefully to ensure the correct fields and format are used.
    • 💡Save your work frequently and confirm that your report displays as expected before printing or exporting.
    • 💡Always proofread data entries before saving to ensure accuracy and consistency; a single typo can affect report outcomes.
    • 💡Use the software’s built-in validation and formatting tools to minimise errors and enhance presentation.
    • 💡Practise creating reports using sample datasets to become familiar with the steps and options available in the software interface.
    • 💡For the assessment, carefully read the task brief to identify exactly what data to enter/edit and what the report requirements are.
    • 💡Practice with sample data to become fluent in using the software tools before the assessment.
    • 💡Read the task brief carefully – note which fields, conditions, and report layout are required.
    • 💡Always test queries by reviewing the output before using them as the basis for a report.
    • 💡Use a consistent naming convention for saved queries and reports to avoid confusion during submission.
    • 💡Carefully read the task brief to determine exactly which fields and records are required for the report
    • 💡Double-check data entry for accuracy before moving on to querying
    • 💡Always save your database file after making changes
    • 💡Practice using different filter options (e.g., equals, contains) to ensure you can extract data efficiently
    • 💡When producing reports, ensure you include a meaningful title and only the necessary fields to avoid clutter
    • 💡Always double-check that you are working in the correct table or query before entering or editing data to avoid accidental changes.
    • 💡Use the 'Undo' function immediately if you make a mistake, but be aware that some database actions cannot be undone.
    • 💡When asked to extract information, carefully read the question to determine whether you need a filter, a query, or both, and check that your output matches all criteria.
    • 💡Before printing or submitting a report, preview it to ensure all required fields are visible, no data is cut off, and the title is clear.
    • 💡Tip 1: Read each task carefully and follow the instructions exactly. For example, if the task says 'save the file as 'MyWork' in the 'Documents' folder', do not rename it or save it elsewhere. Marks are awarded for accuracy.
    • 💡Tip 2: Practise using keyboard shortcuts (e.g., Ctrl+C to copy, Ctrl+V to paste) to save time during assessments. However, ensure you can also use the mouse and menus, as some tasks may require them.
    • 💡Tip 3: For online safety questions, always give specific examples, such as 'never share your password with anyone' or 'log out of your account on shared computers'. Generic answers like 'be careful' are not enough.

    Common Mistakes

    Common errors to avoid in your coursework

    • Forgetting to save new or edited records before closing the database, leading to data loss.
    • Entering data into the wrong field, e.g., typing a phone number into an email address field.
    • Accidentally deleting records when attempting to edit them, due to unfamiliarity with the software interface.
    • Confusing the terms 'field' and 'record', leading to data being placed in the wrong column or row.
    • Forgetting to save changes to the database after editing, resulting in data loss when the application is closed.
    • Accidentally deleting entire records instead of clearing a single field when editing.
    • Struggling to understand that a database is for storing related data sets, often trying to use spreadsheet formulas instead.
    • Learners often confuse rows (records) and columns (fields), attempting to type a new record into an existing field header rather than into a blank row.
    • A frequent error is forgetting to save changes after editing, leading to loss of data; some also inadvertently leave a record in edit mode, preventing others from accessing it.
    • When sorting, students may select only a single column rather than the entire table, causing data misalignment; they may also struggle to reverse a sort.
    • In report generation, a common mistake is choosing too many fields for a simple report, resulting in cluttered or truncated output, or not checking print preview for layout errors.
    • Entering data in wrong fields or formats.
    • Not using primary keys or indexing.
    • Creating reports without proper grouping or sorting.
    • Confusing the terms 'field' and 'record', leading to data being entered in the wrong location.
    • Forgetting to save changes after editing a record, resulting in loss of work.
    • Selecting the incorrect table or query as the data source when generating a report, producing irrelevant output.
    • Entering duplicate records unintentionally due to not checking existing data before adding new entries.
    • Selecting incorrect data types (e.g., using text for numeric fields) leading to sorting or calculation errors
    • Inconsistent data entry resulting in duplicates or gaps in records
    • Forgetting to save changes after editing records
    • Applying filters that inadvertently exclude required data
    • Producing reports that include all table fields instead of a tailored selection
    • Overwriting existing data when importing or pasting without first checking
    • Learners often confuse the 'edit' and 'delete' functions, accidentally removing records when intending to modify them, or vice versa, due to not carefully reading software prompts.
    • A common error is entering data in the wrong field or leaving mandatory fields blank, resulting in incomplete records that fail validation rules.
    • When organising data, learners sometimes use inappropriate data types (e.g., entering numbers as text), which can prevent sorting or calculations from working correctly.
    • In extracting information, many learners forget to clear previous query criteria, leading to incorrect or empty results sets, and they may not know how to switch back to a full table view.
    • When producing reports, learners frequently overlook the need to preview and adjust page margins or orientation, causing reports to be cut off or poorly formatted on paper.
    • Students often confuse saving records with saving the database file, leading to data loss if not properly committed.
    • A common error is entering data into the wrong field, especially when fields look similar (e.g., 'First Name' and 'Last Name' swapped).
    • Many learners forget to apply sorting or filtering before generating a report, resulting in unordered or unfiltered data.
    • When creating reports, students may inadvertently include all fields instead of selecting only those required, leading to cluttered output.
    • Entering data into the wrong field or misaligning fields across records, leading to inconsistent datasets.
    • Forgetting to save changes after editing, resulting in loss of updated information.
    • Confusing data types (e.g., entering text into a numeric field) causing errors in sorting or reporting.
    • Selecting all fields for a report instead of only those required, producing cluttered and unprofessional outputs.
    • Confusing data types, such as entering text in a numeric field or using inconsistent date formats.
    • Failing to save queries and reports, leading to lost work and inability to demonstrate process.
    • Not checking filter conditions, resulting in incorrect or empty query results.
    • Producing reports that lack meaningful titles, page numbers, or selected fields, making them unprofessional.
    • Overwriting existing data unintentionally due to poor editing practices.
    • Misunderstanding the difference between a field and a record
    • Entering data into the wrong field or using inconsistent formatting
    • Forgetting to save changes after editing records
    • Confusing sorting with filtering, or applying filters incorrectly
    • Attempting to produce a report without first selecting the correct query or table
    • Entering data in the wrong field (e.g., typing a phone number into the address field) due to confusion over field labels.
    • Forgetting to save changes after editing a record, resulting in lost modifications.
    • Applying a sort but failing to save it, so the data reverts to the original order when reopened.
    • Misunderstanding filter criteria, such as filtering for 'equals' when 'contains' is needed, leading to no results.
    • Producing reports that include too many fields or raw table views instead of a formatted, readable layout.
    • Misconception: 'Saving a file means it is automatically backed up.' Correction: Saving only stores the file on your device; you need to back it up separately (e.g., to a USB drive or cloud storage) to prevent loss.
    • Misconception: 'All information on the internet is true.' Correction: Not all websites are reliable; you should check the source and look for trusted sites (e.g., .gov, .ac.uk) or cross-reference information.
    • Misconception: 'Email attachments can be opened safely without checking.' Correction: Attachments can contain viruses; only open attachments from people you trust, and scan them with antivirus software if possible.

    Frequently Asked Questions

    Common questions students ask about this topic

    Before You Start

    Prior knowledge that will help with this topic

    • •Basic familiarity with using a computer or tablet (e.g., turning it on, using a mouse or touchscreen).
    • •Understanding of simple English to follow instructions and read on-screen text.
    • •No formal IT qualifications are required, but some experience with typing or using a keyboard is helpful.

    Key Terminology

    Essential terms to know

    • Enter and edit structured information in a database., Use database software tools.
    • Enter and edit and organise structured information in a database., Use database software tools to produce reports.
    • Enter and edit and organise structured information in a database., Use database software tools to produce reports.
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • Data structure and field properties
    • Accurate data entry techniques
    • Record modification and maintenance
    • Sorting and filtering data
    • Query design for information retrieval
    • Report generation and formatting
    • Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • DBE:1 Enter, edit and organise structured information in a database, DBE:2 Use database software tools to produce reports
    • Data entry and validation
    • Database structure and organisation
    • Querying and filtering data
    • Report generation and formatting
    • Information extraction techniques
    • Data entry and accuracy
    • Editing and updating records
    • Organising data in tables
    • Simple queries and filters
    • Producing basic reports
    • Understanding data structure
    • Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports

    Ready to learn?

    AI-powered learning tailored to this unit

    Related Topics in WJEC-CBAC vocational Digital Skills & IT

    Data Quality

    View Topic

    Data, Information and Knowledge

    View Topic

    Databases

    View Topic

    Emerging Technologies

    View Topic