IGCSE ICT Database Tasks 2026: How to Complete Common Practical Questions More Accurately

IGCSE ICT database tasks (ICT 0417) are practical exam activities where you build and manipulate a relational database in software like Microsoft Access to produce precise outputs.

You typically import CSV data, set correct data types and field properties, assign primary keys, create relationships using foreign keys, then run queries with sort and filter, validation rules, and wildcards.

Marks come from accurate criteria logic, correct calculated fields, and professional reports, forms, and mail merge-ready datasets.

Strong performance depends on avoiding structural mistakes and capturing clear evidence screenshots of table design, relationships, and query settings.

A Step By Step Guide To IGCSE ICT Database Tasks

IGCSE ICT database tasks (ICT 0417) are practical marks in disguise. Examiners are not testing whether you “know Access”; they are testing whether you can follow instructions precisely, build a clean relational database, and produce evidence that proves your method.

Based on our years of practical tutoring at Times Edu, the fastest improvements come from system-thinking. You treat every task as a workflow: Import → structure → keys → relationships → queries → sort and filter → outputs (reports, mail merge, evidence).

What IGCSE ICT database tasks usually include (Paper 2 / Paper 3)

Students often revise “theory”, then lose marks on execution. The practical database component is predictable, and the mark scheme rewards accuracy and completeness more than creativity.

A critical detail most students overlook in the 2026 exam cycle is that marks are often awarded for “process evidence” even when the final output is close.

If your evidence screenshots do not show the table design, relationships diagram, and query criteria clearly, you are donating marks.

>>> Read more: IGCSE ICT vs Computer Science 2026: What’s the Difference and Which Should You Choose?

Creating Relationships And Defining Data Types

Step 1: Import data correctly (CSV → Table)

In Microsoft Access, import is not a “click-next” activity. You are making structural decisions that affect every later query.

Use this checklist during import:

• Confirm field names are correct and match the task wording.
• Set data types deliberately, not automatically.
• Decide the primary key strategy before finishing the wizard.

Step 2: Choose correct data types and field properties

From our direct experience with international school curricula, top scorers treat “data type” as a marked topic, not a software preference.

Field properties are where precision lives. If the task expects “2 decimal places” and you only format it in the query output, you can still lose marks because the table design is incorrect.

Step 3: Primary key selection that actually works

A primary key must be unique and stable. Students often pick “Surname” or “ProductName” because it looks meaningful.

Use this decision rule:

• If the dataset has an ID field, that is your primary key unless explicitly told otherwise.
• If there is no ID field, create one only if the task allows it; otherwise, use the most reliably unique field.
• Never use fields that can duplicate (names, towns, categories).

Step 4: Create relationships and enforce foreign key integrity

IGCSE ICT database tasks frequently require a relational database with at least two tables. A foreign key is the field in the child table that references the primary key in the parent table.

Example logic:

• Table A: Customers (Primary key: CustomerID)
• Table B: Orders (Foreign key: CustomerID)

Relationship steps in Access:

• Open Database Tools → Relationships.
• Add all relevant tables.
• Drag the parent primary key to the matching foreign key.
• Tick “Enforce Referential Integrity” if allowed by the task.
• Save the relationships diagram.

Common misconception: Students think any two fields with similar names can be linked. The correct link is identical meaning, identical data type, and matching values.

Evidence requirement (do this every time)

Your screenshots should show:

• Table Design View with field names + data types + key icon visible.
• Relationships window showing the join line between tables.
• Any enforced integrity settings if used.

Keep screenshots uncropped enough that the examiner can see what database file and what window you used. Cropped evidence is often treated as missing evidence.

>>> Read more: IGCSE ICT Practical Accuracy 2026: How to Reduce Small Errors and Score More Consistently

Building Complex Queries Using Multiple Criteria

This is where most marks are won or lost in IGCSE ICT database tasks. You need a repeatable structure for criteria, not trial-and-error clicking.

The query-building workflow (high achiever method)

The pedagogical approach we recommend for high-achievers is a two-pass build:

1. Build the fields first with no criteria and run it to validate the dataset.
2. Add criteria one condition at a time, run after each, and screenshot the criteria grid.

Sort and filter, but do it examiner-style

Sorting is not decoration. Sorting is part of the required output format.

Sorting rules:

• Apply sort in the query when the final output must be sorted.
• Use multi-level sorts if the question implies it (e.g., “by Category then by Price descending”).
• If asked to “sort and filter”, filtering is criteria-based and sorting is output order.

Criteria logic: AND vs OR without confusion

Access uses:

• Criteria on the same row = AND
• Criteria on different rows = OR

Students misread this and build the opposite logic. You should write the logic in words first.

Wildcards: The safest way to score full marks

Wildcards are common in ICT 0417 queries. You must know which wildcard character you are expected to use based on the software setting, but for most IGCSE contexts using Access, * is the standard.

Use cases:

• Starts with: Like “A*”
• Ends with: Like “*son”
• Contains: Like “*tech*”
• Single character: Like “??5*” (pattern matching)

A frequent misconception is that wildcards are only for “search”. In the exam, wildcard criteria is often the only way to match partial text exactly as required.

