my exam is tomorrow and i didn't remember anything related to creating forms your an absolute life saver!!!
@paphitisn4 ай бұрын
Good luck. Glad this helped you. Make sure to come back and let us know how you did.
@muhammadibrahimshahid77854 ай бұрын
same
@omarmansour-zz7pw4 ай бұрын
im doing paper 2 in a 5 hours and i really wanted to thank you for your lifesaving videos you made ict easy for me
@user-fj9sd8hy4q4 ай бұрын
mine is in 2 hours😥
@paphitisn4 ай бұрын
Hope it went well
@BbzBlbz4 ай бұрын
We all have paper 2 tmr 😭😭😭
@paphitisn4 ай бұрын
yep, my students also.
@kitteninforest4 ай бұрын
yeah fr 😭
@HamzaIshaq104 ай бұрын
@@paphitisn any tips
@Joy_Nels4 ай бұрын
Sir please how do you store text in an option group
@lunarcreator84244 ай бұрын
I have it in 45 mins 😭😭
@abcdfu40184 ай бұрын
bro what why r u so underrated like bro saved all ICT students' lives istg. Thankyou sir I really mean it!!!!!! 🥰🥰
@paphitisn4 ай бұрын
Thank you for your comment. I am happy that my tutorials are helping students prepare for their exams. That is what this channel is for. Good luck with your exams and results. looking forward to hearing how you do.
@marwaneltaeib21844 ай бұрын
@@paphitisn Hello is the data entry form still in the syllabus or it's removed like is it coming in tommor's exam or not
@paphitisn4 ай бұрын
@@marwaneltaeib2184 It is part of the syllabus and was included in the first variation paper last week. No one knows if it will be included in the next paper but it is likely.
@mayterapyo95164 ай бұрын
exam in less than 5 hours thank u so much u saved my life.
@aetrna65524 ай бұрын
What mines in 2 hours 😭
@mayterapyo95164 ай бұрын
@aetrna6552 haha gl g.
@user-fj9sd8hy4q4 ай бұрын
@@aetrna6552 me too
@Rizwanraja52 жыл бұрын
You are an amazing teacher. Literally taught me everything my actual teacher at school was supposed to for forms. I pray it just sticks with me for tomorrows paper :)
@paphitisn2 жыл бұрын
Thank you for your kind words. Good luck and make sure to let us know how you did.
@Rizwanraja52 жыл бұрын
@@paphitisn Ohhh man, it went great. Especially the forms part, the video really helped me out. Thanks so much 👍
@paphitisn2 жыл бұрын
@@Rizwanraja5 Fantastic, well done!!!
@muhammadibrahimshahid77854 ай бұрын
thank for teaching how to make radio buttons my exam is in 9 hrs you are a live saver
@paphitisn4 ай бұрын
I am glad the tutorial helped you. Get some rest before the exam and good luck.
@maiabethel23514 ай бұрын
Taking both practicals tomorrow and the day after wish me luck! God bless you and thank you so much for helping us sir! Your work has not gone unnoticed.❤
@fattysaad35454 ай бұрын
same! how was it?
@maiabethel23514 ай бұрын
@@fattysaad3545 oh well it was kinda ironic, the invidualtors started the exam an hour late bc they didn’t prep the room and computers before hand, some of the computers were giving algunctiosn at times and we came across something that we never went over, how to create a primary key instead of simply selecting a existing column name so yeah… All I can I say is tried my best and I pray you did well. Most of us were bitter after that
@paphitisn4 ай бұрын
@@maiabethel2351 Sounded like tough paper. lets hope they boundaries are low. Creating a primary key? So you imported the csv as a table and then you had to create a primary key? If yes then i am assuming you had to create a new field and make it an automatic number so that it filled in the data for all the records.
@akaanshakhter99364 ай бұрын
@@paphitisn Is there any video where you do this creating a primary key like you are explaining? Just asking since my exam is day after tomorrow.
@cozmorays28174 ай бұрын
@@akaanshakhter9936, my exam is the day after tomorrow and I am ready for the most part. Could u pls just tell me what came in the paper and how it was like after u do the paper. I know my paper won’t be the same
@zaara7629 Жыл бұрын
Thank you so much for these videos! I have my ICT board exam after two days and this has been extremely helpful! I need to work on creating labels so I will be watching the video you've made for that so thank you again!
@paphitisn Жыл бұрын
You are more than welcome. I am glad you are finding these tutorials useful. Good luck with your exams and make sure to come back and let us know how it went.
@E4wolf Жыл бұрын
Same.. IGCSE paper 2 may/june 2023
@liaqatsaeed79884 ай бұрын
i thank you very much for this i think we all got a paper 2 tmrw and we all needed this
@damian29726 ай бұрын
Thank u for these, our teachers dont go it into this much depth for each and every section
@paphitisn6 ай бұрын
That is a shame. I have a playlist where i solve complete past papers in depth. You will find these useful if you are taking the 0417 exam. Thanks for your comment
@damian29726 ай бұрын
@@paphitisn i have watched most of them already, i find them most useful for my prep
@paphitisn6 ай бұрын
@@damian2972 that's good to hear
@diamondduck21654 ай бұрын
I wish I found this channel earlier. 😭😭😭 You're a LIVE SAVER my P2 is tomorrow.
@kitteninforest4 ай бұрын
good luck mate! i also have paper 2 tomorrow
@liaqatsaeed79884 ай бұрын
we all do don’t we 😭
@Aim_bot873 Жыл бұрын
This video is a life saver!! I have my final exam tommorow and I didn't know how to do forms, and now because of this video I know do. Thank you.
@paphitisn Жыл бұрын
you are welcome. I am glad this helped you. Good luck with your exam tomorrow. Make sure to come back and let us know how you did. My students have the same exam tomorrow.
@Aim_bot873 Жыл бұрын
@@paphitisn Thank you, I definitely will. I wish your students good luck too.
@Aim_bot873 Жыл бұрын
@@paphitisn I just want to say one thing: The exam was too easy!! It had labels included in it so your video helped me A LOT, thanks for the video and keep up the good work.
@paphitisn Жыл бұрын
@@Aim_bot873 dont take credit away from yourself. It was easy because you prepared and worked hard for it. Well done and thnks for comming back to leave a coment. I am glad the tutorials helped. I cannot say anything about the paper yet as it is still an active paper.
@Aim_bot873 Жыл бұрын
@@paphitisn thanks to you too.
@ronnymwaetako539 Жыл бұрын
Wow, you're the best teacher in the world.
@paphitisn Жыл бұрын
I am glad you found this useful.
@GreekNinjakai6 ай бұрын
Thank you for this video. Amazing explanation. Full of useful information. Im implementing this in my current role
@paphitisn6 ай бұрын
Thanks for your comment. I am happy this has proven useful for you. Goes to show that the ICT IGCSE course is very useful as what is learnt can be implemented in a professional level.
@reuex Жыл бұрын
Thanks a lot it really helped. I was having trouble with access since im new to it and this really really helped.
@paphitisn Жыл бұрын
that's great, thanks for the feedback
@notjew_el5 ай бұрын
Thank you so much for these videos. They really help me a lot to study for the exam.
@paphitisn5 ай бұрын
I am glad they are supporting your learning. Thanks for the comment.
@victoriachung65804 ай бұрын
All the best for tomorrow guys !!!
@hudilyasa412211 ай бұрын
This series has been really helpful along with the other ICT playlists. tmrw begins my IGCSE ICT exams so im rlly thankful for these videos, it has helped me so much! Thank YOU Mr. Nicos Paphitis!
@paphitisn11 ай бұрын
Thank you for your comment. I am very happy the tutorials helped you. Good luck tomorrow and make sure to come bac and let us know how you did.
@sarvan259211 ай бұрын
are data entry forms in the 2023 specification?
@paphitisn11 ай бұрын
@@sarvan2592 Yes they are. The following is from the 2023,2024,2025 syllabus "Create a data entry form including specified fields, appropriate font styles and sizes, appropriate spacing between fields, character spacing of individual fields, use of white space, radio buttons, check boxes, drop down menus"
@sarvan259211 ай бұрын
thanks
@abeeha665511 ай бұрын
omg same but in a few hours
@emm733511 ай бұрын
I have my mid-term paper tomorrow, all of your videos really help!!
@paphitisn11 ай бұрын
I am so glad you are finding them useful. Make sure to come back and tell us how you did in your mid-term.
@mathskafunda438311 ай бұрын
Funny, I have mine tomorrow
@paphitisn11 ай бұрын
Good luck. Let us know how you do@@mathskafunda4383
@emm733510 ай бұрын
@@paphitisn I received 65/70 on this paper :D
@paphitisn10 ай бұрын
@@emm7335that is fantastic, well done! An awesome achievment. Thanks for comming back and letting us know
@nigeshsadhu4 ай бұрын
Thanks for this one Nicos! really struggled with it during mocks.
@user-dz7bo5mx5i4 ай бұрын
my external is tmr, im binging these hopefully i'll get a great mark inshallah!!
@paphitisn4 ай бұрын
good luck, here is a playlist where i solve past papers. These will definitely help. You can use the timestamps to jump to points of interest. kzbin.info/aero/PLWeerq9oa1ne5T9Im1ei06yz1tUFqevel
@user-dz7bo5mx5i4 ай бұрын
update: i probably lost a bit of marks since the header and footer kept getting deleted and had only 5 minutes to create labels.... hopefully i'll do better in p1 and p3 and get an A* or A
@LILK970 Жыл бұрын
u saved me , god bless you
@paphitisn Жыл бұрын
And you to. I am glad it helped you .
@varmaaarushkeyurigcsegrade26146 ай бұрын
Thank you so much for this Mr.Nicos, I have my 10th board ICT Test A tmrw... this really helped a lot...😁🙂👍
@Fastdawgofficial6 ай бұрын
haha exams tommorow right? same here good luck
@ren.17456 ай бұрын
Hey, i have a question. When adding the "Add new record" button, what is the difference between "Add new record" and "Save record"?
@paphitisn6 ай бұрын
Not much difference. Add New will move to the last record which is blank (thus all the text boxes in the form are empty) so you can enter the data for the new record . Save record saves the details of the record displayed in the form. So if you edit the details of a record displayed in the the form you can click on save record button to make sure the record has been updated. You can have both Add New and Save record in the form so clicking on Add new will allow you to enter the new record and once you have added the new record data you can click save record to make sure the data is written to the table.
@ren.17456 ай бұрын
@paphitisn oh ok, thank you so much I have my igcse final practical paper 2 tomorrow, and your videos rlly helped me.
@paphitisn6 ай бұрын
@@ren.1745 i will be posting another complete paper 2 in a short while (November 2023). It has 2 reports in access, so a good one to watch
@ren.17456 ай бұрын
@@paphitisn I will watch it for sure 👍
@nex55974 ай бұрын
Thank you so much
@paphitisn4 ай бұрын
You are welcome
@davidcobb81072 жыл бұрын
Thank you for this video, it significantly helped making my Maintenance data entry form
@paphitisn2 жыл бұрын
That's great. Thanks for the feedback
@chosenonesteam4 ай бұрын
Tysm!! Could you tell me where can i find "user notes" in the form design - columnar data entry?
@paphitisn4 ай бұрын
Not sure what you mean by user notes. if you want to add text on objects in the form so that the user knows what the textbox, button etc. is for then you can add control tips. In design view, select the object and in the properties find the property control tip. Type your tip or note there. When you view your form and place your mouse over the object, after a second your tip will display.
@chosenonesteam4 ай бұрын
@@paphitisn thanks man
@paphitisn4 ай бұрын
@@chosenonesteam you are welcome
@ajeebxedits9 ай бұрын
if the formatting of the labels (i.e background colors) is not specified in the exam paper can we do it ourselves to make it easier to read or will that result in deduction of marks?
@paphitisn9 ай бұрын
You can and it will not deduct marks. Providing that it does not affect what you are asked to do then you will not lose marks. Examiners mark positively, so they are trying to give marks not take them away. At the same time doing something you were not asked to do will not gain you any marks. I would be careful with background colour as it may look good on screen but the examiners will only get a printout.
@franciscojavierariza37824 ай бұрын
Hi! also have my exam tomorrow. When was the last time a form has been in a paper 2? Just wondering
@maya_0084 ай бұрын
I don't think it appeared in 2023 but in maybe February march 2021
@learnmsexcel6129 Жыл бұрын
Hi Nicos i need some help for example: i have 2 tables Table_A & Table_B ,Table-A has 3 fields Empid, Employee name, designation, department some records in this table while Table_B is blank with same fields and 1 form on which define Table_A fields. with command find button and save button, so record find from Table_A and on click save button record save in Table_B. please help me to resolved very than
@paphitisn Жыл бұрын
You need to go to the design view of the Form. Right click on the text box for the field, say Employee, and select properties. This will display the properties window of that text box. In the properties select control source and choose the field Employee from table B. Nkw the data you add will be added to the tae B Employee field.
@hudabourini8754 Жыл бұрын
Hello ... you are amazing ...Thanks for these videos
@paphitisn Жыл бұрын
Thank you. I am glad you find the tutorials useful.
@funwithbee8700 Жыл бұрын
Hi, I have a slight problem with my access When I want to use button control, it just shows command no.(e.g. command 14) and when I want to use option group control it just shows frame no.(e.g. frame 13) How do I fix this?
@paphitisn Жыл бұрын
Open your form in Design View. Then in the section of the Form Design ribbon where you see the controls like adding a button. Look at the far end to the right of that section. There is a small arrow pointing down which allows you to expand that section downwards. Click that. You will now see a menu item called "Use Control Wizards". Click that and you should be good.
@funwithbee8700 Жыл бұрын
@@paphitisn thankyou sir, i've been searching since and this is the only thing that has helped
@paphitisn Жыл бұрын
@@funwithbee8700 that's great. I am glad it solved your issue
@haladiab35244 ай бұрын
Is it necessary that I change the background colour of the form?
@raniariffat809411 ай бұрын
when the question asks us to add our name and candidate details at the end of the form, do we have to add this information in the page footer or the report footer? also, if the question asks us to put a certain phrase 'on top' of the form, does it necessarily mean that we need to place it as the title of the form or can we also add a label anywhere near the title?
@paphitisn11 ай бұрын
For the end of the page you should use page footer. If your report is more than 1 page your details will be added to all the pages. If you put report footer your details will be added only on the last page at the end of the report. For the top, then, again, if it is only one page you can add it in the title. If it says that your name should be at the top of every page the i would use the page header.
@raniariffat809411 ай бұрын
alright thank you @@paphitisn
@tanjanamdock53842 жыл бұрын
I have stock data and serial number n model ,basically organized data on excel need to move to access and have ease of access etc.what else can I do apart from importing such data?
@paphitisn2 жыл бұрын
Here are 2 links which demonstrate this process. One is for a simple import and the other is for a more complicated kzbin.info/www/bejne/p2aze6tnpbeYhdE kzbin.info/www/bejne/hKumgp6GfZp4otU
@tanjanamdock53842 жыл бұрын
Will return with feedbacks, right now I am watching your video on creating data entry forms
@BroccoliJam4 ай бұрын
Hi sir, My exam is soon. When I try to add the option group - the wizard doesn't show up and I can't find it anywhere either! Please help me.
@paphitisn4 ай бұрын
maybe a bit late now but, if you open the form in design view, form the Form Design ribbon, in the ribbon section Controls, click the down arrow to show all the controls and you will see a small text men at the bottom, click Use Control Wizards. now the wizard will open
@BroccoliJam4 ай бұрын
@@paphitisn Yep I found out via another forum online. But the terrible thing is that my paper 2 is completely cancelled now instead because the weather is still preventing us. Now I have to do well in paper 3 and paper 1 which are harder...
@paphitisn4 ай бұрын
@@BroccoliJam so you will not be taking the P2 exam and your teachers will send predicted grades? lets hope you were a good student. Don't dwell on it. Focus on what is ahead and is within your control. for P3 make sure you understand your CSS and the meta tags in the head section (i have tutorials on these). you may be asked to generate a chart in Excel so make sure you know how to do that. You will have plenty of time to think about the Excel questions so dont panic if you do not understand what you have to do immediately. review the spreadsheets and read the question multiple times and you will figure it out. Good Luck
@BroccoliJam4 ай бұрын
@@paphitisn Your advice is greatly appreciated! I have listed down the things I need to revise like a few syntaxes in html and css and formulas in excel. My predicted grades were pretty decent as I achieved a level 8 but I wanted to really push for a level 9 so I was quite disappointed I could not take P2.
@paphitisn4 ай бұрын
@@BroccoliJam lets hope that P2 goes better that you expect.
@kingsling99 Жыл бұрын
Thank you for your help!
@trapatron2 жыл бұрын
If i having a table with customers and want to pull one customers adress and phone nr etc into an orders table as an new order, how do I do this from an form entry? I know how to via an combobox lock up an customer but not how i can bring over the different fields information i want to.
@paphitisn2 жыл бұрын
The best way to do this is to first make sure your database is a relational database with a customer id field in the customers table and an the orders table. See my tutorial on relational databases. Once you have a 1 to many relationship set up you can generate a form for customers with the order tae as a sub form. You will be able to review all orders of each customer and add orders also. The above will work providing i habe understood your question.
@trapatron2 жыл бұрын
@@paphitisn Yes, I know that and the tables are arranged like that. But the combo box let you save only one field (the id) to the orders table. So the question is still how to bring over more fields to populate a new record in the orders table. Is VBA code needed?
@sallu21m Жыл бұрын
If there are common fields in two linked tables with same value , can they be updated/ entered into with a single form ???
@paphitisn Жыл бұрын
You can but you would need to add both fields in the form. If the field is Name in both tables then you would have to have the name field from 1 table added and the name field from the other. The main proem is not writting the data as you can do that with script. It is which data from which table is displayed in the form when viewing a record. If you have 2 or more tables you should not have the need to save the same data in 2 tables at the same time.
@anthonycoleman49172 жыл бұрын
Hello Many thanks for this video! My question is: In order for a form I create to make changes to the table, I have to "refresh" it. Is there a way that the form can update the table automatically as it seems to in your video? Thanks.
@paphitisn2 жыл бұрын
You are most likely facing the issue because while you are adding data through the form you also have the table open. When you have the table open it is like it is in edit mode and will not update dynamically. The table should be closed. Add all your data from the form and when you open the table it will show all the data you added. You should not really use the table. The table is the backend and should really not be accessed directly. Use queries to see your data.
@malikayan72549 ай бұрын
best
@paphitisn9 ай бұрын
Thanks
@leenaparekh7862 жыл бұрын
Thank you for your help
@paphitisn2 жыл бұрын
You are welcome
@reenamohanta2994 Жыл бұрын
How do we enter only unique records using Access Forms ?
@paphitisn Жыл бұрын
Unique records are generated by assigning a primary key in the table. Primary key fields are unique so it will not allow you to enter records were or the fields have the same data, even if you are enterin records from a form.
@reenamohanta2994 Жыл бұрын
@@paphitisn thanks for replying ... i had tried that, it is working .. I have one more issue, in my entries, we don't have unique id column, we need to concat 2-3 columns to get unique value .. now while entering data if i write formula to concat, it will show in the form but it won't get entered into the database nor will it check/alert us about duplicate values.. Can you tell how to automatic concat while filling form which will enter into the table and also be used for checking for duplicates in database
@paphitisn Жыл бұрын
@@reenamohanta2994 create a new field in the table you will be saving this new concat data. Sounds like it will be a short text field. In the properties of the short text datatype, go to index and choose Yes(no duplicates) this will make sure that no duplicate values are added in that field. Now in the form, enter design view, select the text box which you used to write the concat formula. Right click on it and select properties so the properties window opens. In the properties find control source and click the drop down arrow to select the control source. select the new field you added in the table. go to normal view of the form and now that concat data will be saved in the table under the new indexed field. You will get an error message if it generates a duplicate value.
@hojandow2014 Жыл бұрын
THANKS
@claramaia16575 ай бұрын
is this in the 2024 syllabus
@paphitisn5 ай бұрын
Data entry forms are included in the 2023 - 2025 syllabus and will still e included in the 2026 - 2028 syllabus
@submerge67194 ай бұрын
Nicos the goat
@paphitisn4 ай бұрын
TY
@gs3737811 ай бұрын
the orange stands out
@muhammadzainulabideen90269 ай бұрын
In which paper did form come in?
@emm73358 ай бұрын
If you want to practice, try paper 2 from feb/march 2021
@darkknight37684 ай бұрын
I am cooked but this helped me get some how what less cooked thanks g
@paphitisn4 ай бұрын
carful you dont get well done :) good luck with your exams and results
@darkknight37684 ай бұрын
@@paphitisn honslety mister I got cooked by labels
@paphitisn4 ай бұрын
@@darkknight3768 did you take the exam today? labels are not hard but they are fiddly.
@darkknight37684 ай бұрын
@@paphitisn I took the exam today labels was hard
@paphitisn4 ай бұрын
@@darkknight3768 I am not currently allowed to comment on the paper but if you did well in the rest of the paper then you will be fine. Good luck with your results.
@zYxr6 ай бұрын
spelt external wrong.
@paphitisn6 ай бұрын
well spotted. i am dyslexic so spelling mistakes are a challenge for me to detect.
@user-dq7ej3dk3m4 ай бұрын
♥
@omararafa52684 ай бұрын
Paper 2 is tomorrow lmaoo😭
@aetrna65524 ай бұрын
Its for me in a few hours 😭
@ziggo24882 жыл бұрын
well explained, too bad your face always has to be in the video, it's very annoying and distracting to see an extra moving video and it has absolutely no added value!
@paphitisn2 жыл бұрын
Glad you found it useful. Try putting a postit ontop of my face if it is annoying
@ziggo24882 жыл бұрын
@@paphitisn Just remove it, that's the reason I will never look at you're vids again, there are others who do even better and without the face!