CONTENTS

CONTENTS
[Link] TOPIC PAGE NO
CERTIFICATE
DECLARATION
ACKNOWLEDGEMENT
SYNOPSIS
Ⅰ INTRODUCTION
1.1 Introduction
1.2 Product of the company
1.3 Shop profile
1.4 Objectives of the study
1.5 Limitations of the study
Ⅱ SYSTEM STUDY AND ANALYSIS
2.1 System study
2.2 Existing system
2.3 Proposed system
2.4 Feasibility study
2.5 Data flow diagram
2.6 System configuration
Ⅲ SYSTEM DESIGN
3.1 Input design
3.2 Software environment
3.3 Output design
3.4 Application specification
3.5 Introduction to visual basic
3.6 Introduction to MS Access
3.7 Table design
Ⅳ SYSTEM TESTING AND IMPLEMENTATION
4.1 The testing five type of activities
4.2 System implementation
4.3 Findings
4.4 Suggestions
4.5 Conclusion
4.6 Scope of future development
BIBLIOGRAPHY
Forms and Coding
SYSNOPSIS
SYNOPSIS
The project entitled “INVENTORY MANAGEMENT SYSTEM” with software
development programs in visual basic is developed for use of staff members of “AMV TILES
WORLD“.This system provides multiple utilities to the work burden of the members are
reduced through the system. This system is user friendly for entering the details of the
following,
➢ PURCHASE DETAILS
➢ SALES DETAILS
➢ STOCK DETAILS
➢ STAFF DETAILS
➢ ACCOUNT DETAILS

PURCHASE DETAILS

This module includes the product name, address, rate of the product, number of
quantity etc.,

SALES DETAILS

This module includes the product name, customer name, rate of the product, number
of quantity, rate etc. ,

STOCK DETAILS

This module includes the product name, rate of the product, number of quantity, rate etc.,

STAFF DETAILS

This contains the salary details of the staff and other allowances of the staff.

ACCOUNT DETAILS

This contains information regarding payment and salary bills and income and
expenditure of the tiles shop.
CHAPTER - Ⅰ

INTRODUCTION
CHAPTER - Ⅰ
INTRODUCTION

1.1 INTRODUCTION OF THE COMPANY

The AMV TILES WORLD was established in the year 2017, in CHEMBALA,
GUDALUR. The AMV TILES WORLD are one of the leading tile distributors and sellers of
tiles and marble in Gudalur. The company includes 5 employees and 1 manager to lead the
company.

This system keeps the records of the data of the tiles. It is fed with the information whenever
new stocks are brought and it is provided. It gives the price of the tile and also warns when the
tiles stocks are less.

By using this management system the time gets saved and there will be very negligible
chance for the errors to occur. We can check the record instantly which is not possible by manual
methods. As the system gives the information of the less stock we can replace them with new
stock. Thus we can conclude that inventory management system is helpful for handling the tasks
efficiently in the store.

The company is having a experienced team which has successfully managed to develop and
operate as a specialty of retailers who manufacture and produce natural stone tiles, setting and
maintenance of the material, and related accessories.

This project is created for reducing the work burden of the administrator of Cherambadi
medicals and to enhance the safety and security to the system. There are some effective and
efficient modules included in this system. They are: purchase details, sales details, stock details,
staff details, account details.
1.2 PRODUCTS OF THE COMPANY
The UNITED CERAMICS are one the main tiles and ceramics dealers in gudalur,
so they contain the following types of product.

❖ CERAMIC FLOOR TILES

❖ CERAMIC WALL TILES
❖ GLAZED VITRIFIED TILES
❖ VITRIFIED DCH
❖ VITRIFIED HEAVY DUTY
❖ VITRIFIED SST
1.3 SHOP PROFILE

Name Of The Concern AMV TILES WORLD

Name Of The Owner Mr. Abuthahir

Concern Address AMV TILES WORLD,

Chembala, Gudalur,
The Nilgiris-643212
Establishment Year 2017
Authorized Banker Mr. Basha
Annual Turnover 260000
Total Number Of Workers 5
Registered Office Gudalur
Company Chairman Mr. Abuthahir
Company Managing Director Charumathi
Products Tiles
Email Address [Link]@[Link]
Conduct Number 6382319223
1.3 OBJECTIVES OF THE STUDY
The main objective of this project is to gain practical knowledge about the inventory
of the concern. It focuses on the following:
➢ The main objective of this study is developed to reduce the manual risk and to
implement new techniques in administration.

