Printer Ink Inventory Tracker

April 2019

At with many companies, printer ink often ran out at Roytec Industires. One of the many reasons was the shear amount of different printers. Being that many workers relied on documents and paperwork, printer downtime was a big problem. To combat the printer ink inventory issues, I created a database for it with Microsoft Access. A computer sits in the room where the printer ink is stored. Whenever someone takes ink, they scan a barcode that was placed on the package when it arrived. The system automatically tracks inventory, usage history, and even orders based on trends.