Hi,
I am tasked with working up a concept for a new inventory database. Our inventory in/out rate is about 3 items per day from about 6000 items (replacement parts to maintain our machinery). I have built a table and record with the fields desired. What I would like to know is: what needs to be done so that items going in or out can have a barcode scanned, their entry looked up, and their quantity adjusted up or down? I realize I can scan to a blank worksheet then manually update the database. But I prefer to eliminate as much human intervention as possible...ideally scan-update, scan-update. I don't need step by step directions just a road map as to what is involved. I realize I'll have to learn Access, VBA, Macros, etc. But I just need to present a feasible concept in 2 weeks that can be implemented in 6 - 12 months. Any guidance is greatly appreciated.
G Steel