Electronic workshop inventory system project is developed in visual basic ( VB.NET) programming language using MS Access database. This software application is a standalone application useful for shops which sells electronics goods for managing products, sales details.
Main objective of this software is to provide a solution for electronics shops for computerizing various types of works like update daily sales details, updating stock details , analyzing monthly and yearly sales and stock details using report generation module.
Database Design Details:
There are three tables Group table, Main table and Work table.
Group table is will store details of products with product number, product name and product description.
Main Table is useful for maintaining product number, product code, product description, different price levels and stock details.
Work Table is useful for storing product number, customer details, selling price, date and time , quantity.
Forms over View:
Login forum: Users who will update details to database using GUI should register with application and get unique user name and password.
Form Settings: In order to modify passwords, modify setting this form is used. Permissions are given to admin for accessing setting module.
Records Form: List of records updated to database are visible in this form. Users can search for records using search form.
Add Record Form: Using this GUI user can update customer’s details, stock details, sales details and employee details. Details are stored in database in respective table.
Find Record Form: This is like search form where user can search for old records based on customer id or date and time.
Download Electronic workshop inventory system project in vb.net