➢ To eliminate the existing system and to improve the goodwill of the inventory, to
be different from other inventory management.
➢ To rectify the manual errors that is happened during the time of marketing.
➢ To increase the efficiency.
➢ Save time and processing are done very quickly
1.5 LIMTATIONS OF THE STUDY

➢ There is lack of personal attention

➢ During the working days of the company it is not possible to gather data
➢ Only particular time is allocated to gather data so it’s difficult to furnish the entire
infrastructure of the center
➢ The proposed system which has been created is only for administration purposes
➢ During the period is very short
CHAPTER -Ⅱ

SYSTEM STUDY AND ANALYSIS

CHAPTER -Ⅱ

SYSTEM STUDY AND ANALYSIS

2.1 SYSTEM STUDY
INTRODUCTION

For developing efficient system a collection of primary data and secondary data is
essential. The system study gives user management requirement, the structure and the function
of the system. It studies the problem, identifies the alteration solution, evaluating the problem
and finally user the best solution.

In visual basic we have a performance called as MENU EDITOR, used for the purpose
of driving out output through a menu like familiar software. This menu editor helps us to create
our output through a style, as we understand. Also we can create shortcut key commands
likewise in software we can enable the necessary command and disable the unnecessary
function through this menu editor. It can be up through the menus in the visual basic software
or by pressing the control command E.

The function called as MDI, MULTI DOCUMENT INTERFACE a most important

function in our project can be discussed now. In this project numbers of performance in separate
forms are done. But all the performance from one to another. Every from must be called
separately. This type of form is called as SDI, SINGLE DOCUMENT INTERFACE. But
this can be utilized only through the simple and single programs. But for a project, a group of
performance cannot be done. So MDI is performed such type of things.
In MDI, there were no of forms occurred and at the same time, no of works can be
accessed. In that no of forms, the first form is called (MDI) as parent form. Another created
application form is called (SDI) As CILD FORMS. In this function we must know how can
be converted into a CILD FORM. Changing the property NAME and MDI CILD
PROPERTY to true can create it. Name of one form must be different from another. No two
children can have a same name in a family. It must have the slight difference. So this is the
easiest method of organizing a group of works into a single form. After creating a MDI form,
the startup form and which are the inner forms can do that. That can be scheduled through the
project menu in the visual basic software.

2.2 EXISTING SYSTEM

The concern done in the existing system was maintained manually in a notebook. Hence
there is a change for missing commitment. So they prefer systematic manner in maintaining
the details. Hence there is a change of manipulating the data's in the notebook. Hence the
original data are transferred into the proposed new system with powerfully back-end secured
front-end avoiding any entering of an unauthorized user hence monitoring the attendance
easily.

DRAWBACKS OF THE EXISTING SYSTEM

❖ The work is tedious and time consuming

❖ Requires lot of paper work.
❖ There is a change of loss of data due to misplacement.
❖ Lacks security of confidential data,
❖ Manual work is error prone
❖ Repetition of the work is minimized
2.3. PROPOSED SYSTEM
Computer plays a vital role in this technological world where speed and accuracy are the
basic requirements in order to satisfy user needs. The proposed system can make maximum
utilization of values information and intelligence within institution itself. Timely information
is important to reduce the uncertainty in decision making.

The main aim of these projects is to ensure that all intended functions are kept at their
optimum effectiveness all the time while performing manually it requires manpower and time
consuming. Moreover it is also susceptible to errors. Computerization of this system overcomes
the above mentioned obstacles and efficient retrieval and storage of data is done in almost
precise manner. For sorting these problems computerization is the only efficient and feasible
manner.

ADVANTAGES OF THE PROPOSED SYSTEM

The proposed system has many advantages over the existing manual system. Some of
them are as follows:

➢ It is very user friendly.