Calculated fields and formatting

Calculated fields often appear as:

• Total = Price * Quantity
• DiscountedTotal = Total * (1 – DiscountRate)

Do this correctly:

• Use square brackets around field names: [Price]*[Quantity]
• Name the calculated field: Total: [Price]*[Quantity]
• Set formatting (Currency, decimal places) so output matches the question

If the exam expects Currency and you output a long decimal, you risk losing marks even if the calculation is correct.

Validation rules for accurate data entry

Validation is not “nice to have”. If the task asks for Validation, you must implement it in table design or form control properties.

Common examples:

• Quantity must be > 0: >0
• Date must be after a certain date: >=#01/01/2026# (format depends on system)
• Email must contain @ (basic): Like “*@*.*”

Validation text is often required as well. Add a clear message like:

• “Quantity must be greater than 0.”

Mail merge integration (when database feeds documents)

Some ICT 0417 tasks connect database outputs to documents using Mail merge. Your database must provide a clean query or table with correct field names and correct data.

Rules for mail merge success:

• Use consistent, sensible field names (no strange symbols).
• Ensure sorting is done before merging if the output requires order.
• Verify no blank key fields; mail merge breaks when key identifiers are missing.

>>> Read more: IGCSE Computer Science Pseudocode 2026: The Must-Know Syntax and Exam Tips

Designing Professional Reports And Data Entry Forms

Reports and forms are “presentation marks”, but they are still technical. Most students lose marks through missing grouping/sorting, wrong fields, or messy alignment.

Reports: Build from a query, not from raw tables

A report should be based on:

• A query that already filters and sorts correctly.
• Fields selected exactly as required in the task.

Report workflow:

• Create query → verify records → save query with meaningful name.
• Create a report from a query.
• Apply grouping and sorting in the report design if requested.
• Format headings, align columns, ensure page fits.

A critical detail most students overlook in the 2026 exam cycle is that reports are marked against the instruction wording, not what “looks good”. If the question says “display only these fields”, extra fields can cost marks.

Forms: Data entry with field properties and validation

Forms are about usability and correctness. A data entry form should be:

• Simple layout
• Logical tab order
• Correct control types
• Validation embedded to prevent wrong input

Form essentials:

• Use labels that match field meaning.
• Use combo boxes for fields with limited options (e.g., categories).
• Lock calculated fields if they should not be edited.
• Use Validation and Input Masks where specified.

Data entry success checklist:

• Required fields cannot be left blank.
• Data types prevent invalid characters.
• Validation messages are clear.
• Form is not cluttered.

Evidence: The “silent marks” strategy

Evidence is not a side task. It is part of how the examiner awards method marks.

Minimum evidence set you should capture:

• Table design view for each table (showing key and data types).
• Relationships diagram showing the link and table names.
• Query design grid showing criteria and sort lines.
• Report design view showing grouping/sorting settings.
• Form design/properties showing validation or input masks.

Take evidence as you go, not at the end. At the end, students rush and miss the exact window states that prove the method.

>>> Read more: IGCSE ICT 0417 Practical Revision Guide 2026: What to Practice, What to Memorize

Grade boundaries, marking behaviour, and academic strategy

You asked for deep trust elements, so here is the honest positioning. Grade boundaries can shift between sessions because paper difficulty shifts, and Cambridge applies statistical moderation. You cannot control boundaries, but you can control your raw mark by reducing “unforced errors”.

Unforced errors that most commonly drop students from A* range:

• Wrong data types causing incorrect query results.
• Criteria logic (AND/OR) mistakes.
• Missing primary key or incorrect relationships.
• Outputs not matching exactly requested fields/order.
• Evidence screenshots missing key settings.

From our direct experience with international school curricula, students aiming for selective university routes should not treat ICT 0417 as a “filler subject”. If your profile includes Computer Science, Business, Economics, or STEM pathways, clean performance in data handling supports your narrative: Precision, systems thinking, and applied digital fluency.

How to choose subjects for a strong study abroad profile:

• If you plan Business/Econ: Pair ICT with Mathematics and an essay-based subject to show quantitative and communication balance.
• If you plan CS/Engineering: ICT supports applied competence, but you still need rigorous math/science for competitiveness.
• If you plan Social Sciences: ICT strengthens research and data handling, but keep at least one writing-heavy subject to show academic depth.

Based on our years of practical tutoring at Times Edu, the best students treat exam performance and profile-building as one plan. Your IGCSE results are part of your academic trajectory, not an isolated exam.

If you want, Times Edu can map your personalised route: Target grade outcomes for ICT 0417, subject combination strategy, and a long-term plan that aligns IGCSE → IB/A-Level/AP → university admissions.

>>> Read more: IGCSE Tutor 2026: How to Choose the Right One

Frequently Asked Questions

Conclusion

Times Edu can assess your current practical performance, diagnose which step causes mark loss (data types, relationships, criteria logic, reporting), then build a targeted training sequence with exam-style drills and marking feedback.

If you share your latest mock Paper 2/Paper 3 database task brief (or screenshots of your query grids and outputs), I can map a personalized improvement plan and a revision timetable aligned to your exam window.

Hiếu Đào