Data manipulation (databases) — IGCSE Information And Communication Technology (0983) questions by topic
Adding a new learner record with fields such as forename, gender and date of birth, importing a CSV file as a new table with dates in day-month-year order, creating one-to-many relationships between linked tables, and preparing multi-table reports with consistent currency formatting are typical of the 16 databases questions from 2023 to 2025, where task marks reach as high as 30 out of a 1 to 30 range.
Describe, use, state, produce and add top the command words, with produce specifically expecting a finished, correctly formatted report or table rather than a draft. Because a wrongly imported date format or a missing relationship link can break every report built afterwards, submit your database build for instant marking, so a formatting or linking error is caught at the step it occurs rather than after several dependent reports have been generated.
May–June 2025, Paper 12
A bookshop is setting up a database of the books that it sells. Part of the database is shown. Nameofbook Typeofbook Price Dateofpublication --- --- --- --- Baines Brief Lives N…
Answer this question and get it marked →May–June 2025, Paper 21
You are now going to prepare a report. Dates must be imported in the format day month year (DMY). Make sure all required data is fully visible. Use database software to import the…
Answer this question and get it marked →Import the file j2521access.csv as a new table in your database. Set all data types to text. Set AAcode as the primary key. Place in your Evidence Document a screenshot showing…
Answer this question and get it marked →Examine the file j2521class.csv and identify the most appropriate data to use as a primary key. Close this file. Import the file j2521class.csv as a new table in your database.…
Answer this question and get it marked →Create one-to-many relationships as links between: - the AAcode field in the access table and the AAcode field in the learners' table - the primary key field in the class table…
Answer this question and get it marked →Add the following as a new record in the learners' table: Field Value --- --- Surname Norris Forename Emma Gender Female Learnerno 10218427 DOB 10/07/2009 Telephone 0770090457…
Answer this question and get it marked →Using fields from all the tables produce a tabular report that: - selects the records where: - Gender is Female - Accessarrangement includes the text time - shows only the fields…
Answer this question and get it marked →Using fields from all the tables produce labels which: - select the records where: - AAcode is AA01 - Classcode includes the numbers 5 or 6 - are sorted in descending order of…
Answer this question and get it marked →May–June 2025, Paper 22
Step 14. Use database software to import the file j2522runners.csv as a new table. Use these field names and data types: Field name Data type Store Display --- --- --- ---…
Answer this question and get it marked →May–June 2024, Paper 21
Task 3 – Database (29 marks total) You are going to prepare a report. Dates are to be imported in the format day month year (DMY). Source files: j2421child.csv, j2421bookings.csv.…
Answer this question and get it marked →May–June 2024, Paper 22
Task 3 – Database (30 marks total) You are going to prepare some reports. Dates must be imported in DMY format. All currency values must display the same currency symbol and 2…
Answer this question and get it marked →October–November 2024, Paper 02
Task 3 – Database (30 marks total) Dates must be imported in DMY format. Source files: n2402students.csv, n2402degrees.csv, n2402countrycodes.csv. Steps 14–19 require candidates…
Answer this question and get it marked →May–June 2023, Paper 21
Task 3 – Database (27 marks total) You are going to prepare reports using source files: j2321results.csv, j2321starttimes.csv, j2321catcodes.csv. Step 15: Import j2321results.csv…
Answer this question and get it marked →May–June 2023, Paper 22
Task 3 – Database (29 marks total) Source files: j2322race.csv, j2322clubs.csv. Step 15: Import j2322race.csv into database software. Use specified field names and data types…
Answer this question and get it marked →October–November 2023, Paper 02
Task 3 – Database (27 marks total) You are now going to prepare some reports. All currency values must display the same currency symbol and be set to 2 decimal places. Source…
Answer this question and get it marked →October–November 2023, Paper 11
A newsagent has created a database with fields to store details of each newspaper and magazine he sells. Part of the database is shown. Productnumber Nameofpublication…
Answer this question and get it marked →Other IGCSE Information And Communication Technology topics
- Spreadsheets (38)
- Website authoring (25)
- Document production (22)
- Presentations (20)
- Types and components of computer systems (9)
- ICT applications (8)
- Safety and security (8)
- Input and output devices (7)
- The systems life cycle (7)
- The effects of using IT (health and safety) (6)
← All IGCSE Information And Communication Technology (0983) past papers