➢ Fast retrieval data user to enter correct and it produces output.
➢ It suitably instructs the user to enter correct data type in the fields.
➢ It interacts with the users to get input and it produces output.
➢ It produces several reports according to the requirements of the user.
➢ It is fast and efficient. It saves time and energy to store retrieves the data.
2.4 FEASIBILITY STUDY
An important outcome of the preliminary investigation idea is the determination that the
system developed is feasible. The main objective of the feasibility study is to test the technical,
operational and economic feasibilities of developing a computer S/N. This is done by
investigating the existing system in the area under investigation and generating ideas about a
new system. The proposed system must be evaluated from a technical point of view first and if
technically feasible its impact on organization and staff must be assessed. If compatible
operational technical systems can be clerical, then they must be tested for economic feasibility.

TECHNICAL FEASIBILITY
The assessment of technical feasibility must be based on based on an outline design of
system requirement in terms of inputs, outputs and feasibility study the scope was whether the
world for the project is done with the current equipment existing software technology. It was
found that the hard ware and software specifications were available.

OPERATIONAL FEASIBILITY
The assessment of operational feasibility will be done alongside technical feasibility. The
project developed aims at providing a user friendly environment of the user friendly
environment to the user.

ECONOMIC FEASIBILITY
An assessment of the economic feasibility that is cost benefit analysis was carried out for
the proposed system. As the organization already has the required technology and resources, it
need not have to spend extra money on buying and installing them.
2.5 DATA FLOW DIAGRAM
The dataflow diagram is a graphical representation, which depicts the information
regarding the flow of control and the transformation of the data from the input to the output.
The data flow diagram may be used to represent the system or software at any level. A level
data flow diagram, also called a context model, represents the entire software element as a
single bubble with input and output arrows.

Data flow diagram depicts information flow without explicit representation procedural logic.
DFD also depicts real time systems with the help of some extended notation.

Basic DFD notation:

The DFD notation are

Hardware, person and another program

Information of the system to be modded

Data storage

Direction if the flow

DIAGRAM - 1

SPLASH SCREEN

LOGIN FORM

PURCHASE REPORT

SALES STOCK

BILL ITEMS

EXIT
2.6 SYSTEM CONFIGURATION
HARDWARE CONFIGURATION
PROCESSOR Intel(R)Pentium(R) D CPU 3.00Hz
2.99GHz
RAM 1.50GB

HARD DISK 40GB

MONITOR 19” COLORING MONITOR

MOUSE SCROLL OPTICAL MOUSE

KEYBOARD 104 KEYS

PRINTER CANON LASER

SOFTWARE CONFIGURATION
OPERATING SYSTEM MICROSOFT WINDOWS 10

FRONT END VISUAL BASIC 6.0

BACK END MICROSOFT ACCESS

PC SOFTWARE MICROSOFT OFFICE 2007

CHAPTER - Ⅲ

SYSTEM DESIGN
CHAPTER - Ⅲ

SYSTEM DESIGN

3.1 INPUT DESIGN

The design of input focuses on controlling the amount of input required, controlling the
errors, avoiding delay, avoiding extra steps and keeping the process simple

➢ What data should be given as input?

➢ How the data should be arranged or coded?
➢ The dialog to guide the operating personnel in providing input.
➢ Methods for preparing input validations and steps to follow when error occur.

Input design is the process of converting a user-oriented description of the input into a
computer based system. This design is important to avoid errors in the data input process and
show the correct direction to the management for getting correct information from the
computerized system.

It is achieved by creating user-friendly screens for the data entry to handle large volume
of data. The goal of designing input is to make data entry easier and to be free from errors. The
data entry screen is designed in such a way that all the data manipulates can be performed. It
also provides record viewing facilities

When the data is entered it will check for its validity. Data can be entered with the help
of screens. Appropriate messages are provided as when needed so that the user will not be in
maize of instant. Thus the objective of input design is to create an input layout that is easy to
follow.
3.2 SYSTEM ENVIRONMENT

The Control Properties

Before writing an event procedure for the control to response to a user's input, you have
to set certain properties for the control to determine its appearance and how it will work with
the event procedure. You can set the properties of the controls in the properties window or at
runtime. Following are some of the common controls:

The Text Box

The text box is the standard control for accepting input from the user as well as to display
the output. It can handle string (text) and numeric data but not images or pictures. String in a
text box can be converted to a numeric data by using the function Val (text). The following
example illustrates a simple program that processes the input from the user.

The Label

The label is a very useful control for Visual Basic, as it is not only used to provide
instructions and guides to the users, it can also be used to display outputs. One of its most
important properties is Caption. Using the syntax label .Caption, it can display text and numeric
data. You can change its caption in the properties window and also at runtime.

