DATABASE PRACTICAL FULL 3: MIS DATABASE|TABLES, FORMS, QUERIES, RELATIONSHIPS AND REPORTS

No video

DATABASE PRACTICAL FULL 3: MIS DATABASE|TABLES, FORMS, QUERIES, RELATIONSHIPS AND REPORTS

Рет қаралды 67,336

ICT KENYA

Күн бұрын

Пікірлер: 60

@christophernjenga6708 11 ай бұрын

Awesome . Thanks a lot. This has helped me a great deal in preparing for the knec ICT November series

@ictkenyar 11 ай бұрын

You are welcome.. hope you've seen others in my playlist 1. Word processing 2. Spreadsheets 3. Databases 4. Desktop Publishing

@christophernjenga6708 11 ай бұрын

I'm following all your tutorials in theplaylist they are very helpful@@ictkenyar

@MitzieFaleisha 2 ай бұрын

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.

@ictkenyar 2 ай бұрын

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

@MWANAMISIHASSAN-wk7ce 2 ай бұрын

wow you are well

@ictkenyar 2 ай бұрын

@MWANAMISIHASSAN-wk7ce thank you

@sydneymcdonald1494 Ай бұрын

Thnks

@lizzrutendomuchena6864 2 ай бұрын

thank u very helpful and clear

@ictkenyar 2 ай бұрын

Welcome

@jeilanmohdhar1623 4 ай бұрын

How do you move unto the next customer after you’re done with the first .

@ictkenyar 4 ай бұрын

Tap Tab key in your computer and it will make things work

@helenonwuchekwa152 2 ай бұрын

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

@artfulwaps5928 Ай бұрын

Thanks for the work

@ictkenyar Ай бұрын

Welcome

@tshepomokgoro2941 4 ай бұрын

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

@ictkenyar 4 ай бұрын

Thank you for this view. I'll consider this in the next upload

@yohannaagbanaji8012 2 жыл бұрын

Nice video, but do you have a video on staff loan and savings either using Microsoft Excel or Access?

@ictkenyar 2 жыл бұрын

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.

@salmaabdullahi9833 9 ай бұрын

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

@ictkenyar 9 ай бұрын

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.

@helenonwuchekwa152 2 ай бұрын

@@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

@ictkenyar 2 ай бұрын

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

@ColetteNgadjie 3 ай бұрын

I too i Can enter m'y primary Key

@ictkenyar 3 ай бұрын

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

@user-og6qy2ty9w 6 ай бұрын

I want from start

@ictkenyar 6 ай бұрын

Kindly, elaborate. Thank you

@sarahmuwa67 4 ай бұрын

Your too fast

@ictkenyar 4 ай бұрын

Sorry for that, kindly check at the bottom part there is setting icon, where you can adjust the play speed

@ahmedmohamud1619 Жыл бұрын

Thanks May you assist me to get the paper as a pdf ??

@ictkenyar Жыл бұрын

I'll add the link just below the video now

@ictkenyar Жыл бұрын

drive.google.com/file/d/15JaIzm619nYwSECE1ZsMNDxoPnB-PEPP/view?usp=sharing

@denzomazina Жыл бұрын

Great job

@ictkenyar Жыл бұрын

Thank you.

@lucifermorningstar-qg6nw 23 күн бұрын

How do you a short text or a long text to text only?

@ictkenyar 23 күн бұрын

Please come up again. Not able to understand the question.

@zedomke8347 2 жыл бұрын

Nice video soo helpful

@ictkenyar 2 жыл бұрын

Noted! Stay tuned by a Subscribe for more!

@yohannaagbanaji8012 2 жыл бұрын

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

@ictkenyar 2 жыл бұрын

My new project Will be launched soon

@JanetShilumba-ju9eg 3 ай бұрын

This is amazing

@ictkenyar 3 ай бұрын

Sure. Thank you

@user-oi3th4mg4s 3 ай бұрын

Soo nice 👍do one for SQL query please 🙏

@ictkenyar 3 ай бұрын

Sure. Here's one demonstrating SQL, but still in access kzfaq.info/get/bejne/e7hditNyud3KeGg.html

@ntombizanelezide7849 Жыл бұрын

Hi I notice that you've dragged the box down how did you do it

@ictkenyar Жыл бұрын

thank you for the comment. kindly note down the minutes/second which shows that in my video

@MaeregAsnake-ez2wj 3 ай бұрын

Best 😊

@ictkenyar 3 ай бұрын

Thank you

@edible109 Жыл бұрын

This was very much helpful, thank you buddy.

@ictkenyar Жыл бұрын

Welcome

@AmbinpohBoris-ho5yb 3 ай бұрын

I ❤ The class

@ictkenyar 3 ай бұрын

Welcome. Be free to watch more of these tutorials from the channel

@matildaotoo3103 2 жыл бұрын

How can we get the questions to try it?

@ictkenyar 2 жыл бұрын

Hello friend. I'm organizing for a website where I can be posting those question for ease download.

@ictkenyar Жыл бұрын

here is a link drive.google.com/file/d/15JaIzm619nYwSECE1ZsMNDxoPnB-PEPP/view?usp=sharing

@esthersperspective 5 ай бұрын

Thank you

@ictkenyar 5 ай бұрын

Welcome

@nambagovicent8747 Жыл бұрын

Thnk you sir

@ictkenyar Жыл бұрын

All the best

@ictkenyar Ай бұрын

Get more of Ms Access Database Practical though these links Normalization kzfaq.info/get/bejne/m7aZpLl8mdHLe30.html COMPANY DATABASE kzfaq.info/get/bejne/kMeEqaSovsjYeKs.html KCSE 2019 kzfaq.info/get/bejne/nbdoqZNhyLzDe6M.html NYANDARUA COLLEGE DATABASE kzfaq.info/get/bejne/jLB5obp4xJbGcac.html STAFF DATABASE kzfaq.info/get/bejne/bpZ6mNZ9uNivnJc.html KCSE 2021 kzfaq.info/get/bejne/b5-gorGhts6vm40.html MASENO UNIVERSTITY DATABASE kzfaq.info/get/bejne/asqCgc-XrM-xhqc.html MWANGAZA TRAINING COLLEGE kzfaq.info/get/bejne/fpyFmrapuLzDnYk.html KCSE 2012 kzfaq.info/get/bejne/hMuAqbGXutjUlZc.html SCHOOL DATABASE kzfaq.info/get/bejne/a66heZCDp9eWc5c.html MAGARI DATABASE kzfaq.info/get/bejne/etpda9WU28WyYZs.html KCSE 2009 kzfaq.info/get/bejne/ablif8Kq1tjHkZ8.html DATABASE kzfaq.info/get/bejne/m9Rghbtq0dCWomg.html