2024 Feb/March Paper 21, Cambridge 0417 /0983 ICT [IGCSE] Tasks 3

In this tutorial i solves Task 3 of the 2024 February / March Paper 21 of the ICT IGCSE exam 0417 / 0983. Task 3 covers the Databases component of this paper.

You can access the Word processing component (tasks 1 & 2) here:

You can access the Presentation / chart creating and printing components (tasks 4 & 5) here:

0:00 Intro

-------------------------------
Task 3 [00:43 Data Base]
-------------------------------
00:43 Q11-Identifying the Primary key filed in a csv file and importing the csv file as a table. (important tips here)
11:40 Q12 Q13-Import .csv files as tables without changing datatypes
15:00 Q13-Create table relationships
16:48 Q14-Add a record.(i also create a data entry form)
21:12 Q16-Creating a query and report. (1st sorting method demonstrated)
33:11 Q17-Creating a query and report. (2nd sorting method demonstrated)

[Yplayz]

Sir u are the You are helping me alott in my ICT journey by not just solving the past-papers but explaining them and teaching extra things which is just additional effort from your part. Keep going and Thank You soooo much

[ishashanil]

THANKSSKS MY EXAMS TMR AND IM PASSING CUZ OF U THANKS KING

[NinaurrChanél]

thank you so much! i've got my ict exam tomorrow for paper 21 and this video has definitely saved me!

[oblivion_is_void]

Dear Nicos Paphitis,

I hope you're doing well. I've been following your videos for some time now, and I truly appreciate the effort you put into them—they have been incredibly helpful.

Recently, I worked on a Paper 2 question that required knowledge of radio buttons for database forms. This got me wondering—are there other similar functions or features we should be familiar with, not only for forms but also for reports and labels?

I’d really appreciate any guidance or insights you can share. Thank you for your time, and keep up the great work!

[Yplayz]

Sir at 38:16 is there any reason you did not make the new sales field percent? as the question says percentage

[EsterLINKAGE]

Hi sir! I had a question, at 46:53 in the global sales field, aren’t the values a bit randomized rather than being in the descending order? For instance, in the first field the value is 8.32 but in the second one it is 11.18.

[abdulazizjameel-qw]

Sir from where can i access these files for practice

[ESHALKHAN-ir]

Hello sir, at 9:49, why don't we set it to currency even if it's a sale value? At the start of the paper is says to set all currency values with a currency symbol. I'm just confused about this but thank you for the video!

[tarek_]

At the last step, why didn't you fit it in one page as he asked?

[reezap]

Sir at 39:35 when you were adding the Age_Code, was there a reason why you chose it specifically from the games table and not the classifications table?

[ntgvibes]

hi sir! have you got any predictions for may/june'25?

[happyamy]

I did everything but my preview is 2 pages for the question 16 😔