The Command Button

The command button is one of the most important controls as it is used to execute
commands. It displays an illusion that the button is pressed when the user click on it. The most
common event associated with the command button is the Click event, and the syntax for the
procedure is.

Data control

Data control is a link between information in your database and the bound controls that
you use to display the information. The data control makes data from your database available
to your program in the form of a record set.
The Picture Box

The Picture Box is one of the controls that is used to handle graphics. You can load a
picture at design phase by clicking on the picture item in the properties window and select the
picture from the selected folder. You can also load the picture at runtime using the Load Picture
method. For example, the statement will load the picture [Link] into the picture box.

The Image Box

The Image Box is another control that handles images and pictures. It functions almost
identically to the picture box. However, there is one major difference, the image in an Image
Box is stretchable, which means it can be resized. This feature is not available in the Picture
Box. Similar to the Picture Box, it can also use the Load Picture method to load the picture.

The List Box

The function of the List Box is to present a list of items where the user can click and
select the items from the list. In order to add items to the list, we can use the Add Item method.
For example, if you wish to add a number of items to list box 1, you can key in the following
statements.

The Combo Box

The function of the Combo Box is also to present a list of items where the user can click
and select the items from the list. However, the user needs to click on the small arrowhead on
the right of the combo box to see the items which are presented in a drop-down list. In order to
add items to the list, you can also use the Add Item method

The Check Box

The Check Box control lets the user to select or unselect an option. When the Check Box
is checked, its value is set to 1 and when it is unchecked, the value is set to 0. You can include
the statements [Link]=1 to mark the Check Box and [Link]=0 to unmark the
Check Box, as well as use them to initiate certain actions
The Option Button

The Option Button control also lets the user selects one of the choices. However, two or
more Option Buttons must work together because as one of the Option Buttons is selected, the
other Option Buttons will be unselected. In fact, only one Option Button can be selected at one
time. When an option button is selected, its value is set to “True” and when it is unselected; its
value is set to “False”. In the following example, the shape control is placed in the form together
with six Option Buttons. When the user clicks on different option buttons, different shapes will
appear. The values of the shape control are 0, 1, and 2,3,4,5 which will make it appear as a
rectangle, a square, an oval shape, a rounded rectangle and a rounded square respectively.

List Box

The Drive List Box is for displaying a list of drives available in your computer. When
you place this control into the form and run the program, you will be able to select different
drives from your computer.

The Directory List Box

The Directory List Box is for displaying the list of directories or folders in a selected
drive. When you place this control into the form and run the program, you will be able to select
different directories from a selected drive in your computer.
3.3 OTPUT DESIGN

An application is successful only when it can be generated efficient and effective reports.
The output from the system is either by the monitor or by hard copies. Output designs aims at
communicating the result of the processing to the user and the management. Whenever the user
does an erroneous data error message is display and the user can move to next field only after
entering the correct data popup menu has been providing for list of data for certain fields where
the user can make the selection.

The reports are generated to suit the needs of the management. The reports is generate
with appropriate labels. A quality output is one which meets the requirements of the end user
and presents the information clearly. In output design it is determined how the information is
to be displayed. It is the most important and direct source information to the user. When
analysis designs computer output, they should:

➢ Identify the specific output that is needed to meet the requirements.

➢ Select methods for presenting information.
➢ Create document, report or other formats that contains information produced by the
system

3.4 APPLICATION SPECIFICATION

FRONT-END VISHUAL BASIC

INTRODUCTION TO VISUAL BASIC

Visual Basic 6.0 is the Microsoft's latest and greatest version of Visual Basic
programming language. Although writing program can be a tedious chore, at times visual basic
Attractive features of visual Basic:

➢ Data access features allow creating database and front end applications for the most
popular database formats, including Microsoft SQL server and other enterprise level
databases.
➢ ActiveX technological allow the user to use the functionality provided by other
applications such as Microsoft word processor, Microsoft Excel spreadsheet and
Windows applications.
➢ Internet capabilities make it easy to provide access form documents and applications
across the internet from within your application.

Microsoft Visual Basic on a programming language written for beginners called Basic.
The original language designer wanted to develop a programming language that beginners
could e. Visual Basic is none of the most programming environments available today.
Application wizard is used to create a program. Also creating program without the help of
application wizard is not difficult. We have to understand about Visual Basic environment.

