Thank you so much for this series, I've been struggling with my mental health for the past two years of my studies and haven't done anything worthwhile to actually learn so this is a great help for my examinations this month :DDD
I am so glad this helped you. I hope you are feeling better or at least on the road to feeling better. I have play lists covering all of the skills for the practical components of the exam so make sure to watch those to help you. If you need any support please reach out to me.
No, you do not need to write the descriptions. they are there for you to read and make sure to set up the fields correctly. for example the fields Ready and Sold must display YES/No and not a checkbox. they are not descriptions of what the field is, like what we would enter in Access when setting up a new table.
@@HamdanAllie it indicates the number of decimal digits allowed after the decimal point. Double allows for mor decimal digits than Single. Can't remember how many for each type for Access. I think it is 7 deci.al places for Single and 15 for double. Either will be more than enough for the exams so it does not really matter which one you use for numbers with decimal places.
It does not really matter, double or single. Double allows for more decimal places than single but even single allows for quite a lot and they will not be giving you numbers with many decimal places. To be safe though just ise double. For while numbers though, always use long integer, again to be safe.
If it is indexed then it will not allow duplicate entries in that field, like a primary key. If it is NO then it will allow duplicate entries in that field.
Indexig helps speed up data retrival based on that field which is indexed. A primary key field is indexed and duplicates set to not allowed by default. This is because your searches will be based on that field and you do not want to have duplicates stored in that field. For the syllabus you do not need to worry about indexing apart from the primary key field which will be done automatically.
my paper 2 is tomorrow and whenever i try and import an excel file on my laptop, it shows bad file name or number from the import text wizard, please help
@@AbdulRahman-pr4vo 1- Have you tried importing different .csv files or just the same one? it maybe that file is corrupt. 2-have you checked that that the delimiter is a comma? 3-Have you extracted the file from the .zip file? never work on files which are zipped. you must extract them
![[Part 2] Complex Import of CSV files to Access tables, IGCSE ICT (0417)](http://i.ytimg.com/vi/NzCQkPH5Els/mqdefault.jpg)
![[Part 2] Complex Import of CSV files to Access tables, IGCSE ICT (0417)](/img/tr.png)
![[Part 6] Creating Data Entry Forms (Microsoft Access) Cambridge IGCSE ICT (0417)](http://i.ytimg.com/vi/yMqMoWAhLbM/mqdefault.jpg)
![PowerPoint complete guide, [Cambridge IGCSE ICT 0417]](http://i.ytimg.com/vi/TRHfD3RP9cg/mqdefault.jpg)
Whole 10 “peace” class is saying thanks to you , you’re a saver
bros saving lives
true
frrrrrrr
true
Thank you so much for this series, I've been struggling with my mental health for the past two years of my studies and haven't done anything worthwhile to actually learn so this is a great help for my examinations this month :DDD
I am so glad this helped you. I hope you are feeling better or at least on the road to feeling better. I have play lists covering all of the skills for the practical components of the exam so make sure to watch those to help you. If you need any support please reach out to me.
Sir why you didn't wrote the description? Is it not important to write that words. The description which is shown in 5:15
No, you do not need to write the descriptions. they are there for you to read and make sure to set up the fields correctly. for example the fields Ready and Sold must display YES/No and not a checkbox. they are not descriptions of what the field is, like what we would enter in Access when setting up a new table.
@@paphitisn thankyou sir. I understood
thanks so much, i have a paper tmr but dont have access to access. this helped lots
I am glad this helped you. Good luck with your paper tomorrow.
i just finished the playlist@@paphitisn
@AtarwaNoUcom Wow. My voice will be ringing in your head for the next few days. Good luck
Thanks so much. I’m watching this before an exam
I hope it helps. Make sure to let us know how you did in the exam. Good luck!
I have the whole series of everything you need for the Exam as a playlist
@@paphitisn yes I know. I was watching it earlier
I love you so much for this. Gonna grind 10 A*'s and 2 World no.1's
I am glad it helped you. Ginna hold you to the A*'s, at least in ICT
sir do we always have to enforce referential integrity when creating relationships?
Could I know the definition of primary key & foreign key please? Along with the difference between them?
what does double or single mean in the data types
@@HamdanAllie it indicates the number of decimal digits allowed after the decimal point. Double allows for mor decimal digits than Single. Can't remember how many for each type for Access. I think it is 7 deci.al places for Single and 15 for double. Either will be more than enough for the exams so it does not really matter which one you use for numbers with decimal places.
@@paphitisn Thank you very much
Where can I download the CSV files from to practise?
I have added a link at the bottom of the description with 7 csv files and a pdf question paper (7 exercises) for you to use to practice
Hello sir it’s me again 🥰☝️ 7:08 should i always keep it “double” when there are decimal places ? and when they don’t mention the description ?
It does not really matter, double or single. Double allows for more decimal places than single but even single allows for quite a lot and they will not be giving you numbers with many decimal places. To be safe though just ise double. For while numbers though, always use long integer, again to be safe.
@@paphitisn thank you so much
You are welcome@@Yara-fs5ej
What is the meaning of indexed yes/no when importing the csv files.
If it is indexed then it will not allow duplicate entries in that field, like a primary key. If it is NO then it will allow duplicate entries in that field.
@@paphitisn Got it. Thanks a lot!
is this for cambridge or edexcel igcse? I am in edexcel IGCSE.
it is created for the Cambridge ICT IGCSE but it is for anyone that wants to learn to use Access.
@@paphitisn thanks
Thanks
Thanks a lot
What is indexed
Indexig helps speed up data retrival based on that field which is indexed. A primary key field is indexed and duplicates set to not allowed by default. This is because your searches will be based on that field and you do not want to have duplicates stored in that field. For the syllabus you do not need to worry about indexing apart from the primary key field which will be done automatically.
Sir in 15:55 if its a telephone number, why do we have to use short text instead of long integer
14:47 always use text for telephone
@@ajeebxedits ahh i see, thank you for correcting me!
@@aaronyogurt6117 np! goodluck
my paper 2 is tomorrow and whenever i try and import an excel file on my laptop, it shows bad file name or number from the import text wizard, please help
Excel is not a text file. Are you importing a csv file or an Excel file?
@@paphitisn i meant csv, sorry
@@AbdulRahman-pr4vo
1- Have you tried importing different .csv files or just the same one?
it maybe that file is corrupt.
2-have you checked that that the delimiter is a comma?
3-Have you extracted the file from the .zip file? never work on files which are zipped. you must extract them
@@paphitisn i have tried multiple csv files which i got from gceguide and i always extract the files
@@AbdulRahman-pr4vo copy all the files from that folder and paste them somewhere else. then you will be able to do your work