thank you for the positive review. the video is not yet uploaded, but i am working on it. enable the subscribe and notification bell and you will be notified upon upload.
Pls sir i haven't been able to fill my transaction form keep saying " you cannot add or change a record because a related record is required in table customer Pls help, i have been on this since yesterday
@@ictkenyar yee, your video is "learning made easy" to be honest. I will be grateful if I can learning how to create loan and saving using access or Excel. Wit query report for month, year, interest and individual member records of savings or loan repayment.
Good question. It is not a compulsory thing to change the field size. I guess she instructed you to change the field size so that you may know how to do it. And again, I'm some cases. Where we want to increase the degree of accuracy of data input, we can change field size, input mask, text validation among others. However, since this video is meant to guide us in basic skills, that's why I ommited them, within the channel, we have more than 20 similar videos addressing different database concepts. Please go through them and you'll be a pro in databases. Thank you
Excuse me Sir but I unfortunately cannot enter my data in the transaction table since they are saying that a related record is required in customers table
That means you are supposed to feed data to the CUSTOMERS TABLE before feeding it to TRANSACTION TABLE. You should always feed data in the mother table before feeding it to the child table. Hope this helps.
Possible reasons 1. You might entered some customer id which does not exist in customer table. To solve, go back to customer table and confirm if the id in transaction matches. 2. You might have entered some product id which does not match with a product id from products table
Thanks for the inform Sir But your Speed ijoooo and you explain to yourself not to us because you do as if we know it... Yes if you know it then ull be able to relate but if you strt to relate with it it's a problem... Because how you explain it you explain as we all know it... Next time try to show it and be slow come with other alternative thanks a lot
Get more of Ms Access Database Practical though these links Normalization th-cam.com/video/ePiqVK4kgKI/w-d-xo.html COMPANY DATABASE th-cam.com/video/ZaTvAwYbtHw/w-d-xo.html KCSE 2019 th-cam.com/video/gQ8v00cV_Ko/w-d-xo.html NYANDARUA COLLEGE DATABASE th-cam.com/video/VJInWG_0bAs/w-d-xo.html STAFF DATABASE th-cam.com/video/80JesLSrKlc/w-d-xo.html KCSE 2021 th-cam.com/video/99poNpQhKkY/w-d-xo.html MASENO UNIVERSTITY DATABASE th-cam.com/video/4dRNlfGiMVs/w-d-xo.html MWANGAZA TRAINING COLLEGE th-cam.com/video/H6UgSxSV_mU/w-d-xo.html KCSE 2012 th-cam.com/video/NePvNfUrpec/w-d-xo.html SCHOOL DATABASE th-cam.com/video/5HqF-RBq2Cc/w-d-xo.html MAGARI DATABASE th-cam.com/video/Dt-8rcv_N1g/w-d-xo.html KCSE 2009 th-cam.com/video/3S2L_yqrcak/w-d-xo.html DATABASE th-cam.com/video/en0RX9lj2r4/w-d-xo.html
Usually advisable to set primary key before data capture. However, if you have already captured data, it won't be wise to erase it. Rather, ensure that the primary field has no duplicates and then set primary key
Awesome . Thanks a lot. This has helped me a great deal in preparing for the knec ICT November series
You are welcome.. hope you've seen others in my playlist
1. Word processing
2. Spreadsheets
3. Databases
4. Desktop Publishing
I'm following all your tutorials in theplaylist they are very helpful@@ictkenyar
Thank you sir❤ God bless you
Welcome
learnt alot, thank you sir!
Welcome
Thanks for the work
Welcome
You are too fast man😢😢
Thank you sir for the efforts made. How do i calcute the total payable. It wasn't clear on the screen, thanks
Welcome.. kindly quote the minute which is not clear so that I can help
@@ictkenyarI think it's Totals:[Quantity]*[Unit Price] 19:44
You are correct. Check how I applied it at 16:16
Thank you
thank u very helpful and clear
Welcome
Nice video, but do you have a video on staff loan and savings either using Microsoft Excel or Access?
thank you for the positive review. the video is not yet uploaded, but i am working on it. enable the subscribe and notification bell and you will be notified upon upload.
This was very much helpful, thank you buddy.
Welcome
Pls sir i haven't been able to fill my transaction form keep saying " you cannot add or change a record because a related record is required in table customer
Pls help, i have been on this since yesterday
Hi sir are there tutorial and if yes where are you located
We've got a lot of video tutorials with attached PDFs in the description section.
Kenya, Coast
How do you move unto the next customer after you’re done with the first .
Tap Tab key in your computer and it will make things work
Nice video soo helpful
Noted! Stay tuned by a Subscribe for more!
@@ictkenyar yee, your video is "learning made easy" to be honest. I will be grateful if I can learning how to create loan and saving using access or Excel. Wit query report for month, year, interest and individual member records of savings or loan repayment.
My new project
Will be launched soon
why didn't the field size change? when my teacher was doing it, she made us change the field size or is it not important.
Good question. It is not a compulsory thing to change the field size. I guess she instructed you to change the field size so that you may know how to do it. And again, I'm some cases. Where we want to increase the degree of accuracy of data input, we can change field size, input mask, text validation among others. However, since this video is meant to guide us in basic skills, that's why I ommited them, within the channel, we have more than 20 similar videos addressing different database concepts. Please go through them and you'll be a pro in databases. Thank you
wow you are well
@MWANAMISIHASSAN-wk7ce thank you
Excuse me Sir but I unfortunately cannot enter my data in the transaction table since they are saying that a related record is required in customers table
That means you are supposed to feed data to the CUSTOMERS TABLE before feeding it to TRANSACTION TABLE.
You should always feed data in the mother table before feeding it to the child table.
Hope this helps.
@@ictkenyar I am experiencing the same problem
I have entered the customer form and product form but the transaction form is giving me issue
Pls help
Possible reasons
1. You might entered some customer id which does not exist in customer table. To solve, go back to customer table and confirm if the id in transaction matches.
2. You might have entered some product id which does not match with a product id from products table
Great job
Thank you.
Soo nice 👍do one for SQL query please 🙏
Sure.
Here's one demonstrating SQL, but still in access
th-cam.com/video/ER-WpATwfH4/w-d-xo.html
How to return return again new forms
Thanks
May you assist me to get the paper as a pdf ??
I'll add the link just below the video now
drive.google.com/file/d/15JaIzm619nYwSECE1ZsMNDxoPnB-PEPP/view?usp=sharing
How do you a short text or a long text to text only?
Please come up again. Not able to understand the question.
I want from start
Kindly, elaborate. Thank you
This is amazing
Sure. Thank you
Hi I notice that you've dragged the box down how did you do it
thank you for the comment. kindly note down the minutes/second which shows that in my video
Thanks for the inform Sir
But your Speed ijoooo and you explain to yourself not to us because you do as if we know it... Yes if you know it then ull be able to relate but if you strt to relate with it it's a problem...
Because how you explain it you explain as we all know it...
Next time try to show it and be slow come with other alternative thanks a lot
Thank you for this view. I'll consider this in the next upload
Get more of Ms Access Database Practical though these links
Normalization th-cam.com/video/ePiqVK4kgKI/w-d-xo.html
COMPANY DATABASE th-cam.com/video/ZaTvAwYbtHw/w-d-xo.html
KCSE 2019 th-cam.com/video/gQ8v00cV_Ko/w-d-xo.html
NYANDARUA COLLEGE DATABASE th-cam.com/video/VJInWG_0bAs/w-d-xo.html
STAFF DATABASE th-cam.com/video/80JesLSrKlc/w-d-xo.html
KCSE 2021 th-cam.com/video/99poNpQhKkY/w-d-xo.html
MASENO UNIVERSTITY DATABASE th-cam.com/video/4dRNlfGiMVs/w-d-xo.html
MWANGAZA TRAINING COLLEGE th-cam.com/video/H6UgSxSV_mU/w-d-xo.html
KCSE 2012 th-cam.com/video/NePvNfUrpec/w-d-xo.html
SCHOOL DATABASE th-cam.com/video/5HqF-RBq2Cc/w-d-xo.html
MAGARI DATABASE th-cam.com/video/Dt-8rcv_N1g/w-d-xo.html
KCSE 2009 th-cam.com/video/3S2L_yqrcak/w-d-xo.html
DATABASE th-cam.com/video/en0RX9lj2r4/w-d-xo.html
Thax alot bro
Welcome
Thank you
Thanks alot
Best 😊
Thank you
Thnks
I too i Can enter m'y primary Key
Usually advisable to set primary key before data capture. However, if you have already captured data, it won't be wise to erase it. Rather, ensure that the primary field has no duplicates and then set primary key
Thank you
Welcome
I ❤ The class
Welcome. Be free to watch more of these tutorials from the channel
How can we get the questions to try it?
Hello friend. I'm organizing for a website where I can be posting those question for ease download.
here is a link
drive.google.com/file/d/15JaIzm619nYwSECE1ZsMNDxoPnB-PEPP/view?usp=sharing
Your too fast
Sorry for that, kindly check at the bottom part there is setting icon, where you can adjust the play speed
Thnk you sir
All the best
You are too fast man😢
not helpful
What were you searching? Your input might be helpful when creating another video.
Thank you