EVENT DRIVEN vs TRADITIONAL PROGRAMMING

In a traditional application, the application itself rather than an event controls the portions
of code that executes. Execution starts with the first line of executable code and follows a
defined path way through the application, calling procedures as needed.

Connectivity used:

The tools used to develop the project is ADODB. ADODB enables us to use a
programming language to access and manipulate data in local or remote database and to
manage databases, their objects and their structures. ODBC is a standard protocol that permits
applications to connect to a variety of external database servers and files.
Various data access objectives used is as follows:

DB engine:

This object is used to set DB engine system parameters and default workspace.

Workspace:

This object is used to support simultaneous transactions and it acts as a container for open
database.

Database;

This object is used to define the database tables, relations and stored queries.

Table def;

It represents the definition of a table in the current database or an attached table,

Record set object;

It corresponds to cursor view into a database table or the results of a query.

Relation:

It represents the relation between fields in tables or queries.

BACK END MS ACCESS

MS-Access is called the Backend because it support all the programs modules and
utilities co-ordinate all communication between the user and the data in the database. In this
sense the backend constitutes the real Database Management System. MS-Access allows
conditional retrieval and manipulation of data, creation modification and detection of tables. It
generates printed reports.

It automatically performs mathematical calculations on numerical data in our database.

MS-Access can incorporate the results of calculations accounts in printed reports, and it can
actually store the result in a database for further use in applications such as balance sheets,
sales, transactions and accounts receivable reports. It supports OLE. It acts as a backend for
number of GUIs

MS-Access is a powerful database. It will be simple and yet offers you the tools you need
to handle complex data.

3.5 INTRODUCTION TO VISUAL BASICS

VISUAL BASIC is a high level programming language which evolved from the earlier
DOS version called BASIC. BASIC means beginners All-purpose Symbolic Instruction code.
It is a very easy programming language to learn. The codes look a lot link English Language.
Different software companies produced different versions of BASIC, such as Microsoft
QBASIC, QUICKBASIC, GWBASIC, IBM BASICA and so on. However, people prefer to
use Microsoft Visual Basic today, as it is a well developed programming language and
supporting resources are available everywhere. Now, there are many versions of VB exist in
the market, the most popular one and still widely used by many VB programmer is none other
than Visual Basic 6. We also have [Link], VB2005, VB 2008 and the latest VB2010, Both
VB2010 are full object oriented programming (OOP) language.

VISUAL BASIC is a VISUAL, and events driven Programming Language. These are the
main divergence from the old BASIC. In BASIC, programming is done in a text-only
environment and the program is executed sequentially. In VB, programming is done in a
graphical environment. In the BASIC, we have to write program code for each graphical object
you wish to display it on screen, including its position and its color. However, In VB, you just
need to drag and drop any graphical object anywhere on the form, and you can change its color
any time using the properties windows.

On the other hand, because the user may click on the certain object randomly, so each
object has to be programmed independently to be able to response to those actions. Therefore,
a VB Program is made up of many sub programs, each has its own program code, and each can
be executed independently and at the same time each can be linked together in one way or
another.

With VB 6, you can create any program depending on your objective. For example, you
are a college or university lecturer, you can create educational programs to teach business
economics, engineering, computer science, accountancy, financial management, informatic
system and more to make teaching more effective and interesting. If you are in business, yo
can also create business programs such as inventory management system, point-of-sale system
payroll system, financial program as well as accounting program to help manage your business
and increase productivity. For those of you who like game and working as programmer, you
create those programs as well. Indeed there is no limit to what program you can create. There
are many such programs in this tutorial, so you must spend more time on the tutorial in order
to learn how to create those programs.

3.6 INTRODUCTION TO MS ACCESS

Microsoft Access, also known as Microsoft Office Access, is a database management

system from Microsoft that combines the relational Microsoft Jet Database Engine with a
graphical user interface and software-development tools. It is a member of the Microsoft Office
suite of applications, included in the professional and higher editions or sold separately.

Microsoft Access stores data in its own format based on the Access Jet Database Engine.
It can also import or link directly to data stored in other applications and databases.

