Wednesday, January 16, 2013

Medical Supplies Database

Click the image to enlarge it.

I developed a small-office database for a medical supplier. I used MS Access 2007. The main transactions are Invoice and Purchases. Notice that I have displayed 3 queries on the Home form, this is for the client to be able to see the most important data of their business right away. What the application automated was the tracking of the inventory, printing of the individual invoices, and the reporting of monthly information such as collection, sales, purchases, and payables (AP).