VBA application fully integrated within Microsoft Access©.

The project was developed to do the semi-annual inventory of goods in a pantry of a restaurant.

The application leveraged the VBA APIs integrated in Microsoft Access© to completely redesign, customize and make user-friendly the original Microsoft Access© graphical interface.

The system generated barcodes for each product in the database. These barcodes could be printed via a dedicated view and then attached to pantry shelves. This speeded up products searches during the inventory by easy scanning barcodes via a barcodes scanner gun attached to the laptop.

Reports of goods in inventory were also automatically generated as PDFs for easy printing.