Computer Shop Inventory Management System

Computer Shop Inventory 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.

Objective of Computer Shop Inventory Management System

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

Operating Environment:

• Front End Tool: MS Visual Basic6.0
• Back End Tool: MS Access
• PLATFORM USED: Windows XP

Purpose

It is the project about Computer Shop Inventory Management System. It automates the Systems records, their Selling and Maintenance, Balance evaluation, due to calculation other functions. In other words you can say it a complete computer-shop management System. In this project we can easily maintain systems sales details. It gives information’s of Annual Transaction of products, its services, daily sales, daily Receipt & Balance. We can see the Systems details before selling the particular items & view for our requirement-satisfying item detail.          

Project Scope

The scope of project ‘Computer-shop management system’ is to Develop Visual Basic based software to support for daily sale, receipt & Balance of products and maintain the all information of System related items. This software will be very useful for the Big Computer Shop as well as the customer. It will perform as the required task of Automation of product by itself in a systematic way. It will also save lots of time, as system will perform all tasks in quick time profiting customer and shop owner as well, so it will prove very economical in every respect.

Product Perspective

The Computer-shop Management System is the new, self-contained product. The Computer-shop management system is using vb6.0 platform. All components follow Model-View-Controller pattern. The user can retrieve information of their shop progress.
All pages of the system are following a consistent theme and clear structure. The occurrence of errors should be minimized through the use of checkboxes and scroll down in order to reduce the amount of text input from user. Error message should be located beside the error input which clearly highlight and tell user how to solve it. If system error, it should provide the contact methods. The page should display the project process in different color to clearly reflect the various states. Each level of user will have its own interface and privilege to mange and modify the project information.
User interface elements are easy to understand. Part of user interface is well-organized on screen and the parts are concatenated right. When users look at the interface, they understand which pane is used for which purpose. Each task of an interface is specified clearly and users use them correctly. For example, when users press to any button on interface, they can know which operations are done by pressing this button.
The user interface is easy to learn. When users use the user interface, they can know which element is used to which operations. The interface actions and elements is consistent. When users press any button, required actions is done by the system.
The screen layout and color of the user interface is appealing. When users look at the screen, it will have a nice vision. Colors will be selected clearly, thus eyes of users won’t be tired.To inhance the graphical user interface I use xp button, lv button and vk frame.
Since the application must run on the PC, all the hardware shall require to connect the PC will be hardware interface for the system.The main interface would be the monitor, Keyboard and mouse.

Product Features

• NETWORK SUPPORT. You can use more than one computer to work with Computer-shop Maintenance System.

• Support for VAT tax system. Also you can –

• make system configuration

• Create System configuration and use it later for selling purposes!

• Quickly create database backup!

• Enter and print (optionally) component serial numbers when you selling systems!

• Customize bills that you print!

• Create estimates and latter convert it into bills!

• Reports to make comparisons between months (total sum, or sum by employees)!

• User can see profit of a sold computer system during bill creating!

• Manufacturers administration.

• Print bills with currency sign.

• See number of available components (for selected component in group) when you selling system configuration!

• Different kind of reports.

• Keep track of you suppliers!

• Check out earnings and get information about charged items!

• Each sold system is registered in database with date of sale and notification if customer has paid!

• Computer- shop management software provides full billing and income control and

Supports different password protected employee accounts!

• Server database is protected from unauthorized modifications!

• Process payments quickly and efficiently!

• Unique design with very functional user interface!

• Improve your store business with various reports and statistics!

And many more…

Process Logic

1. 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.

2. 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

3. 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.

4. 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.

5. 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.

6. 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.

7. 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.

 8. 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.

9. 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.

10. 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.

11. 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.

12. 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.

13. 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.

14. 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.

Logical diagram