A PROJECT ON COMPUTER –SHOP MANAGEMENT SYSTEM (No of pages: 96)
CONTENT OF TABLE
INTRODUCTION TO PROJECT
PURPOSE AND OBJECTIVES
SOFTWARE AND HARDWARE
MODULES TO BE USED
DATA FLOW DIAGRAM AND DATA DICTIONARY
PAGE LAYOUT AND CODING
TESTING AND IMPLEMENTATION
Computer-shop management System is a project which assist in keeping the Record of what ever the sales from shop (whole seller), also it keep track of remaining balance which due after selling the product. Through this project we maintain the warranty given on particular products along with complete information related to that product. Computer-shop management System is software for store billing management. Sell hardware systems components and accessories (keep track of sold configurations, create system configuration, sell accessories and computer components, supplying company’s administration, and many more…). Computer-shop management System is a windows based billing software designed for uses in computer stores.
- To assist the staff in capturing the effort spent on their respective working areas.
- To utilize resource of the institution in an efficient manner by increasing their productivity through automation.
- To keep and manipulate details.
- To provide facility to sale at shop and prepare customer bill.
- To make enquiry of a particular sale.
- To maintain the purchase and stock at shop.
The objective of my project to provides management facility to computer-shop. We have given many facilities for users in this project.
1) Welcome screen (Formsplash)
2) Login screen
3) Main form
4) Sell Computer System form
5) Sell Computer Parts form
6) Update customer Balance form
7) Product Price Report form
8) Change password form
9) Make quotation form
10) Add computer part form
11) Add computer system form
12) Create user account form
13) Update shop information form
14) Report of sold computer part
15) Report of sold computer system
1) Hardware Requirement
1) 20 GB HDD Free Space
2) 128 MB RAM
3) P IV or above Processor
5) Keyboard: Standard
6) Mouse: Optional
2) Software Requirement
2) MS Visual Basic6.0
Ø Front End Tool: MS Visual Basic6.0
Ø Back End Tool: MS Access
- PLATFORM USED: Windows XP, Windows 2000.
- Login Form
In this form, existing user/administrator enters the user-name and password and access the main form. If user forgets his password then he can click on button forget password and then entering his e-mail id can get user name and password. This form contains user name and password as sub module.
- Main Form
If administrator accesses this form using authentic login-name and password then the administrator has administrative power as add the product, create user account, add new branded computer system, add company, change the shop record .
Administrator have full power But user have some restricted power only which is provided by administrator.
In this main form user can sell computer part/assemble computer system/branded computer system, update customer record, change the password, make quotation. Using this form the user/administrator can see the report of sold computer part, branded computer system in any time duration. In this form, there is option to exit & log-off
- Sell Computer System Module
There are two sub modules:
1) Sell branded computer system
2) Sell assembled computer system/computer part
In sell branded computer system module, user/administrator can sell available branded computer system. In this form, the user/administrator enters the customer name, address & phone number and chooses any branded computer system to sell. This form also so the all information of chosen branded computer system as category, model number, monitor type, hard-disk range, ram, processor, price etc. After selling, the user/administrator can print and save the receipt.
In sell assembled computer system/computer part module, user/administrator can sell available computer part and assembled computer system. In this form, the user/administrator enters the customer name, address & phone number and chooses all computer part to sell according to request of customer. The user/administrator can chose any product, its type, range, its serial number using combo-box. After choosing the serial number of product the price of the product and total price (including vat, tax) automatically generate. After selling, the user/administrator can print and save the receipt. The invoice number and customer number automatically generate by this software when this form is loaded.
- Update Customer Balance Module
In this module, there is information related to balance of customer, customer name and address. In future if any customer paid the balance amount then it can be update.
- Make Quotation Module
In this module, the user/administrator makes quotation according to request of the customer. This quotation provide information about the price, range, type & company name of all product to customer before purchasing the computer parts/assembled computer system. This quotation also provides total price (including vat) assembled computer system.
- Change Password Module
In this module, the user/administrator can change his/her password by entering login-name and old password and new password. So this provide security from unauthorized access.
- Create user account Module
In this module, the administrator can create new user by providing him login-name and password. In this module, the administrator can update user information as name, address and phone number of exiting user. He can delete exiting user account. The administrator can see the entire exiting user. The administrator can also give administrator power to any user. In this module, there is information related to the entire user working in the computer-shop as name, address, e-mail id, phone number etc. Here admin can take information related to user.
- Add Product Module
In this module, the administrator can add new product by entering its name, company name, range, type, serial number, and its price. Here administrator can also see the available product and its information. And the administrator can also delete any product.
- Add computer system Module
In this module, the administrator can add new branded computer system by entering its category, model number, company name, ram capacity and its speed, monitor type, Hard-disk capacity and its interface, processor clock speed and its L2cach, motherboard company-name and its chipset, its selling and buying price and other description. Here administrator can also see the available computer system and its information. And the administrator can also delete any computer system.
- Add company Module
In this module, the administrator can add any company information whose product are available at the computer shop. This module contains the name of company, contact person, address, phone number, website, and fax number.
- Change Shop information Module
In this module, the administrator save/update the information related to his computer-shop as name of computer-shop, address, phone-number, and registration number.
- Product Price Report:
This report shows the price of all available products and its detail as item-name, company-name, type, range, and serial-number.
- Sold computer part Report:
This report show the sold computer part in any time duration. The administrator/user can see the detail of sold computer part in specified time duration. This report show the name of customer, item-name, company-name, type, range, serial-number, and price of sold product.
- Sold computer system Report:
This report shows the sold computer system in any time duration. The administrator/user can see the detail of sold computer system in specified time duration. This report shows the name of customer, category, company-name, model-number, ram capacity and its speed, monitor type, Hard-disk capacity and its interface, processor clock speed and its L2cach, motherboard company-name and its chipset, its price and other description.