I had previously read that a few people use MS Access for their inventory control. I am very interested in giving this an attempt. If you use Access could you give me an idea of how you set up your tables?
Thanks,
Amber
Hello stlmaj,
That is a very broad question. MS Access is a very user friendly tool that can help you organize all sorts of information. The best place to start is to really think about what types of information you want to compile and how this information relates to one another. Once you get hash out your intentions, I recommend going through Microsoft's online tutorial. If you have either MS Access 2003 or 2007, you can go through the tutorials here: Office Training Home Towards the middle of the page you can choose which version you have. If you have further questions after completing the training, feel free to contact me.
Take care,
Lauren ^__^aka tigressa
I use access. My main tables are Inventory, Suppliers, Sales, Finished Goods, ShowComments, Expense Type, Admin Expenses, and Inventory Type. Within each of those I have a primary key. Hope that helps.
Thank you very much. I know it won't be a small undertaking and that it may be a work in progress for quite a while.
Yes.. BUT... one thing I know for certain is that beaders are a determined lot! Good luck, and we're here to help!
Warm regards,
Laruen
Become a Member
Register online for access to more valuable resource information. Don't miss your connection to the reader forum, free projects, how to video, and more.
Not a Member? Register | Why Join?
Subscriber & Member Log In