Pharmacy Management System using Microsoft Access

Summary

This video script offers a step-by-step guide to creating a comprehensive pharmacy management system using Microsoft Access. It covers the creation of various tables for transactions, reorder, medicine details, and supplier information, as well as the setup of relationships between these tables. The tutorial also includes instructions on designing forms for data entry and navigation, calculating fields for ease of use, and generating reports for record-keeping. Additionally, it guides viewers on creating a main form for easy access to different system operations, ensuring a functional and organized pharmacy management solution.

Takeaways

• 😀 The video script outlines the process of creating a pharmacy management system using Microsoft Access.
• 💊 It details the creation of various tables such as transaction details, reorder purchase, medicine details, supplier, and payments.
• 🔢 Each table has specific fields, like transaction ID, customer name, drug name, quantity, cost, and balance for transaction details.
• 📋 The script emphasizes the importance of setting the correct data types and using primary keys for each table.
• 🧮 It explains how to perform calculations within the tables, such as calculating the balance by subtracting the cost from the amount payable.
• 🔍 The use of lookup wizards to establish relationships between tables is highlighted, ensuring data consistency and accuracy.
• 📝 The process of creating data capture forms using modal forms in Access is described, with steps on assigning record sources and designing the user interface.
• 🖨️ The script covers the creation of reports for easy printing and viewing of transaction and payment records.
• 🛠️ Customization of the user interface is discussed, including hiding certain elements, adjusting visibility, and formatting to improve the user experience.
• 🔄 The video mentions the use of macros to automate tasks, such as opening the main form of the system.
• 📱 A main form is created to serve as the central interface for the system, allowing users to switch between different operations and reports.

Q & A

What is the purpose of creating a pharmacy management system as described in the script?

The purpose is to record transactions of drugs or medicine sold, handle reorder processes, manage payments, and record medicine details in an organized manner using Microsoft Access.

How is the database named in the script when creating the pharmacy management system?

The database is named 'pharmacy management system'.

What are the primary fields included in the 'transaction details' table according to the script?

The primary fields include transaction ID, customer name, mobile number, drug name, quantity, quantity cost, amount payable, and balance.

How is the 'balance' field calculated in the 'transaction details' table?

The 'balance' field is calculated as the difference between the amount payable and the cost of the drug.

What is the purpose of the 'reorder purchase' table in the pharmacy management system?

The 'reorder purchase' table is used to track purchase orders, including purchase number, invoice number, supplier name, drug name, current quantity, deficit, and index number.

What is the primary key of the 'medicine details' table?

The primary key of the 'medicine details' table is the index number of the medicine.

How can the total cost of medicine be calculated in the 'medicine details' table?

The total cost is calculated as the product of the quantity and the price, which is set as a calculated field in the table.

What is the significance of creating relationships between tables in the pharmacy management system?

Creating relationships ensures data integrity and allows for the seamless flow of information between related tables, such as linking drug names to their corresponding entries in the 'drug names' table.

How are data capture forms created in the script for the pharmacy management system?

Data capture forms are created using modal forms in Microsoft Access, which are then customized with the appropriate fields, formatting, and navigation buttons.

What is the final step described in the script for launching the pharmacy management system?

The final step is to create a main form that serves as the entry point for the system, and to customize the ribbon in Microsoft Access to include a new tab for easy access to the main form and its functionalities.