Aero CNC Inventory

I need a program that works with microsoft access that will help me with my inventory. It needs to be able to read barcode into an inventory list. The non barcoded headings will be description, manufacturer, designation, quantity, and company. It needs to be able to read barcode into an order form that prompts for quantity and company and then creates a separate report for each company that i order from. In the inventory section, I need it to automatically update quantity when I scan an item in that is already on the shelf. I also need a section that my employees can remove tools and it automatically updates inventory when they scan an barcode.