3/31/2008 9:32:35 PM
Inventory Control in Access
By Richard Rost
Q: What course do I need to track inventory for three locations? I have used Excel for 10+ years. I need a customer list, product list, etc. I want to be able to enter customer data on a form, along with products and keep track of inventory. I want to keep it simple so others can use. This is currently done on paper and I keep track of inventory manually - three locations by hand. I have Access 2003 and 2007 just need help in putting them to good use. - Gene
A: Gene, I see you've already taken my Access 101 and 102 classes. You're off to a good start. I'm going to be dealing with TRACKING INVENTORY in an upcoming Access class very soon here (within the next two or three weeks). I'll be honest... tracking inventory is NOT easy. It does require a little bit of programming to do it right AND make it easy for your non-programmer end-users. I'll be showing you how to do it. In the mean time, get caught up with the rest of the 100-, 200-, and 300-level Access classes.
If you're interested in this inventory class, leave your comments below and give me your feedback as to exactly what you'd like to see!
Now... once you start talking about MULTIPLE locations, you might need to look into a WEB-BASED solution. I do have a tutorial that teaches you how to create a web-based database using Access and ASP. It doesn't quite go into the details of inventory control, but you could use it to set up an online customer tracking system or product database.
Mix that with my forthcoming inventory classes in Access, and you should be able to build the solution you're looking for. You will have your work cut out for you, but if you're willing to take the time and build it right, I'll walk you through it each step of the way.
Here is a link to my Web Database Seminar tutorial:
Of course, if you're stuck, I do offer technical help on the web site - and I can also help customize your database for you if you're having trouble. See /TechHelp for details.
Keywords: access inventory control web