2025 May/June Paper 21, Tasks 3 & 4 Databases, Cambridge 0417 /0983 ICT [IGCSE]

Video Description

In this tutorial i solve Tasks 3 & 4 of the 2025 May/June Paper 21 of the ICT IGCSE exam 0417 / 0983. Tasks 3& 4 cover the Databases component of this paper. You can access the Word processing component (tasks 1 & 2) here: https://youtu.be/IZYLucDt-Hw You can access the Presentation / chart creation components (task 4) here: https://youtu.be/8VY1GAeKnCI Task 3 ---------------------------- 0:00 Intro 0:58 Q15 - Reading the question and understanding what we need to do 01:58 IMPORTANT - how to set up your device to display correct date format and so that you can import CSV files 04:08 Importing the CSV file as a new table 07:52 Advanced settings of the fields Date Format, Boolean Yes/No 09:29 Taking appropriate screenshot of the imported table 10:41 Q16 - Importing a second table from CSF file When to use short text and when to use long text data type 14:42 Q17 - Identifying the primary key field in a CSV file (We use Excel for this) 16:52 Importing the third CSV file to a new table and set the identified field as a primary key. 18:42 Q18 - Creating Relationships and producing appropriate screenshots 21:45 What not to do when taking screenshots of relationships 22:48 Q19 - Adding a new record in a table. I create a simple data entry form (not needed but good for practice) Link to tutorial on Data Entry Forms: https://youtu.be/yMqMoWAhLbM?si=_aIPvsG9wfiX5GRs 25:39 Adding the data directly in to the table. 27:26 Q20 - Creating a Report (first create a Query) 28:38 Creating the query 30:27 adding criteria to the query [IMPORTANT INFO HERE] 32:18 Explaining wildcards * in criteria 34:29 Creating the report based on the query created. Modifying the report so that it displays properly. [lots of tips and tricks here] 39:48 Applying sorting from report design view 40:36 Use a function on date in the Report [Important Tip Here], Formatting the date 46:29 Adding a Page Footer 48:11 COMMON STUDENT MISTAKE 50:46 Q21 - Creating custom Labels (create query first) 50:46 understanding what we need to do Link to a tutorial on crating labels: https://youtu.be/DhYYgQhHp_A?si=LsI_O9Az9bNnbmK4 52:58 Creating the Query 54:44 Adding the criteria [how to OR criteria with wild cards] 57:53 Creating a custom labels from the query [a lot of important info here] 01:01:34 Modifying the labels in Design View (add a label and format the label) Task 4 ----------------------------- 01:04:12 Print the Evidence document 01:04:37 Recap Links to Part 1 and Part 3