[Part 6] Creating Data Entry Forms (Microsoft Access) Cambridge IGCSE ICT (0417)
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 2024
- Learn all about creating Data Entry Forms in Access. Editing forms so that they are user friendly and to control the data being added.
The tutorial is primarily focused at students taking the Cambridge 0417 ICT IGCSE examination but is ideal for anyone.
0:00 Intro
1:05 What is a data entry Form, why do we use them and not add data directly to the table, how does a form work
5:01 what makes a form user friendly, formatting, list boxes, limit to list, control buttons
10:27 Creating a Data Entry Form
12:35 Changing views
Modifying the generated form
13:07 Changing colour of objects
13:41 Changing the title
14:04 Adding a label with personal details (difference between a label and text box)
14:57 Resizing multiple objects
15:45 Replacing an object with a 2-column combo box
19:37 Combo box with limit to list and control source added manually
23:03 Renaming the form name
24:49 Combo Box based on a table and limit to list
27:06 Adding an option group (radio buttons) and setting the values to be stored. Showing evidence of values stored
32:28 Add control buttons (Next/Previous/Add New/ Delete)
34:52 Aligning objects on the form
35:41 Formatting colours to make data stand out. Final adjustments
36:39 Sum up and testing
![[Part 5] Creating Labels (Microsoft Access) Cambridge IGCSE ICT (0417)](http://i.ytimg.com/vi/DhYYgQhHp_A/mqdefault.jpg)
![[Part 5] Creating Labels (Microsoft Access) Cambridge IGCSE ICT (0417)](/img/tr.png)
![PowerPoint complete guide, [Cambridge IGCSE ICT 0417]](http://i.ytimg.com/vi/TRHfD3RP9cg/mqdefault.jpg)
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
mine is in 2 hours😥
Hope it went well
my exam is tomorrow and i didn't remember anything related to creating forms your an absolute life saver!!!
Good luck. Glad this helped you. Make sure to come back and let us know how you did.
same
We all have paper 2 tmr 😭😭😭
yep, my students also.
yeah fr 😭
@@paphitisn any tips
Sir please how do you store text in an option group
I have it in 45 mins 😭😭
bro what why r u so underrated like bro saved all ICT students' lives istg. Thankyou sir I really mean it!!!!!!
🥰🥰
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.
@@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
@@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.
exam in less than 5 hours thank u so much u saved my life.
What mines in 2 hours 😭
@aetrna6552 haha gl g.
@@aetrna6552 me too
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.❤
same! how was it?
@@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
@@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.
@@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.
@@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
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 :)
Thank you for your kind words. Good luck and make sure to let us know how you did.
@@paphitisn Ohhh man, it went great. Especially the forms part, the video really helped me out. Thanks so much 👍
@@Rizwanraja5 Fantastic, well done!!!
i thank you very much for this i think we all got a paper 2 tmrw and we all needed this
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!
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.
Same.. IGCSE paper 2 may/june 2023
Thank u for these, our teachers dont go it into this much depth for each and every section
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
@@paphitisn i have watched most of them already, i find them most useful for my prep
@@damian2972 that's good to hear
Thanks a lot it really helped. I was having trouble with access since im new to it and this really really helped.
that's great, thanks for the feedback
Thanks for this one Nicos! really struggled with it during mocks.
Thank you for this video. Amazing explanation. Full of useful information. Im implementing this in my current role
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.
thank for teaching how to make radio buttons my exam is in 9 hrs you are a live saver
I am glad the tutorial helped you. Get some rest before the exam and good luck.
Thank you for this video, it significantly helped making my Maintenance data entry form
That's great. Thanks for the feedback
Thank you so much for these videos. They really help me a lot to study for the exam.
I am glad they are supporting your learning. Thanks for the comment.
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.
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.
@@paphitisn Thank you, I definitely will. I wish your students good luck too.
@@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.
@@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.
@@paphitisn thanks to you too.
I wish I found this channel earlier. 😭😭😭 You're a LIVE SAVER my P2 is tomorrow.
good luck mate! i also have paper 2 tomorrow
we all do don’t we 😭
Wow, you're the best teacher in the world.
I am glad you found this useful.
Thank you for your help!
All the best for tomorrow guys !!!
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!
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.
are data entry forms in the 2023 specification?
@@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"
thanks
omg same but in a few hours
I have my mid-term paper tomorrow, all of your videos really help!!
I am so glad you are finding them useful. Make sure to come back and tell us how you did in your mid-term.
Funny, I have mine tomorrow
Good luck. Let us know how you do@@mathskafunda4383
@@paphitisn I received 65/70 on this paper :D
@@emm7335that is fantastic, well done!
An awesome achievment. Thanks for comming back and letting us know
Hello ... you are amazing ...Thanks for these videos
Thank you. I am glad you find the tutorials useful.
Thank you so much for this Mr.Nicos, I have my 10th board ICT Test A tmrw... this really helped a lot...😁🙂👍
haha exams tommorow right? same here good luck
Thank you for your help
You are welcome
Thank you so much
You are welcome
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.
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.
THANKS
Is it necessary that I change the background colour of the form?
Tysm!! Could you tell me where can i find "user notes" in the form design - columnar data entry?
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.
@@paphitisn thanks man
@@chosenonesteam you are welcome
my external is tmr, im binging these hopefully i'll get a great mark inshallah!!
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.
th-cam.com/play/PLWeerq9oa1ne5T9Im1ei06yz1tUFqevel.html
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
u saved me , god bless you
And you to. I am glad it helped you .
If there are common fields in two linked tables with same value , can they be updated/ entered into with a single form ???
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.
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
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.
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?
Here are 2 links which demonstrate this process. One is for a simple import and the other is for a more complicated
th-cam.com/video/q5PJx1pReOo/w-d-xo.html
th-cam.com/video/NzCQkPH5Els/w-d-xo.html
Will return with feedbacks, right now I am watching your video on creating data entry forms
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?
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.
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.
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.
@@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?
Hey, i have a question. When adding the "Add new record" button, what is the difference between "Add new record" and "Save record"?
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.
@paphitisn oh ok, thank you so much I have my igcse final practical paper 2 tomorrow, and your videos rlly helped me.
@@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
@@paphitisn I will watch it for sure 👍
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?
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.
@@paphitisn thankyou sir, i've been searching since and this is the only thing that has helped
@@funwithbee8700 that's great. I am glad it solved your issue
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?
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.
alright thank you @@paphitisn
♥
Hi! also have my exam tomorrow. When was the last time a form has been in a paper 2? Just wondering
I don't think it appeared in 2023 but in maybe February march 2021
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.
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
@@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...
@@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
@@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.
@@BroccoliJam lets hope that P2 goes better that you expect.
best
Thanks
How do we enter only unique records using Access Forms ?
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.
@@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
@@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.
In which paper did form come in?
If you want to practice, try paper 2 from feb/march 2021
Nicos the goat
TY
I am cooked but this helped me get some how what less cooked thanks g
carful you dont get well done :) good luck with your exams and results
@@paphitisn honslety mister I got cooked by labels
@@darkknight3768 did you take the exam today? labels are not hard but they are fiddly.
@@paphitisn I took the exam today labels was hard
@@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.
the orange stands out
is this in the 2024 syllabus
Data entry forms are included in the 2023 - 2025 syllabus and will still e included in the 2026 - 2028 syllabus
Paper 2 is tomorrow lmaoo😭
Its for me in a few hours 😭
spelt external wrong.
well spotted. i am dyslexic so spelling mistakes are a challenge for me to detect.
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!
Glad you found it useful. Try putting a postit ontop of my face if it is annoying
@@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!
shut up the video is perfectly finen
Bro that’s so mean
We don’t care, the video is not only for you