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