Log in

View Full Version : Inventory Management in MS Access


shoppingeutopia
Jul 26, 2008, 01:06 PM
I am consulting a friend in his small business and he is currently using a paper system to manage his business/inventory, from order entry to invoice. I understand that MS Access is capable of doing this, i.e. create a database for inventory and enter orders that deprecate that inventory, add to that database as new inventory arrives, and eventually produce an invoice for the customer. Is this correct? If so, how? If not, are there other off the shelf software or freeware/shareware (not custom products) available. This is a very small business just trying to get off the ground. I appreciate any help you can offer.

Sincerely

Shoppingeutopia

Clough
Jul 27, 2008, 02:23 AM
I'm not sure about all of the capabilities of Microsoft Access as I am just learning it myself. However, I do know that there are a number of free, online tutors for it on the Internet. So, you might want to try some of those. Here is the link to the search for them. Microsoft Access Free Online Tutor - Google Search (http://www.google.com/search?hl=en&safe=off&q=Microsoft+Access+Free+Online+Tutor)

I am curious as to what type of business this is concerning and exactly what you mean by the word "depreciate" as I think that someone who really knows how to manage an inventory will be needing to know those things.

I have a number of small businesses that I run. I use Microsoft Excel and Microsoft Word for all of them, depending on the function that I am needing to perform. I don't really have an inventory that I need to keep track of for customers, though.

Hopefully, someone will come along who knows about managing a business with an inventory to keep track of for the business as well as the customers.

If there's any way that I could be of assistance, such as that concerning advertising, please let me know. Among other things, I really know about the advertising end of a small business.

Thanks!