How do I create an inventory database in Access?

Question

I would like to know if anyone could explain how I could run an application in Access that would help my company. I own a chain of snack and coffee machines spread around my county. I would like to create an application in Access that would help me out and keep an eye on the actual stock that I have. I would also like the basic inventory database to change as I introduce new values when I buy merchandise for the machines (ex. coffee, milk, etc.)

Also I would like the application to automatically change when I put the merchandise in the machines with the help of a Form.

To be more concrete on what I would like here is a small visual text.

Shopping/Supply ----->Current Stock<----->Vending Machines

Could you guys give me a little help, or show me some sites that might help me on this topic?
I have some idea of how Access works but I just can't figure out exactly how to do it.

Thanks

Answer 1

Access Inventory Database Template

Answer 2

As an office manager, you know that effective inventory management is more than counting the number of widgets on your shelves. Management inventory can translate into good customer service, but businesses of different sizes have different needs. Which method is best for your organization?



Some large companies employ inventory consultants, who design and manage inventory systems. Other companies don't require a complex inventory management system and keep track of inventory by using Microsoft Office Excel 2003 worksheets. It is important to decide which inventory management tool will work best for the size and type of business that you manage. In the end, of course, it's the accuracy of the method that counts.



Some accounting systems provide inventory control features. You might decide, however, to create your own, separate inventory management database. Building your own has many advantages, including customizing fields and reports specific to your business and creating a system that is available to and usable by all your employees.



The following tools and information will help you identify and implement the right inventory management strategy for your business.



* Create an Access database (Article)

Design and create an inventory management database that works for you.

* Supplier list (8 1/2 x 14, landscape) (Template)

Use this Excel template to easily keep track of your suppliers.

* Inventory management database (Template)

Use this Access template as a starting point for developing an inventory management database specific to your business.

* Inventory list (Template)

Use this Excel inventory template to create a line-item list of your entire inventory.

Answer 3

You need to create a query that will allow you to take the sales from the quantity of an item on hand. Seems to me quantity on hand should not be part of the item description table, since that is the difference between purchases and sales. The query becomes your inventory, drawing item description, purchases and sales information together. Items on hand is just purchases less sales. When you sort by item it will give you itemized inventory.

Answer 4

My advice is to go to the bookstore and buy a book on MSAccess. You have alot to learn if you are starting from no programming or database experience. You may want to find a local company and contract the job out.