Software developers and data architects can use Microsoft Access to develop application
software, and "power user "can use it to build software applications. Link other office
application; access is supported by Visual Basic for Application, an object-oriented
programming language that can reference variety of object including DAO (Data Access
Objects), ActiveX Data Object, and many other ActiveX Components. Visual objects used in
forms and reports expose their methods and properties in the VBA programming environment,
and VBA code modules may declare and call windows operating-system functions.

In addition to using its own database storage file, Microsoft Access also may be used as
the "front-end' with other products as the 'back-end' tables, such as Microsoft SQL Server and
non- Microsoft products such as oracle and Sybase. Multiple backend sources can be used by
a Microsoft Access Jet Database (accdb and mdb formats). Similarly, some applications such
as Visual Basic, [Link], or Visual Studio. NET will use the Microsoft Access database
format for its table and queries. Microsoft Access may also be part of a complex solution, where
it may be integrated with other technologies such as Microsoft Excel, Microsoft Outlook,
Microsoft Word, Microsoft PowerPoint and ActiveX controls.

Access table support a variety of standare field type, indices, and referential integrity
including cascading updates and deletes. Access also includes a query interface, forms to
display and enter data, and reports for printing. The underlying Jet database, which contains
these objects, is multiuser-aware and handles record-locking.

Repetitive task can be automated through macros with point-and-click. It is also easy to
place a database on a network and have multiple user share update data without overwriting
each other's work. Data is locked at the record level which is significantly different from Excel
which locks the entire spreadsheet.

There are template database within the program and for download from their website.
These options are available upon starting access and allow users to enhance a database with
predefined tables, queries, form, reports, and macrus. Database templates support VBA code
but Microsoft's templates do not include VBA code.

Programmers can create saluting using the programming language visual basic for
application which is similar to visual basic 6.0 and used through the Microsoft office programs
such as excel, word, Outlook and power point. Most VB6 code, including the use of Windows
API calls, can be used in VBA. Power users and developers can extent basic end-user solutions
to a professional solution with advanced automation, data validation, error trapping, and multi-
user support.
The number of simultaneous users that can be supported depends on the amount of data,
the tasks being performed, level of use, and application design. Generation accepted limits are
solutions with 100 or fewer simultaneous connections. This capability is often a good fit for
department solutions. If using an Access database solution in a multi-user scenario, the
application should be "split". This means that the tables are in one file called the back end and
the application components are in another file called the front end. The linked tables in the
front end point to the back end file. Each user of the access application would then receive his
or her own copy of the front end file. A compiled version of an Access database can be created
to prevent user from accessing the design surfaces to modify module code, forms, and report.
An MDE/ACCDE file is a Microsoft Access database file with all modules compiled and all
editable source code removed. Both the MDE/ACCDE and ADE versions of an Access
database are uses when the application's source code should be kept confidential.

Microsoft also offers developer extensions for download to help distribute Access 2007
applications, create database templates, and integrate source code control with Microsoft Visual
Source Safe. Coding to link Visual basic to MS Access.

Programs can be written in Visual Basic to access Microsoft access databases. Some
programming concepts such as subroutines and looping along with knowledge of database and
SQL may be required to write programs to link Microsoft Access database to Microsoft Visual
Basic code. The ADODB object is used to create a connection to the database and access the
records using ADODB. Connection ADODB. Record set APIs respectively SQL is used to
search the database for records that match the information provide as parameter to the
subroutine. Data in the records can also manipulated in the Visual Basic program code.
3.7 TABLE DESIGN

1 .Purchase details
DATA NAME DATA TYPE DESCRIPTION
Date Date Date

Cname Text Company name

Pname Text Product name

Qnty Number Quantity

Rate per unit Number Rate per unit

Total Number Total

2. Sales details
DATA NAME DATA TYPE DESCRIPTION
Date Date Date

Cname Text Company name

Pname Text Product name

Qnty Number Quantity

Rate per unit Number Rate per unit

Total Number Total

3. Administrative details
DATA NAME DATA TYPE DESCRIPTION
Date Date Date

Ledger name Text Ledger name

Account name Text Account head

Qnty Number Quantity

Rate per unit Number Rate per unit

Total Number Total

4. Stock details
DATA NAME DATA NAME DESCRIPTION
Date Date Date

Sname Text Stock list name

Pname Text Product name

Stock Number Stock

Rate per unit Number Rate per unit

