2024 June Paper 22, Cambridge 0417 /0983 ICT [IGCSE] Tasks 3 & 4

In this tutorial i solve Tasks 3 & 4 of the 2024 June Paper 22 of the ICT IGCSE exam 0417 / 0983. Tasks 3 & 4 cover the Databases and Printing components of this paper.

You can access the Word processing component (tasks 1 & 2) here:
   • 2024 June Paper 22, Cambridge 0417 /0983 I...  

You can access the Presentation / chart creation components (task 5) here:
   • 2024 June Paper 22, Cambridge 0417 /0983 I...  

0:00 Intro

--------------------------------------
Task 3 (Databases)
--------------------------------------
00:46 Q13- Import first csv as new table
06:03 Import second csv as new table
09:43 Q14- Creating a one-to-many relationship
11:06 Q15- Adding a new record in a table. (i demonstrate a quick data entry form also)
14:14 Q16- Understanding what we have to do to create the report. (A lot of important tips here)
16:01 Creating The query
20:55 Creating the report based on the query.( here i demonstrate 2 ways to apply the sorting and the differences of each)
26:16 applying sorting in the design view of the report
27:45 finishing the report (IMPORTANT info on adjusting the filed row height to make the report fit on 2 pages)
30:32 Q17- Understanding what we need to do to generate the labels.
32:46 creating the query to generate the labels.
35:03 Creating custom sized labels (IMPORTANT info on custom labels here)
38:27 Understanding the importance of selecting the query before creating the labels
40:38 Formatting the labels
42:12 modifying the margins to make sure we get 10 labels per page

--------------------------------------
Task 4 (Printing the Evidence)
--------------------------------------
43:43 Printing the evidence document