PharmaFlow Sales & Inventory Management System

The PharmaFlow Pharmacy Sales and Inventory Management System has been developed to address inefficiencies in manual transaction and stock control processes. The existing manual system was time-consuming, error-prone, and lacked real-time tracking of sales, customer records, and inventory. The Database Life Cycle (DBLC) is used to design, implement, and manage the system efficiently. Microsoft Access has been chosen to automate data organization, transaction processing, and inventory monitoring. The system integrates customer, staff, supplier, drug, stock, and transaction data into a centralized database, enabling accurate, secure, and easily retrievable records. The sequential query language (SQL) was implemented to generate real-time reports on sales, stock levels, supplier deliveries, and customer transactions. Results show significant improvements in operational efficiency, stock accuracy, and financial reporting. Automated stock updates, expiry date alerts, and secure staff logins enhanced data reliability and reduced administrative workload. This system ensures timely restocking, prevents the sale of expired drugs, and strengthens data privacy, ultimately improving service quality and supporting better decision-making for the pharmacy.