IT (402) Class X
Project Work On
Inventory Control System
(Session 2023-24)
Prepared by: Prakhar Singh
Class: X
Section: B
Class Roll no: 32
Board Roll no:
School Name: ST.Anthony School
Barabanki
Project Guide: Rupak Tiwari
ACKNOWLEDGEMENT
It gives me immense pleasure to present this report
file on the importance of RDBMS. This project work
is consist of Open Office Base, which is a useful
DBMS and a part of Open Office Suite. In this report
file, a database file has been made upon the
“Inventory Control System”.
I would like to thank our computer faculty, who
always guided me in our proceeding. I am also
thankful to my friend who helped me.
ACHIVEMENT CERTIFICATE
This is to certify that Anant Rastogi of class X-C ,
Roll No. 05 of St. Anthony School has satisfactorily
completed his/her project in Information Technology
(402) for the session 2023- 24.
Date:
sign of internal examiner
INDEX
TOPIC PAGE NO
Libre Office Base Project
Database
Table Structure
# Item
# Suppliers
# Transactions
Screen Shot of Table Structure
Relationship Design & Structure
Screen Shot of Query
Screen Shot of Forms
Report
Introduction:
Inventory Control System Inventory control also
broadly defined as "the activity of checking a
shop's stock." It is the process of ensuring that the
right amount of supply is available within a
business. However, a more focused definition takes
into account the more science-based, methodical
practice of not only verifying a business' inventory
but also maximizing the amount of profit from the
least amount of inventory investment without
affecting customer satisfaction.
An extension of inventory control is the inventory
control system.
For instance, in a departmental store, many items
are kept and sold. When these items are sold out,
the store orders for more in quantity so as to meet
the customers' demands. In order to successfully
manage the departmental store, the authorities have
to decide about various things like...
i) What all items are being sold every day and how
much stock is left for them.
ii) If the stock for a particular item is below reorder
level i.e. the minimum stock that maintained for an
item, then the same item is reordered.
iii) When an item is sold, the quantity sold out is
then subtracted from the Stock in Hands i.e., the
current stock so as to keep it updated.
iv) Similarly, if some quantity for an item is
purchased, then this quantity is added to Stock in
Hands to keep the stock updated. In order to make
such decisions, the information related to
inventories i.e., the products and their transactions
is stored in files. Following sample project is based
on these guidelines. In this project, we have created
three tables namely Items, Supplier, and
Transactions table design of these table are as
follows:
TABLE STRUCTURE
Stock Available Number [NUMARIC];
Creating Database :
Creating table1 (Item) using Design View:
Table 1 Item:
Create Table2 (Supplier) using Wizard:
Creating Table3 ( Transactions) using Design
View:
Database View of Table (Item)
Database View of Table (Supplier)
Database View of Table (Transactions
Relationship among Tables
Query using Wizard:
Query with selected Field name
Create Form For Data Entry:
Form For Table Item
Form For Table Supplier:
Form For Table Transactions:
Generate Report:
