Inventory Control

This is a full inventory control system with VBA forms that will place structure and efficiency into your business. You can add your products into the database and control your inventory via check in and check out system. You can scan product codes, find quantities, and receive material in. It also records all the transactions made for any further analysis needed. This is ideal for any business trying to create structure and a standard process into their inventory control system.

Security:

System provides a level of security where it will only let admin edit sheets manually. Any regular user is forced to use the form so you can be sure no one will force data in.

System highlights:

• Add any amount of products to the inventory list
• Find inventory quantities for items
• Set reorder points for each item
• Highlights low stock inventory
• When taking out material to the floor or shop uses a check out system
• When returning it uses a check in system
• Keeps inventory under control and visible in system
• Records inventory transactions