12-31-10, 17:12 #1Registered User
- Join Date
- Dec 2010
Unanswered: Q regarding Access capabilities (Newb)
My dad asked if I could help him build a database to store inventory of parts for his small business. Here's a brief description of how they work:
They receive parts from a company (complete with barcode) and builid large devices using them. There are numerous different kinds of devices so in total there may be about 10,000 parts. They've had issues regarding lost parts so they'd like to keep an inventory of every part that is shipped in and then every part that is used to build a device. They would like to scan in the parts using a barcode scanner when we receive them and update the quantity in the inventory database. Each time they use a part, they could then scan it again to remove it from the database.
Before I set out on figuring out how to build something like this, it might be good to know if it's practical to do it. Could this all be done entirely with Access including integration with a barcode scanner (model is Symbol LS2208 if it helps)? Would something else besides Access be a better choice?
Any help would be greatly appreciated. Thanks!
12-31-10, 18:07 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
All of your requirements, as stated, can be handled using Access, including the use of a bar code scanner.
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007