IGCSE ICT May June 2020 Paper 21 Data Manipulation (Database Part 1)

Поділитися
Вставка
  • Опубліковано 19 вер 2024

КОМЕНТАРІ • 124

  • @juanbordoy9537
    @juanbordoy9537 4 роки тому +48

    The return of the king

  • @serafina2881
    @serafina2881 4 роки тому +39

    my paper is literally in an hour. Thank you so much! you’ve saved my whole class. Good luck for everyone sitting for Oct/Nov 2020

  • @waleedoo
    @waleedoo 4 роки тому +38

    Man Im now in University and still subscribed to you, nice to see the dedication, keep it up Sir.

    • @EvansChikasa
      @EvansChikasa  4 роки тому +9

      Much appreciated Waleed, I hope you are enjoying your university studies

  • @amalthiru206
    @amalthiru206 3 роки тому +20

    My 94% (A*) in ICT in June 2018 was all because of you! Thank you so much!!

    • @EvansChikasa
      @EvansChikasa  3 роки тому +6

      Wow, excellent work Amal, and thanks for using my videos. All the best in University

    • @ProGamer-wb4zs
      @ProGamer-wb4zs 3 роки тому +4

      hii amal, can we talk pls?

  • @ramandeepsingh1694
    @ramandeepsingh1694 3 роки тому +21

    Hi I just realized that you have missed one point for step 23 which is to sort your data in descending order of point. pls check

  • @joelloforte4220
    @joelloforte4220 4 роки тому +109

    Who is here because they have exams tomorrow ?😂😂

  • @appi654
    @appi654 4 роки тому +15

    Im now a university student and finished half of my degree, really happy to see you upload again and it was nice to smile and look back. Keep up the great work guiding the youth.

    • @EvansChikasa
      @EvansChikasa  4 роки тому +5

      Thank you Fawaz for dropping by. So glad to hear you are now in University. I wish you the very best for your studies

  • @romeo9782
    @romeo9782 3 роки тому +5

    This man is a real life saver 😭

  • @Momodou667
    @Momodou667 3 роки тому +5

    my practical exam is tomorrow and im telling all my friends to watch him

  • @badxbane4001
    @badxbane4001 2 роки тому +2

    you've saved the exams of my whole class and they are subscribed to you.thankx evans chikassa for this supportive content for student

    • @EvansChikasa
      @EvansChikasa  2 роки тому

      Great to hear that. Regards to the class and all the best

  • @sydneyhazel277
    @sydneyhazel277 3 роки тому +6

    thanks again!! i love the extra explanations + some small chit chat :)) makes this more fun

  • @shahidkhan-yn1jv
    @shahidkhan-yn1jv 3 роки тому +2

    brother seriously you saved my exammm......may God bless youu

  • @alexacortana123siri9
    @alexacortana123siri9 4 роки тому +13

    Sir please do the May June 2020 paper 32 as quick as possible my exam is in 3 days and your videos are amazing

    • @faheem4581
      @faheem4581 4 роки тому +1

      Yes, please upload as soon as possible, my exam is tomorrow

    • @ruthmukherjee9937
      @ruthmukherjee9937 3 роки тому

      @@faheem4581 how was ur exam😂

    • @faheem4581
      @faheem4581 3 роки тому +2

      @@ruthmukherjee9937 Practicals went awesome, theory not so good, but overall A*

    • @ruthmukherjee9937
      @ruthmukherjee9937 3 роки тому

      @@faheem4581 ayy nicee, have mine in 3 days, mocks

    • @faheem4581
      @faheem4581 3 роки тому

      @@ruthmukherjee9937 ohhh, gl

  • @irewolebolusemihi1374
    @irewolebolusemihi1374 Рік тому

    WOW my exams are in 11 days and im grinding so hard, I"ve seen all kinds of teachers but youre one of a kind thank you!

  • @5ulood3bdulla36
    @5ulood3bdulla36 4 роки тому +4

    EXAM TODAY , in 2 hours or less , need your prayers sir !

  • @oloratokefhilwe7094
    @oloratokefhilwe7094 4 роки тому +5

    i beg of you , please alevels IT

  • @jennirenepandit
    @jennirenepandit 3 роки тому +2

    THIS is a teacher.

  • @AY-Gamers7148
    @AY-Gamers7148 Рік тому

    thankss my paper is exactly after an hour you saved my life

  • @clchan1587
    @clchan1587 4 роки тому +4

    hi sir did you sort into descending order of Points?? i dont think i saw it

  • @optimus9165
    @optimus9165 Рік тому +1

    Is it bad sign if I learnt more from this than I did from 2 months of my teachers screaming her lungs out and not making sense.

  • @niayayayayayay
    @niayayayayayay Рік тому

    tmrw is my first ict board exam and i dont know ANYTHING, this man is saving my life.

  • @d3einc393
    @d3einc393 4 роки тому +4

    Hi sir , please may you kindly help with AS Level 9626 IT May/June 2020.
    Then I have a question. How come you don't do A level IT papers?😭it would be really nice if you did them. You are reliable and trustworthy lol.
    Thank you for the effort you have put to help us in different areas though😊

  • @ajarpandey7660
    @ajarpandey7660 3 роки тому

    Really ! Thankful to you as these resources help me a lot for my upcoming ICT examinations

  • @peterclaver9419
    @peterclaver9419 3 роки тому +1

    What do they mean by do not group the data

  • @tiktokfindscomp
    @tiktokfindscomp 2 роки тому

    omg thank youuu i have watched so many vids and not a single one mentioned the difference between query and report

  • @husenmosa9942
    @husenmosa9942 3 роки тому +1

    Hi
    I have a question if I created a form and entered the new record in it.
    Is it better?

  • @criminson3720
    @criminson3720 3 роки тому

    The videos u make are soo damn helpful please continue uploading good ict videos they seriously help us alot

  • @SamuraiEU
    @SamuraiEU 4 роки тому +2

    Love the videos man you helped me a ton

  • @sharanyapatel8693
    @sharanyapatel8693 9 місяців тому

    I love you and your videos you make me stressed free 😂🎉

  • @taneeshasalkar503
    @taneeshasalkar503 Рік тому

    I have a question...my yes/no shows check boxes...how do it change it to words ? and do i have too ?

  • @yeesha5674
    @yeesha5674 3 роки тому +1

    hey Mr Chikasa, I tried importing a file and Access had sent this notification 'Text file specification field separator matches decimal separator or text separator' and I'm not sure what do. May I have your assistance

    • @EvansChikasa
      @EvansChikasa  3 роки тому +2

      Hi Yeesha, which exam paper is that so I have a close look at the error?

    • @yeesha5674
      @yeesha5674 3 роки тому +1

      @@EvansChikasa Oct/Nov 2019

  • @abdussalamchaudhry
    @abdussalamchaudhry 6 місяців тому

    Hi
    One question how to remove the Am/Pm when you changed it to long time? at 9:00
    And do we lose marks if we keep it in? becuse i lost some marks in my mocks for this

  • @joelloforte4220
    @joelloforte4220 4 роки тому +1

    In question 23 about queries its double click in the right side of the mouse ?

  • @idrisisaacmohammed2495
    @idrisisaacmohammed2495 4 роки тому +1

    thank you very much chikasa the it veteran🙏
    💪

  • @RAGEFIFA2113
    @RAGEFIFA2113 4 роки тому +2

    from where can i get the files for the exam?

    • @EvansChikasa
      @EvansChikasa  4 роки тому +2

      Ahmad Aoude in the description section of this video

  • @mikemiller6635
    @mikemiller6635 3 роки тому

    love your channel keep up the good work

  • @UlemuZK
    @UlemuZK 3 роки тому

    Your videos are much appreciated , thank you

  • @ishanchoudhary4179
    @ishanchoudhary4179 3 роки тому

    30:35 Sir so if in the Or category I write 'Female' Yes and 'Expert'. It should give me proper result right?

  • @quarantinefun7390
    @quarantinefun7390 3 роки тому +1

    what do u use for taking screen shot its so quick

    • @EvansChikasa
      @EvansChikasa  3 роки тому +1

      I use a software called Lightshot. It’s free to download

    • @quarantinefun7390
      @quarantinefun7390 3 роки тому +1

      @@EvansChikasa ok thanks

  • @musa2908
    @musa2908 2 роки тому

    my paper 2 is tommorow thanks alot!

  • @rebekahmathai4544
    @rebekahmathai4544 2 роки тому

    hi, i have a question.
    1. when i made my query and tried to run it, it said the formatting wasnt the same in the query and in the table. how should i fix it?
    2. when i try to change the report from design view to layout view, it asks to enter parameter of something. i'm not sure how to do that..
    thank you

    • @EvansChikasa
      @EvansChikasa  2 роки тому

      Hi Rebekah, I am not sure about your first question unless I see a screenshot of what error you are getting. Regarding your second question, it just means the name of your run field or search criteria has a spelling error. Check that the spelling is correct and that the Capitalization is acurate. Kind regards

  • @oobryoob917
    @oobryoob917 2 роки тому

    absolute King 🙏

  • @Joseph.Jacob..7
    @Joseph.Jacob..7 Рік тому

    Sir, for Question 22, every time I try to save the database after creating the new record I receive an error stating that it was not successful because it will create duplicate values in the index, primary or relationships.
    Do you happen to know the problem behind this? If so, please tell me

    • @EvansChikasa
      @EvansChikasa  Рік тому

      Choose the correct primary key 🔑 field. You are setting a primary key on a field that has duplicate values. Primary key must be unique for every record

  • @maamnii
    @maamnii Рік тому

    MS Access is licensed software. If I want to practice at home, what are the free alternatives I can use for database. Can I use MySQL?

  • @alaaelnour3727
    @alaaelnour3727 4 роки тому

    Sir does it matter if we don't delete the date and page number in the page footer when not asked to?

  • @rouvendsouza3016
    @rouvendsouza3016 2 роки тому

    Thank you, really helpful

  • @Aaditya.GT3
    @Aaditya.GT3 3 роки тому

    PRO VIDEO HELPED ,ME A LOT

  • @Callmemaher
    @Callmemaher 3 роки тому

    Hey, I have an important question. Now, I do the report from Report and not from Report Wizard. The difference is the cell borders show up in the final printout. Will I lose mark if I do so? Or Is it accepted in the mark scheme ?
    Thanks in advance

    • @EvansChikasa
      @EvansChikasa  3 роки тому

      You can disable the borders. Take the report in Design View, select the cells with the borders, right-click and go to Properties. Under the Format tab, find Border Style and select Transparent from the options. Take it back in Report view. Hope that helps

    • @Callmemaher
      @Callmemaher 3 роки тому

      @@EvansChikasa Thank you so much. I'm truly relieved . Thanks again.

    • @EvansChikasa
      @EvansChikasa  3 роки тому

      @@Callmemaher No problem bro

  • @blessingbhebe
    @blessingbhebe 3 роки тому

    thank you sm for your help !

  • @Sheidheda670
    @Sheidheda670 4 роки тому +1

    Please Sir can you solve AS ICT june 2020? If u want the supporting files i can give them to you

    • @EvansChikasa
      @EvansChikasa  4 роки тому +1

      I will have a look at them

    • @Sheidheda670
      @Sheidheda670 4 роки тому

      @@EvansChikasa drive.google.com/file/d/16nfDsqPnhEOKqX3Kmep_ZFwYV44kl0OP/view?usp=drivesdk

  • @davidehiokioya9930
    @davidehiokioya9930 10 місяців тому

    28:31 "Women are licensed to equality" 😂

  • @bonsaidaddy9970
    @bonsaidaddy9970 Рік тому

    28:28 lmao what 💀 cool video tho

  • @MuhammadAli-wx9om
    @MuhammadAli-wx9om 3 роки тому

    thank u soo much ur the great

  • @michaelanunn1156
    @michaelanunn1156 2 роки тому

    Yay

  • @AbdulRahman-pr4vo
    @AbdulRahman-pr4vo Рік тому

    Sir, do you know where to download access for free?

    • @EvansChikasa
      @EvansChikasa  Рік тому

      No I dont. You can just get a paid version (Office365), it is safer and faster

  • @karimallam4757
    @karimallam4757 3 роки тому

    this is so useful

  • @teenXplayboi
    @teenXplayboi 3 роки тому

    Sorry but u forgot the descending order in points

  • @abdulrahmanmohamed2470
    @abdulrahmanmohamed2470 2 роки тому

    Motivational Speech 23:25

  • @sollaris_
    @sollaris_ 4 роки тому

    Sir in Paper 3 could you use VS code?

    • @EvansChikasa
      @EvansChikasa  4 роки тому

      Cynthia no you can’t, must be HTML and CSS

    • @sollaris_
      @sollaris_ 4 роки тому

      Evans Chikasa Sir I meant the program visual studio code

  • @_saif27
    @_saif27 3 роки тому

    ur amazing

  • @almoilofficial2460
    @almoilofficial2460 3 роки тому +1

    People make memes about Indians teaching, what about Chikasa?

    • @shaheer_04
      @shaheer_04 3 роки тому

      he is a legend. chikasa for life.

  • @anthonyoshijo6191
    @anthonyoshijo6191 4 роки тому

    Please you need to make your procedures more understandable

    • @EvansChikasa
      @EvansChikasa  4 роки тому

      Anthony Oshijo which part do you understand and what procedures would you recommend

  • @Astrophysicists
    @Astrophysicists 3 роки тому +1

    watch it in x1.5
    thank me later

  • @RandyTang-q3k
    @RandyTang-q3k Рік тому

    @serafina2881
    2 years ago
    my paper is literally in an hour. Thank you so much! you’ve saved my whole class. Good luck for everyone sitting for Oct/Nov 2020