Project Report
on
Simple Inventory Management
Submitted To:
Subject Teacher:
Designation:
Submitted By:
Student Name:
Class:
Roll No:
Subject: Information Technology (402)
Session: 2025 - 2026
Certificate
This is to certify that the project entitled ‘Simple
Inventory Management’ is a bonafide work done by
____________________ of Class X, Session 2025 – 2026
in the partial fulfilment of CBSE Examination, 2026
and has been carried out under my direct supervision
and guidance.
Subject Teacher
Designation
Acknowledgement
I would like to express my special thanks of
gratitude to my teacher [Link] as well as our
Principal [Link], who gave me the golden
opportunity to do this wonderful project on “Simple
Inventory Management”, which also helped me in
doing a lot of Research and I came to know about
many things. I am really thankful to them.
Secondly, I would also like to thank my parents and
friends who helped me a lot in finalizing this project
within the limited time frame.
Last but not least, I would like to thank all those who
helped (directly or indirectly) towards the completion
of this project.
__________________
Class X-
3|Page
INDEX
Sr. Contents Page Teacher’s
No. No Signature
1. Introduction of the Project
2. Objectives of the Project
3. Hardware and Software
Requirements
4. Steps to Create a Database
➔ Creating a Database
➔ Creating a Table
➔ Inserting Data in a Table
➔ Creating Relationships
between Tables
➔ Creating Queries
➔ Creating a Form
➔ Creating a Report
4|Page
Introduction of the Project
The Simple Inventory Management System is a lightweight software
application designed to help small businesses or organizations
efficiently manage their inventory of goods or products. This system
provides an easy-to-use interface for tracking stock levels, managing
item records, and monitoring stock-in and stock-out transactions.
Inventory is a critical component of operations for retail stores,
warehouses, service providers, and more. This project aims to solve
common inventory challenges such as overstocking, stockouts, and
manual tracking errors by providing a basic yet functional tool.
The system allows users to:
Add and manage product information
Track quantities in stock
Record when items are added (purchased) or removed
(sold/used)
Set minimum stock levels for alerts
View basic inventory reports
5|Page
Objectives and Scope of the Project
Objectives of the Simple Inventory Management
Track Inventory Efficiently
To maintain accurate records of stock-in and stock-out operations.
To keep real-time track of inventory levels.
Simplify Inventory Operations
To reduce manual paperwork and human errors.
To allow users to add, update, and delete product data easily.
Prevent Stock Shortages or Overstocking
To notify the user when stock levels fall below a defined threshold.
To optimize inventory levels and avoid overstock costs.
Improve Decision-Making
To provide basic reports for evaluating stock performance.
To help in planning restocks based on historical data.
Create a User-Friendly System
To design a simple and intuitive interface for non-technical users.
To ensure the system is easy to deploy and maintain.
Scope of the Project
Product Management
Add, edit, delete product information (name, category, price, quantity).
Inventory Transactions
Record stock-in (purchases) and stock-out (sales or usage).
Stock Level Tracking
View current stock levels at a glance.
Basic Reports
Generate summary reports of inventory status and movement.
Single-User Environment
Designed for individual users or small businesses.
6|Page
Hardware and Software Specifications
Hardware:
Processor: Pentium G2030 @ 3.70 GHz
Processor Speed: 533 MHz
RAM: 2GB or more
Hard disk: 2.00 GB
RAM: 256 MB RAM (512 MB RAM recommended)
Software:
At least 600Mb available disk space for a default install (including a JRE)
via download. After installation and deletion of temporary installation
files.
Operating System: Microsoft Windows (Windows 8, Windows 10 and
Windows 11)
LibreOffice will use approximately 500Mb disk space.
LibreOffice
7|Page
Main Components of
Library Management System
Products Table: The table stores the information of the all products.
StockIn Table: The table stores the information of the product StockIn details.
StockOut Table: The table stores the information related StockOut details
Users Table: The table stores the information users data
Relationships: All the tables will be linked using the different relationships.
Query: Query is used to retrieve information from one or more tables based
on the set of conditions you define using the table fields.
Forms: These are used to create and make data entry in database tables
easier.
Reports: It is effective way of analysing and presenting data in a specific
layout.
8|Page
Creating a Database
Step 1: Open a new database in libreoffice application.
Step 2: Database Window will appear.
Step 3: Click Next and Finish.
Step 4: Save as dialog box will appear. Choose the desired location and enter
the filename. Click Save button.
Database window displays with different option to create Tables, Queries,
Forms and Reports.
9|Page
Table in a database can be created using:
1. Create Table in Design View
2. Using Wizard to create table
3. Create View
Creating Products, StockIn, StockOut and Users tables for Simple Inventory
Management System
Products Table
StockIn Table
10 | P a g e
StockOut Table
Users Table
11 | P a g e
Data in Product Table
Data in StockIn Table
Data in StockOut Table
12 | P a g e
Creating Relationships between the Tables
Step 1: Click Tools and Relationships option.
Step 2: Add Tables window will appear.
Table from the list and Click Add.
Entity Relationships Overview
Creating Queries
Queries can be created using Wizard, using Design View and create a query in SQL
View.
Creating Query using Wizard
Step 1: Select Create Query in Design View
from the database.
Step 2: Add Table or Query window will appear.
Step 3: Select the tables for which query has to
be created.
Step 4: The main window is divided into two parts.
In the top part of the window, it displays the tables
selected and bottom part will be displayed with
certain options such as Field Name, Alias option
if the user would like to give an alternate name,
if the sorting has to be applied also it can be applied.
13 | P a g e
Step 5: Automatically the visible option will be enabled for the selected fields.
Step 6: If you want to add any function for a particular field also it can be added.
The user can also apply the criteria (means a condition) to the fields .
Step 7: On the Toolbar, Run Query and Clear Query options are enabled.
Step 8: If you select Run Query option from the toolbar, depending on the
conditions given by you the data will be displayed accordingly.
Step 9: Later you can also add the different fields and change the conditions and
execute the query.
Step 10: Give the name for the query to view further.
14 | P a g e
Creating Forms
Forms are the systematic way of storing the information in a database. It is an
interface where the user can easily view the data, enter the data and change the
data in the database such as tables.
The forms and table interlinked with each other which means that whatever
changes are made in the form will automatically get reflected in the table.
Creating a form using Wizard
Step 1: Open Created Database application.
Step 2: Select the database object as Forms. It displays two options such as
Create Form in Design View and Use Wizard to Create Form.
Step 3: Select Use Wizard to create Form.
Step 4: In the Create Wizard form it consists of 8 steps. Here, step by step will
redirect you to design the form.
Step 5: Apply different styles and Click Next.
15 | P a g e
Step 6: In this window, the user has an option to work with the form or modify
the form and Click Finish. The form will be displayed with all the records and the
settings.
Step 7: User can enter the new record details and Click Save. The newly added
record will be updated in the respective table and Click Save which is available at
the bottom of the window.
Creating Reports
Reports are used to display the data in the summarized manner and these are in
the printed form. The complete output will be generated and displayed to the
user in a detailed manner.
Creating a report using Wizard
Step 1: Open created Database application.
Step 2: Select the database object as Reports and select Use Wizard to Create
Report option.
Step 3: It displays six options such as Field Selection, labelling fields, Grouping,
Sort Options, Choose Layout, Create Report.
Step 4: Select the fields from the tables which are required and click on Next
Option. Here, we can change the name of the fields if required.
Step 5: The final report will be displayed
16 | P a g e
17 | P a g e
Limitations of the
Employee Management Database Project
1. No Real-Time Multi-User Access
Most simple systems are single-user or locally hosted.
Lack of real-time collaboration or updates across devices or users.
2. No User Authentication Security (or very basic)
User login, if implemented, may not include proper encryption or access
control.
No role-based permissions (e.g., admin vs. staff).
3. No Barcode or QR Code Integration
Manual entry is required for product identification.
No scanning system for stock-in or stock-out processes.
4. No Supplier and Purchase Order Management
Cannot track supplier details, purchase orders, or delivery dates.
Not suitable for businesses needing supplier-side tracking.
5. No Automated Stock Adjustment
Quantity must be updated manually after stock-in/stock-out unless triggers
or scripts are added.
Increases risk of errors or inconsistencies.
6. No Alerts or Notifications
System does not automatically alert the user when stock levels fall below
the reorder level.
No SMS, email, or dashboard alerts.
7. No Reporting or Analytics Tools
Limited to basic table views.
No charts, summaries, trends, or sales forecasting.
18 | P a g e
Future Scope and Enhancements
1. Multi-User Login and Role-Based Access
Allow different users (e.g., Admin, Manager, Staff) with different permissions.
Use secure authentication (e.g., password hashing, JWT, OAuth).
Track who did what (activity logs).
2. Barcode / QR Code Integration
Add barcode scanning for faster stock-in/out operations.
Print and scan product tags for accuracy and speed.
Use mobile devices as scanners.
3. Real-Time Notifications & Alerts
Send alerts when stock levels drop below the reorder threshold.
Email or SMS notifications for critical events (e.g., out of stock, expiration).
Dashboard widgets for quick stock status.
4. Supplier & Purchase Order Management
Track supplier information, contact details, and lead times.
Generate and manage purchase orders directly from the system.
Track incoming shipments and expected delivery dates.
5. Sales and Customer Tracking
Add customer details for each stock-out transaction.
Monitor sales history, repeat customers, and best-selling items.
Integrate with POS (Point of Sale) systems.
6. Inventory Valuation and Cost Analysis
Implement inventory valuation methods like FIFO, LIFO, or Weighted Average.
Track profit margins, holding costs, and cost per product.
Generate cost-based financial reports.
7. Reports and Dashboards
Generate reports on:
Low-stock items
Most/least sold items
Inventory valuation
Purchase and sales trends
Visual dashboards with charts and filters.
19 | P a g e
Bibliography
Information Technology (Subject Code: 402) Grade 10 Text book
Information Technology NCERT Text book
LibreOffice Base Guide pdf
20 | P a g e