Clinic Inventory Database

[pbrydone]

Hello all
I have been tasked with creating a database for a small medical clinic which will mainly be dealing with receiving an issuing drugs to patients. We would be looking at entering all of the drugs initially with their current stock balance. We would also be looking at seeing current stocks as drugs are being issued and perhaps being able to generate ordering lists. Any ideas on where I can find something like this in Access. This is a free clinic so I'm not really looking to pay anything for the database or sample. Many thanks n advance...

 

[PNGBill]

Did you check the templates in access. Start access from program and see the template options available for a new database.

Also, Northwind which should be in your access or office folder, search on C drive.

 

[jdraw]

There are a number of free data models related to inventory control at
http://www.databaseanswers.org/data_models/index.htm

Perhaps some combination could help with your design if you are creating a database.
There are some templates that come with Access as well, as PNGBill said.

see http://office.microsoft.com/en-us/templates/inventory-management-database-TC001018458.aspx