I would like to build an inventory database for a small warehouse pharmacy will almost 300 medication in microsoft access. this warehouse ONLY supplies one dispensing area.
The database fields needed are:
Medication item code, Generic Name, Trade Name, Lot number, expiry date, average monthly use, reorder level, maximum inventory level, minimum inventory level, cost of products.
Capability to generate reports such as: when to reorder medication to the SMALL WAREHOUSE pharmacy based and the average monthly use of the medication dispensed to the dispensing area, reports of items that will expire with 6 months, Vendors list, Monthly dispensed items, Quarterly dispensed items, Yearly dispensed items.