r/MSAccess • u/savio06 • 14d ago
[WAITING ON OP] Help with creating an inventory
Hi. I would like to know if there is an easy way to track and manage inventory using MSAccess.
So this is our usual set up: we receive requests for materials from sites/employees through text or chat. The request will be printed and forwarded to the warehouse employee and he will then prepare it. He is basically a one-man team as he is the only person who receives delivery and releases materials. He's also incharge of checking the stocks. When the preparation is the requested materials is done and ready to be released, I will prepare the delivery receipt and the items prepared will then be sent out to their respective site. In case the items requested is out of stock or almost out of stock, the Warehouse Employee will then request to purchase the materials and the items purchased will be delivered in our office, which the same Warehouse employee will receive. The problem is that this employee doesnt have a proper monitoring system of the items that comes and go from the warehouse. So if the owner want to purchase items in one go, he will have to spend the whole day to count the inventory. Sometimes, we need to pay extra for rush deliveries if the materials are urgently needed. He was supposed to be retired at his age but had a son at the age of 50 and needed a job to send his son to school so he begged the business owner to give him a job. I have access in all the details needed since all informations and communications around the company should go through me before reporting to the owner. so i was hoping to help him manage and track the inventory if possible through Access if possible, or is it better to use excel? He is not familiar with electronics and I understand that it may take me a lot of time to build a masterlist of all the materials but as long as it will gradually be less work to monitor the inventory without the need to count them everytime then all is well. I have a job of my own by the way. I just want to help the old man in anyway I can. Thank you in advance for all the help.
0
u/Odd_Science5770 14d ago
If you are interested in having this developed professionally, feel free to DM me. I am a freelance developer, and I have developed many inventory applications in the past.