Description

Medical Shop Management System Project in Visual Basic

Medical Shop Management System is a desktop application developed using Visual Basic 6 and SQL Server 2000. We offer a variety of visual basic SQL server projects with complete source code and database. Students can choose a topic from the list of VB database projects and easily download the programming project. This project serves as a tutorial and guide for developing code for a Medical Store Management System. The project includes entity-relationship diagrams, data flow diagrams, sequence diagrams, and software requirements specifications in the report file. The main objective of this project is to manage all operations of a medical shop using a computer system. It can handle records of medicines, stocks, medicine company details, user information, sales details, and more. Students can access unique final year academic VB programs with complete source code.

Below the description, you can find screenshots and a demo video of the Medical Shop Automation project for further clarification.

Modules and Description of Medicine Shop Management System Project:

Company Module:

The company module is designed to manage company information. This module is the core of the Medicine Shop Management System project developed in Visual Basic and SQL Server. Admin can manage, edit, and view the list of all companies, while customers can view company details.

Features of Company Module:

• Admin can manage companies
• Admin can edit/delete companies
• Admin can view the list of all companies
• Customers can view company details

Medicine Module:

The medicine module is designed to manage medicine data. Admin can manage all medicines, view the list of medicines, and filter them according to customer needs. Customers can view medicine details.

Features of Medicine Module:

• Admin can manage medicines
• Admin can edit/delete medicines
• Admin can view the list of all medicines
• Customers can view medicine details

Sales Module:

The sales module is designed to manage customer sales records. Admin can manage sales, edit/delete sales, and view the list of all sales. Customers can view their sales details.

Features of Sales Module:

• Admin can manage sales
• Admin can edit/delete sales
• Admin can view the list of all sales
• Customers can view their sales

Customer Module:

The customer module is designed to provide functionality related to customers. It tracks customer information and details, allowing admin to perform CRUD operations on customer data. Role-based access restrictions are implemented, allowing admin full control over data while customers can only view their own information.

Features of Customer Module:

• Admin can add new customers
• Admin can view the list of customer details
• Admin can edit/update customer records
• Admin can delete customer records
• Client-side validation using JavaScript for customer forms
• Customers can view their details
• Customers can update their details

Medicine Stock Module:

The medicine stock module is designed to manage medicine stock records. Admin can manage medicine stock, edit/delete stock records, and view the list of all medicine stocks. Customers can view their medicine stock details.

Features of Medicine Stock Module:

• Admin can manage medicine stock
• Admin can edit/delete stock records
• Admin can view the list of all medicine stocks
• Customers can view their medicine stock

Expense Module:

The expense module is designed to manage expenses. Admin can manage expenses, edit/delete expense records, and view the list of all expenses. Customers can view expense details.

Features of Expense Module:

• Admin can manage expenses
• Admin can edit/delete expense records
• Admin can view the list of all expenses
• Customers can view expense details

Functionality performed by Medical Shop Management System Admin User:

• Login for Admin
• Change Password for Admin
• Edit Profile for Admin
• Medicine Management
  • Adding New Medicines
  • Edit Existing Medicines
  • Listing of all Medicines
• Company Management
  • Add Medicine Company
  • Listing of all Companies
  • Edit Company Details
• Manage Stocks
  • Adding Medicine Stocks
  • Edit Medicine Stocks
  • Listing of all Medicine Stocks
• Manage Sales
  • Add Medicine Sales
  • Edit Medicine Sales
  • Listing of all Sales
• Manage Expenses
  • Adding Expenses of the Medical Shop
  • Listing of all Expenses of the Medical Shop
  • View Details of Expenses
• Manage Users
  • Add Users
  • Listing of Users
  • View Details of Users
• Reports in the Project
  • Report of all Medicines
  • Report of all Stocks
  • Report of all Companies
  • Report of all Users
  • Report of all Sales
  • Report of all Expenses

Technology Used in the Project (Medicine Shop Management System)

We have developed this project using the following technology:

• Visual Basic 6: Front end and business logic written in VB6
• SQL Server 2000: Database for storing data
• Operating System: Windows OS compatibility
• Database Portability (MS Access): Option to use MS Access Database