Get more of Ms Access Database Practical though these links Normalization ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ePiqVK4kgKI.html COMPANY DATABASE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZaTvAwYbtHw.html KCSE 2019 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gQ8v00cV_Ko.html NYANDARUA COLLEGE DATABASE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VJInWG_0bAs.html STAFF DATABASE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-80JesLSrKlc.html KCSE 2021 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-99poNpQhKkY.html MASENO UNIVERSTITY DATABASE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4dRNlfGiMVs.html MWANGAZA TRAINING COLLEGE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H6UgSxSV_mU.html KCSE 2012 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NePvNfUrpec.html SCHOOL DATABASE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5HqF-RBq2Cc.html MAGARI DATABASE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Dt-8rcv_N1g.html KCSE 2009 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3S2L_yqrcak.html DATABASE ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-en0RX9lj2r4.html
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
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.
@@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.
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
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
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
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