Total stock Number Total

5. Staff details
DATA NAME DATA TYPE DESCRIPTION
Date of entry Date Date of entry

Sname Text Staff name

Department Text Department

Address Text Address

Date of joining Date Date of joining

Salary Number Salary

CHAPTER - Ⅳ

SYSTEM TESTING AND IMPLEMENTATION

CHAPTER - Ⅳ
SYSTEM TESTING AND IMPLEMENTATION

4.1 THE TESTING FIVE TYPES OF ACTIVITIES

➢ White-box testing
➢ Black box testing
➢ Acceptance testing
➢ Unit testing
➢ Integration Testing

WHITE-BOX TESTING
White-box testing is a method of testing software that tests internal structures or
workings of an application, as opposed to its functionality. In white-box testing an internal
perspective of the system, as well as programming skills, are used to design test cases. The
tester chooses input to exercise paths through the code and determine the appropriate outputs.
This is analogous to testing nodes in a circuit. While white-box testing can be applied at the
unit, integration and system levels of the software testing process, it is usually done at the unit
level. It can test paths within a unit, paths between units during integration, and between
subsystems during a system level test. Through this method of test design can uncover many
errors or problems; it might not detect unimplemented part of the specification or mission
requirements.

BLACK-BOX TESTING

Black-box testing is a method of software testing that examines the functionality of an

application without peering into its internal structures or workings. This method of test can be
applied to virtually every level of software testing unit, integration, system and acceptance. It
typically comprises most if not all higher level testing but can also dominate unit testing as
well.
ACCEPTANCE TESTING

Acceptance Testing is a test conducted to determine if the requirements of a specification

or contract are met. It may involve chemical tests, physical tests, or performance tests, in
systems engineering it may involve black-box testing.

performed on a system prior to its delivery. Software developers often distinguish

acceptance testing by the system provider from acceptance testing by the customer prior to
accepting transfer of ownership. In the case of software, acceptance testing performed by the
customer is known as user acceptance testing end-user testing site testing, or field testing.

UNIT TESTING
Unit testing performs basic tests at component level and test a specific business process,
application, and or system configuration. Unit test ensures that each unique path of a business
process performs accurately to the documented specification, functionality and contains clearly
defined inputs and exempted results. The unit testing is conducted by preparing the following
reports.

INTEGRATION TESTING

Integration test is done to test integrated software components to determine if they

actually run as one program. Integration test demonstrate that although the components were
individually satisfactory, as shown by successful unit testing, the combination of components
is arisen from the combination of components.
4.2 SYSTEM IMPLEMENTATON
System implementation is an important stage of the project where the theoretical design
is turned into practical system. The main stages of implementation are as follows:

• Implementation planning
• Training staff users

Implementation Planning
Implementation planning is the first task in system implementation, planning means
deciding on the methods and time scale to be adopted. Once the planning is over the major
effort in the computer department is to ensure is to that the programs in the system are working
properly.

Training User Staff

During this time the user department should concentrate on training user staff. When the
staffs in user department have been trained a full system test can be carried out, involving both
computer and clerical procedures. It is the stage of implementation, which is aimed at the
system works accurately and efficiently before live operation.

Changeover from old to the new system may take place when the system has been
completed. User manager is satisfied with the results if the system tests. The operation manager
is satisfied with the performance of the system. When the staff have been trained, a full system
test can be aimed to ensure that a system works accurately and efficiently before live operation
commences. When programmers have tested each program individually using the data
collected from the unit and has verified that these modules suit specification of the user and the
environment must be tested to the satisfaction of the system and user.
4.3 FINDINGS

The following are the findings based on the observation in the training

➢ The company Building area is too small.

➢ Annual turnover is less
➢ The salary based on the experiences of the workers in the organization.
➢ They are purchasing fewer items of finished goods.
➢ The organization is not well secured
➢ No modern techniques and new machinery adopted in the concern.
4.4 SUGGESTIONS

➢ They have to enlarge the company building.

➢ To increase the annual turnover
➢ To provide more salary to workers according to their work efficiency
➢ To improve the more sales to get more earnings. To increase the safety of the
organization
➢ To utilizes new techniques and new machinery in order to increase the production.
4.5 CONCLUSION

The project "INVENTORY MANAGEMENT SYSTEM” incorporates almost all

