Managing Drug Stock and Expiry Dates Across multiple locations

[Quakefire]

Howdy,

Of all the office products, Access is one of the few that I haven't used yet. I work for a small ambulance company and I am in charge of maintaining our stock of medications which I have been doing with an excel chart that isn't as automated as I would like, and is not set up to provide me with any insight into changes I could be making to smooth out stock levels and usage. I would like to build a data base with Access 2007 ( I have no budget so I work with what I have) that will show me the stock that I currently have, be easy to update as medications are used, keep track of what is expiring in our trucks (and possibly generate an alert if restocking those expired medications will put us below minimum stock levels) and generate a report showing how much of our stock gets used, how much expires and so forth. I am willing to put in the work I just have no idea where to start, and I would like if someone could coach me along with this project. I will attach the excel worksheet i have been using so far.

Thanks

Dan

[June7]

Start by identifying data entities and relationships.

Review 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/

Could check template databases. Open Access and an assortment of databases are presented for selection. There is an Inventory model might give you ideas.