Тёмный

Inventory management system in Microsoft Access 

DataTechs Tutorials
Подписаться 9 тыс.
Просмотров 63 тыс.
50% 1

Опубликовано:

 

11 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 102   
@usmanyousaf567
@usmanyousaf567 Год назад
Thank you for the great tutorial. I am a noob in terms of MS Access, but I was able to make my own customized stock database based on your video.
@Sillywitchlove
@Sillywitchlove 16 дней назад
I LOVE your tutorials! So easy to folllow along. Thank you so very much!
@datatechstutorials
@datatechstutorials 16 дней назад
You are welcome.thanks for following.
@herobay9836
@herobay9836 2 года назад
Excellent tutorial. watching this live, from kumasi ghana.
@datatechstutorials
@datatechstutorials 2 года назад
Awesome! Thank you!
@faisalrafiq2107
@faisalrafiq2107 Год назад
Thanks for sharing very useful 👍 Thanks for your efforts appreciated
@essicstroman5485
@essicstroman5485 Год назад
Best tutorial I've seen on MS Access. Thank you
@datatechstutorials
@datatechstutorials Год назад
Glad it helps sir.
@dezainsdezains5048
@dezainsdezains5048 Год назад
Easy and nice way to explain
@kennethfrank
@kennethfrank Год назад
Hi, this is such an important video. Many Thanks
@datatechstutorials
@datatechstutorials Год назад
Glad it was helpful!
@kaaviya8213
@kaaviya8213 3 месяца назад
Your tutorial was very much helpful ❤
@datatechstutorials
@datatechstutorials 3 месяца назад
Thank you.
@christianadugyanson1547
@christianadugyanson1547 Год назад
Very useful tutorial. Keep doing it
@datatechstutorials
@datatechstutorials Год назад
Thank you sir
@trent3191
@trent3191 2 года назад
This was very helpful! Thank you
@datatechstutorials
@datatechstutorials Год назад
Glad it was helpful!
@CodingwithSaim
@CodingwithSaim 2 года назад
Best Tutorial which absolutely need appreciation
@datatechstutorials
@datatechstutorials 2 года назад
Many many thanks
@CodingwithSaim
@CodingwithSaim 2 года назад
@@datatechstutorials I am also a RU-vidr and I know how much difficult this is
@datatechstutorials
@datatechstutorials 2 года назад
@@CodingwithSaim Yes you're indeed right.
@abbyjchannel8462
@abbyjchannel8462 Год назад
Thank you sir, I successfully create my inventory, what I want to know is how to create the sales daily sales report and how to add amount
@totalcuretosexualdysfuncti9899
@totalcuretosexualdysfuncti9899 Месяц назад
Thank sir.
@tevinmoodley349
@tevinmoodley349 10 месяцев назад
Thank you for the assistance
@datatechstutorials
@datatechstutorials 9 месяцев назад
I'm glad the video helps you.
@tevinmoodley349
@tevinmoodley349 9 месяцев назад
@@datatechstutorials it did, passed a final year engineering project using some of your tips. Much appreciated.
@datatechstutorials
@datatechstutorials 9 месяцев назад
@@tevinmoodley349 glad you succeeded bro
@ebadkhan3286
@ebadkhan3286 Год назад
Superb
@odunayoemmanuel6274
@odunayoemmanuel6274 2 года назад
This is so helpful. Buy you forgot to drop a link to download this *winks
@datatechstutorials
@datatechstutorials 2 года назад
Yes sorry sir, email me to receive the file.
@dafinehun8874
@dafinehun8874 Год назад
Dear Teacher, When I entry 2 or 3 stock out transactions of the same product, the data in field "SumofQuantity Added" of Query "Remains" is increased double (for example: firstly, stock in of keyboard is 200. after you stock out keyboard 6 then the stock in of keyboard is increased from 200 to 400.). Please kindly check it again. Thanks.
@datatechstutorials
@datatechstutorials Год назад
Hello...sorry for this. Try watching this second video in the playlist and I'm sure you will be sorted. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sTQ9hYMXDe0.html
@dafinehun8874
@dafinehun8874 Год назад
@@datatechstutorials Yes, thanks for your next videos. It's very helpful. My database is completed. Thank you so much.
@lokalitepam8395
@lokalitepam8395 Год назад
A super video
@datatechstutorials
@datatechstutorials Год назад
Thanks
@MukweLaif
@MukweLaif 5 месяцев назад
Hello, thank for the tutorials. They are the best ive seen. But the link to this partivular project is not available whilst you mention it is in the video
@datatechstutorials
@datatechstutorials 5 месяцев назад
Sorry sir. I will work on this so try to check later on.
@kenowusu2155
@kenowusu2155 11 месяцев назад
Excellent video. I have a long list of items but are in Excel. How do i import the list to my product list in access?
@datatechstutorials
@datatechstutorials 9 месяцев назад
use the external tab in microsoft access to import from excel. but make sure excel sheet columns are consistent with that of the ms access table in terms of datatype and note attribute necessarily.
@kumarabhijeetranjan2304
@kumarabhijeetranjan2304 Год назад
Hi, thank you for the useful video. How can we add inventory levels like reorder level or minimum reorder quantity features. Thank you
@datatechstutorials
@datatechstutorials Год назад
Great suggestion. You can add a minimum level field in the product table. Whilst having that you can call the field in queries to be used in further programmng
@isaacnijuban487
@isaacnijuban487 2 года назад
Great job Smaila
@datatechstutorials
@datatechstutorials 2 года назад
Thank you Isaac
@user-ip9iw2cr9v
@user-ip9iw2cr9v 11 месяцев назад
hi there, I can see that the stock remains query will not include some products if the stock out is 0. Is there a way around this, the other You Tube video has a completely different start of the stock management system but I really like this format is there a way to do it with this template? Ty
@datatechstutorials
@datatechstutorials 10 месяцев назад
Yes, there are two videos on inventory can you check
@abufkes1
@abufkes1 10 месяцев назад
👌
@hafeez1434
@hafeez1434 Год назад
Sir, It was a very beneficial , How can i add the rate and multiply with quantities to see the value of stock ?
@datatechstutorials
@datatechstutorials Год назад
At product add rate, now call in in queries to perform such calculation
@asroofficial2044
@asroofficial2044 Год назад
thank you teacher
@datatechstutorials
@datatechstutorials Год назад
you're welcome
@ams7039
@ams7039 2 года назад
This really helpful thank you. But where is the download link ?
@datatechstutorials
@datatechstutorials 2 года назад
Sorry sir, unfortunately there is no download link for this lesson. looking forth to placing download links in future videos. Thank you
@SothearakHeng
@SothearakHeng 4 месяца назад
Hello sir I follow your tutorial but my quantity in stockin always multiply by everytime I add stockout and I don't know why it always multiply when I query it to calculate the remainings Can u give me any feedback?
@datatechstutorials
@datatechstutorials 4 месяца назад
sorry for this sir. Could you check out this video to correct that ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sTQ9hYMXDe0.html . If it is still not resolved afterwards, you can send me a message. Good luck
@albayano
@albayano Год назад
thank you for this.... i am looking for the Print menu
@datatechstutorials
@datatechstutorials Год назад
ok sir
@opentrainingcamp
@opentrainingcamp 2 года назад
🥰🥰🥰🥰🥰🥰🥰🥰
@usamahameed5873
@usamahameed5873 Год назад
How can i add the lest box like product name stockin dates and qty for each product separately. Same for the stockouts
@nightmare1411
@nightmare1411 Год назад
Hi the form showing a stock quantity only works when a stock out transaction is made, until then it does not show the stock. How can you get around this?
@datatechstutorials
@datatechstutorials Год назад
please watch this other video to get around this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sTQ9hYMXDe0.html
@mohei95
@mohei95 Год назад
Thank you for your effort but I can tell that you make the sample things goes very hard to follow
@datatechstutorials
@datatechstutorials 4 месяца назад
Sorry for this sir.
@jamesmakau
@jamesmakau Год назад
Am stuck where you are adding "new" and "delete" buttons to stockings form. when I try to add a new button the command box isn't popping out
@datatechstutorials
@datatechstutorials Год назад
It's because you do this whilst the form is opened as subform. Try editing a subform alone I mean having on the subform opened in it's design view and this should work.
@mokkefuhua9928
@mokkefuhua9928 Год назад
Once we know how much the remaining of the items went out, how do you calculate if another items is being added in or stock in?
@datatechstutorials
@datatechstutorials Год назад
This video in the playlist will help: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sTQ9hYMXDe0.html
@deenourdunyaeksaath5784
@deenourdunyaeksaath5784 2 года назад
Sir I made as you thought us but after finalized I made new inventory unfortunately nothing being updated accept product TB kindly make new inventory in this project to understand clearly thanks
@datatechstutorials
@datatechstutorials 2 года назад
Alright sir. Thank you
@wanjeridaniel-qm5fh
@wanjeridaniel-qm5fh Год назад
Thanks for the video but I need your help for I created the system but on the search button isn't working
@datatechstutorials
@datatechstutorials Год назад
okay send me WhatsApp message. Thx
@tangopeter1
@tangopeter1 6 месяцев назад
i have problem inserting the two buttons with the wizard add and delete in stock in form in stockings part. I can insert a button manually but then i'm stuck since i don't got wizard part... @40:10 mins. i don't know how to do that part with wizard or activate wizard
@datatechstutorials
@datatechstutorials 6 месяцев назад
Hello, make sure you are not adding the button to the subform whilst it is in the parent form. Open the subform as a single form, add the button and the wizard will come.
@MultiBert29
@MultiBert29 6 месяцев назад
I have the same issue; I tried a different way and it worked for me. Close the current "Stock In" form and go to "Stockings" form instead. From there, add the two buttons (New and Delete). Save it, Close the "Stockings" form and go back to "Stock In" form. I hope this helps you too...
@samuelbystrian559
@samuelbystrian559 Год назад
Hello sir, can I ask one question? Is it possible somehow to get a monthly summary of stock ins and stock outs?
@datatechstutorials
@datatechstutorials Год назад
Yes sir, it is very possible. a lil bit of querying and reporting skills will do.
@samuelbystrian559
@samuelbystrian559 Год назад
Do you have any additional video about this?
@datatechstutorials
@datatechstutorials Год назад
@@samuelbystrian559 check for additional videos in the playlist.
@sopatsartajwani
@sopatsartajwani Год назад
my tables show an error " no unique index found for the reference field of the primary table" while creating relationship plz help
@datatechstutorials
@datatechstutorials Год назад
ensure that, your foreign key is properly set as primary key in the source table
@rubenrivera1931
@rubenrivera1931 Год назад
@@datatechstutorials Hi, I have the same issues and the Primary key is properly set but still shows the error.
@rubenrivera1931
@rubenrivera1931 Год назад
I tried to redo it again and almost copy your tutorials but still the same.
@thomascolley5912
@thomascolley5912 7 месяцев назад
How do we add pricing, package price, piece price, total out, total in of each item
@sardaruzairtechno9346
@sardaruzairtechno9346 2 года назад
sir please download link
@user-fv7dy6bv9z
@user-fv7dy6bv9z Год назад
Hi....How can i use this system to calculate profits made?
@datatechstutorials
@datatechstutorials Год назад
you need to update it sir. You can contact me via the description for help
@AriSorani
@AriSorani 2 года назад
thank you bro amazing
@datatechstutorials
@datatechstutorials 2 года назад
Glad it helped
@tuamaleos4519
@tuamaleos4519 Год назад
Please share this file example MS Access... Thankyou
@datatechstutorials
@datatechstutorials Год назад
Ok wait
@atokwamena4139
@atokwamena4139 Год назад
Please I want access to deduct loan principal and interest automatically from the customer's account every weekly or monthly
@datatechstutorials
@datatechstutorials Год назад
Check video description to contact me pls
@josephmalcolmcaymo4852
@josephmalcolmcaymo4852 4 месяца назад
Wheres the link for the download file? thanks
@datatechstutorials
@datatechstutorials 3 месяца назад
unfortunately this file is not available
@justiceeffuate4993
@justiceeffuate4993 Год назад
how do I create monitoring systems of medical products in ms access
@datatechstutorials
@datatechstutorials Год назад
Contact me via email sir. Check video description for details.
@credov.k2594
@credov.k2594 8 месяцев назад
good but not files to share?
@datatechstutorials
@datatechstutorials 8 месяцев назад
Yes, sorry this file is not available.
@azharkhanlangah
@azharkhanlangah 5 месяцев назад
can i get this file please?
@datatechstutorials
@datatechstutorials 4 месяца назад
Sorry, currently we have lost this file. but you can check the playlist for similar ones
@SamiGhaith-by2yw
@SamiGhaith-by2yw 4 месяца назад
🫥🫥
@thilansasintharandeniya9747
Hi
@datatechstutorials
@datatechstutorials Год назад
Hello, feel free to contact me via details in the video description sir. If it's regarding the tutorial kindly share here. Thx
Далее
Почему не Попал?!
00:15
Просмотров 27 тыс.
To mahh too🫰🍅 #abirzkitchen #tomato
01:00
Просмотров 3,4 млн
Apple Event - September 9
1:38:50
Просмотров 25 млн
How to use Microsoft Access - Beginner Tutorial
31:07
Inventory Management Template for Store
41:22
Просмотров 462 тыс.
Build a Microsoft Access App for tracking sales orders
52:41
Cursor Is Beating VS Code (...by forking it)
18:00
Просмотров 67 тыс.
Почему не Попал?!
00:15
Просмотров 27 тыс.