details of staff in an organization. All the modules have been tested with all possible data. The
system is made so user friendly so that persons having little computer knowledge could easily
work with this system. The project INVENTORY MANAGEMENT SYSTEM we have
member conclude that by using this visual basic 6.0 all the activities regarding transaction
details can be easily and correctly stored further it can be modified or altered or upgraded in
any concern. It works as per their convenience.

This system has been developed in visual basic 6.0 to reduces the response time and
ensure flexibility. These systems also give opportunity for the further development and
enhancements of the existing system by providing the management with necessary information
for caring out their daily function.
4.6 SCOPE OF FUTURE DEVELOPMENT

There is scope for future development of this project. The world of computer fields is
not static; it is always subject to be dynamic. The technology which is famous today becomes
outdate the very next day. To keep abstract of technical improvements, the system may be
further refined. So, it is not concluded. Yet it will improve with further enhancements.
Enhancements can be done in an efficient manner this even update the same with further
modification establishment and can be integrated with minimal modification. Thus the project
is flexible and can be enhanced at any time with more advanced features. In future can be
implementing the Bill details to the customer register email id.
BIBLIOGRAPHY
BIBLOGRAPHY

1. Martin "Principal of Data Base Management" Tata McGraw hill publication, III Edition
2000.

[Link] Siler and Jeff spots "Using Visual Basic 6.0"- Prentice hall India publications. II edition
2002

[Link] Paul Meller "The Complete Reference TATA McGraw hill publications, III edition
2000. visual basic 6.0"

4. Taxali MS-Office"- TATA McGraw hill publications, II Edition 2002.

FORMS AND CODING
FORM Ⅰ

Private Sub Command1_Click()

If [Link] = "Admin" And [Link] = "123" Then

[Link]

Else

MsgBox "Invalid Username or Password"

End If

[Link] = Clear

[Link] = Clear

End Sub

Private Sub Command2_Click()

[Link] = Clear

[Link] = Clear

End Sub

Private Sub Command3_Click()

End

End Sub
FORM Ⅱ

Private Sub Command1_Click()

[Link]

End Sub

Private Sub Command2_Click()

[Link]

End Sub

Private Sub Command3_Click()

[Link]

End Sub

Private Sub Command4_Click()

[Link]

End Sub

Private Sub Command5_Click()

[Link]

End Sub

Private Sub Command6_Click()

End

End Sub
FORM Ⅲ

Private Sub Command1_Click()

[Link]

End Sub

Private Sub Command2_Click()

[Link]

End Sub

Private Sub Command3_Click()

[Link]

End Sub

Private Sub Command4_Click()

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

End Sub

Private Sub Command5_Click()

[Link]

End Sub

Private Sub Text5_lostfocus()

[Link] = Val([Link]) * Val([Link])

End Sub
FORM Ⅳ

Private Sub Command1_Click()

[Link]

End Sub

Private Sub Command2_Click()

[Link]

End Sub

Private Sub Command3_Click()

[Link]

End Sub

Private Sub Command4_Click()

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

End Sub

Private Sub Command5_Click()

[Link]

End Sub

Private Sub Text5_Change()

[Link] = Val([Link]) * Val([Link])

End Sub
FORM Ⅴ

Private Sub Command1_Click()

[Link]

End Sub

Private Sub Command2_Click()

[Link]

End Sub

Private Sub Command3_Click()

[Link]

End Sub

Private Sub Command4_Click()

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

End Sub

Private Sub Command5_Click()

[Link]

End Sub
FORM Ⅵ

Private Sub Command1_Click()

[Link]

End Sub

Private Sub Command2_Click()

[Link]

End Sub

Private Sub Command3_Click()

[Link]

End Sub

Private Sub Command4_Click()

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

End Sub

Private Sub Command5_Click()

[Link]

End Sub
FORM Ⅶ

Private Sub Command1_Click()

[Link]

End Sub

Private Sub Command2_Click()

[Link]

End Sub

Private Sub Command3_Click()

[Link]

End Sub

Private Sub Command4_Click()

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

[Link] = Clear

End Sub

Private Sub Command5_Click()

[Link]

End Sub
LOGIN FORM
HOME PAGE
PURCHASE FORM
SALES FORM
STOCK FORM
ADMINISTRATIVE FORM
STAFF FORM