[Part 6] Creating Data Entry Forms (Microsoft Access) Cambridge IGCSE ICT (0417)

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

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

omarmansour-zzpw
Автор

my exam is tomorrow and i didn't remember anything related to creating forms your an absolute life saver!!!

awsali
Автор

bro what why r u so underrated like bro saved all ICT students' lives istg. Thankyou sir I really mean
🥰🥰

abcdfu
Автор

exam in less than 5 hours thank u so much u saved my life.

mayterapyo
Автор

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.❤

maiabethel
Автор

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 :)

Rizwanraja
Автор

thank for teaching how to make radio buttons my exam is in 9 hrs you are a live saver

muhammadibrahimshahid
Автор

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!

zaara
Автор

i thank you very much for this i think we all got a paper 2 tmrw and we all needed this

liaqatsaeed
Автор

I wish I found this channel earlier. 😭😭😭 You're a LIVE SAVER my P2 is tomorrow.

diamondduck
Автор

Thank u for these, our teachers dont go it into this much depth for each and every section

damian
Автор

Wow, you're the best teacher in the world.

ronnymwaetako
Автор

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.

Aim_bot
Автор

Thank you for this video. Amazing explanation. Full of useful information. Im implementing this in my current role

GreekNinjakai
Автор

Thanks a lot it really helped. I was having trouble with access since im new to it and this really really helped.

reuex
Автор

Thank you so much for these videos. They really help me a lot to study for the exam.

notjew_el
Автор

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!

hudilyasa
Автор

Thanks for this one Nicos! really struggled with it during mocks.

nigeshsadhu
Автор

I have my mid-term paper tomorrow, all of your videos really help!!

emm
Автор

my external is tmr, im binging these hopefully i'll get a great mark inshallah!!

dzbomxi