18.2

Topic 18

Manipulate data

  • IGCSE I.C.T 0417
  • 2 min read
  • Syllabus 2026, 2027 and 2028

Objectives

  1. 1

    Perform calculations

    • aUse arithmetic operations or numeric functions to perform calculations including calculated fields, calculated controls
    • bUse formulae and functions to perform calculations at run time including addition, subtraction, multiplication, division, sum, average, maximum, minimum, count
  2. 2

    Sort data

    • aUse a single criterion, or multiple criteria to sort data into ascending or descending order
  3. 3

    Search and select data

    • aUse a single criterion, or multiple criteria to select subsets of data using a query
    • bperform searches using a variety of operators including AND, OR, NOT, LIKE, >, <, =, >=, <=, <>
    • cperform searches using wildcards

Cambridge IGCSE ICT 0417 syllabus 2026-2028, 18.2 Manipulate data (copied for internal use as permitted by Cambridge)

Detailed · Deep study

1Calculations

A calculated field is created in a query from other fields, e.g. a field TotalCost = [Price] * [Quantity]. A calculated control is a text box on a form or report that shows a calculation at run time, e.g. =Sum([TotalCost]) in a report footer.

TotalCost: [Price]*[Quantity]
=Sum([TotalCost])
=Avg([Mark])
=Max([Price])
=Count([MemberID])
A calculated field in a query, and calculated controls in a report.

2Sorting

Sort records into ascending (A–Z, 0–9, oldest first) or descending order on a single field, or on multiple criteria: e.g. sort by Surname ascending, then by FirstName ascending for people with the same surname.

3Searching with queries

A query selects a subset of records that meet criteria; it can use one criterion or several in different fields (on the same row = AND; on different rows = OR).

Operator / wildcardExample criterionFinds
=="Nairobi"records where the field equals Nairobi
>, <, >=, <=>=50values of 50 or more
<><>"Paid"all records except Paid
AND>=10 AND <=20values from 10 to 20 inclusive
OR"Red" OR "Blue"either value
NOTNOT "Science"everything except Science
LIKE with * (any characters)LIKE "M*"values starting with M
? (one character)LIKE "B?ll"Ball, Bell, Bill, Bull

4Exam focus

Key words: calculated field; calculated control; sort; ascending; descending; query; criteria; AND; OR; NOT; LIKE; wildcard.

Quick self-check

Answer in your head first, then reveal.

  1. LIKE "S*" (2).

  2. Calculated field is created in a query (1); calculated control is on a form/report and calculated at run time (1).

  3. Sort first on the main field, e.g. surname (1), then on a second field for records with the same value, e.g. first name (1).

Finished this subtopic? Track it on your subject page.