Docstoc

human resource management system in VB.net and SQL

Document Sample
human resource management system in VB.net and SQL Powered By Docstoc
					HCL                                                     hrms




MID – TERM REPORT   ON



                       “HUMAN RESOURCE
                          MANAGEMENT
                            SYSTEM”




      (AMITY INSTITUTE OF INFORMATION TECHNOLOGY
                AMITY UNIVERSITY,UTTAR PRADESH
                           JUNE’08)




SUBMITTED TO:-                         SUBMITTED BY:-

MR. SHAMBHU JHA                        SALONI MANGAL

(PROJECT CORDINATOR)                   BCA 6TH SEM

                                       A1004806045




    1
HCL                                                            hrms




                   ACKNOWLEDGEMENT




         I EXPRESS MY DEEP SENSE OF GRATITUDE TO MY PROJECT
SUPERVISOR MR. SHAMBHU JHA FOR HIS EXPERT GUIDANCE, STIMULATING
DISCUSSIONS AS WELL AS CONTINUED IMPETUS THROUGHOUT THE PERIOD OF
THIS PROJECT.




                I WISH TO EXPRESS MY GRATITUDE TO ALL THOSE, WITH
WHOM I WORKED, INTERACTED AND WHOSE THOUGHTS AND INSIGHT HELPED
ME FURTHER INCREASING MY KNOWLEDGE AND UNDERSTANDING OF THE
STUDY OF THIS REPORT.




                I AM ALSO GRATEFUL TO ALL MY FRIENDS, FACULTIES, AND
RELATIVES FOR THEIR TIMELY SUPPORT AND CONTRIBUTION IN ATTAINING
THE OBJECTIVE OF THE REPORT.




                                                      Developer

                                                 SALONI MANGAL

                                                 BCA 6TH SEM

                                                 A1004806045




    2
HCL                                                        hrms



                             TABLE OF CONTENTS

1. Introduction to company …………………………………………..4


            1.1   Introduction of project
            1.2   Identification of problem
            1.3   Objectives and scope


2   Introduction to hardware & software……………………......…11


            2.1   Introduction to VB.net
            2.2   Introduction to SQL
            2.3   Our role in project


3   System Analysis……………………………………………………19
            3.1   Existing system
            3.2   Proposed system
            3.3   Feasibility study


4   System Design………………………………………………………28
            4.1   Detailed design
            4.2   Data flow diagrams
            4.3   Database design
5   Form design……………………………………………………...32
6   Bibliography…………………………………………………….....39
7   Appendix……………………………………………………………40




     3
HCL                                hrms



1. INTRODUCTION OF COMPANY (HCL)




    4
  HCL                                                                                   hrms



         INTRODUCTION OF PROJECT

                        Today    computer     has   revolutionized   the      working   in   various
  organizations. Computer hardware cannot work alone we need software to run them. Software
  may be for general use or for practical use. Software which is designed for a particular
  customer is known as customized software.

                  All these work when done manually, is a bit tire some and prone to errors.
  This create requirement for creating this product. Using Visual Basic and SQL, we have used
  it in the project, to make it more effective and efficient, programmable.




  DESCRIPTION OF THE PROJECT

  Title of this project is “HUMAN RESOURCE MANAGEMENT SYSTEM”.

  The presented project here is made in view overcoming the problems faced by the many
  COMPANIES AND ORGANISATIONS regarding Maintenance, Recording and keeping of
  Data base, employee information, information of department, information regarding the test,
  grades, benefits of each employee and the candidates etc. i.e. “General Human Resource
  Management System”.

                                      Department
Employee information                                                             Test




                                       HUMAN
                                     RESOURCE
                                     MANAGEMENT
                                     SYSTEM
                                                                                    Job
 Grade




                       Benefit                          Candidate




         5
HCL                                                                                 hrms

                         IDENTIFICATION OF PROBLEM




EXISTING SYSTEM WITH LIMITATIONS:-




                                 The existing system was having a number of difficulties
regarding maintaining the record of employee information, information of department,
information regarding the test, grades, benefits of each employee and the candidates etc. that is
in managing HR Management.




      First of all our focus will be on the manual system for Human Resource Management.
       One can observe that for the whole process of all the record of employee information,
       information of department, information regarding the test, grades, benefits of each
       employee and the candidate’s etc. one organization needs to recruit too many staffs to
       handle the specific duty.

          Second is the efficiency, time elapsed and the human errors involved.
      Finally Beside these the most important is the data storage, searching for a particular
       record, transferring the data to its various networks and data piracy.




       6
HCL                                                                                hrms

                               OBJECTIVE AND SCOPE



PROPOSED SYSTEM WITH OBJECTIVES:-




                     The proposed system is the panacea of above mentioned problems. By
using this system an organization or a company can handle its all kinds of above mentioned
works efficiently, accurately and swiftly with all kinds of security features by involving a few
employees.

OBJECTIVE AND SCOPE OF THE STUDY: -



                Objective of doing this project is to enhance my knowledge in
the field of Distributed technology using VB . net and SQL. Some of the client
requirement and objectives of this project is as under: -

The main objective of study: -


* It should contain all the information of an Organisation.

* It should contain all the information of people working in that Organisation.

* It should contain all the information of their professional working status.




PURPOSE: -
Computerized HUMAN RESOURCE MANAGEMENT SYSTEM is developed to facilitate
the general administration system to manage the various information of the employees
working in that organisation or a company. So, that company can access accurate information
quickly and easily as and when required, thereby improving its operational efficiency &
effectiveness. In this, We can also make query regarding the test that is being generated by the
company for the new candidates.




      7
HCL                                                                              hrms


2. HARDWARE AND SOFTWARE USING


Hardware and software that we are using in developing this project are as described below:-

Software Tools

              Tools                  : VB. net

                                     : SQL

 Platform

              Platforms like

              Windows platform like-98, 2000, XP & Vista



HARDWARE TOOLS

      Preferably Pentium III/Celeron/AMD based system,
      512MB RAM,
      20 GB HDD.




       8
    HCL                                                                                   hrms


    “Front End remains on client side. Front end is made for end user who uses
    our application. Basically in front end our input-output forms reside which takes
    the input from the client and gives output back to client.‖


    INTRODUCTION VB.NET               (front end)

    Windows Forms is the new platform for Microsoft Windows application development, based
    on the .NET Framework. This framework provides a clear, object-oriented, extensible set of
    classes that enable you to develop rich Windows applications. Additionally, Windows Forms
    can act as the local user interface in a multi-tier distributed solution. Windows Forms is a
    framework for building Windows client applications that utilize the common language
    runtime. Windows Forms applications can be written in any language that the common
    language runtime supports.

    What Is a Form?

    A form is a bit of screen real estate, usually rectangular, that you can use to present
    information to the user and to accept input from the user. Forms can be standard windows,
    multiple document interface (MDI) windows, dialog boxes, or display surfaces for graphical
    routines. The easiest way to define the user interface for a form is to place controls on its
    surface. Forms are objects that expose properties which define their appearance, methods
    which define their behavior, and events which define their interaction with the user. By setting
    the properties of the form and writing code to respond to its events, you customize the object
    to meet the requirements of your application.

    Some of the advantages of using Windows Forms include the following:

          Lower total cost of ownership: Windows Forms takes advantage of the versioning
    and deployment features of the common language runtime to offer reduced deployment costs
    and higher application robustness over time. This significantly lowers the maintenance costs
    (TCO) for applications written in Windows Forms.
          Architecture for controls: Windows Forms offers an architecture for controls and
    control containers that is based on concrete implementation of the control and container
    classes. This significantly reduces control-container interoperability issues.

          9
    HCL                                                                                 hrms

          Security: Windows Forms takes full advantage of the security features of the common
    language runtime. This means that Windows Forms can be used implement everything from
    an untrusted control running in the browser to a fully trusted application installed on a user's
    hard disk.
          XML Web services support: Windows Forms offers full support for quickly and
    easily connecting to XML Web services.
          Rich graphics: Windows Forms is one of the first ship vehicles for GDI+, a new
    version of the Windows Graphical Device Interface (GDI) that supports alpha blending,
    texture brushes, advanced transforms, rich text support, and more.
          Flexible controls: Windows Forms offers a rich set of controls that encompass all of
    the controls offered by Windows. These controls also offer new features, such as "flat look"
    styles for buttons, radio buttons, and check boxes.

    Crystal Reports

    Crystal Reports for Visual Basic .NET is the standard reporting tool for Visual Basic.NET; it
    brings the ability to create interactive, presentation-quality content — which has been the
    strength of Crystal Reports for years — to the .NET platform. With Crystal Reports for Visual
    Basic.NET, you can host reports on Web and Windows platforms and publish Crystal reports
    as Report Web Services on a Web server.

    To present data to users, you could write code to loop through recordsets and print them inside
    your Windows or Web application. However, any work beyond basic formatting can be
    complicated: consolidations, multiple level totals, charting, and conditional formatting are
    difficult to program.




        10
HCL                                                                                 hrms

ACTIVE X DATA OBJECTS



         In Visual Basic .Net, three data access interfaces are available: Active X Data
Objects( ADO), Remote Data Objects (RDO) and Data Access Objects (DAO). These access
interfaces are used to access the data from database.

Why use ADO?

       Consistently accessing data within the enterprise is a challenge for today's business
applications. ODBC provides the first step toward overcoming this challenge by enabling
applications to access relational databases.

       ADO provides consistent, high-performance access to data, whether you're creating a
front-end database client or middle-tier business object using an application, tool, language, or
even an Internet browser. ADO is the single data interface you need for developing 1- to n-tier
client/server and Web-based, data-driven solutions.




The ADO Object Model

The ADO object model defines a collection of programmable objects that you can use in
Visual Basic, Visual C++, Microsoft Visual Basic, Scripting Edition, Java, and any platform
that supports both COM and Automation. The ADO object model is designed to expose the
most commonly used features of OLEDB.

The ADO object model contains their objects:

      Connection
      Command
      Record set


The Connection Object

The Connection object allows you to establish a communication link with a data source. The
Connection object provides a mechanism for initializing and establishing the connection,
executing queries, and using transactions.



    11
HCL                                                                                 hrms



The Command Object

The Command object allows you to issue commands to the database. These commands can
be, but are not limited to, query strings, prepared query strings, and associated parameters with
query strings. The actual command language and features supported are dependent on the
underlying provider for the database. The information and examples contained here focus on
the Microsoft ODBC Provider that supports a wide variety of relational databases.




The Recordset Object

The Recordset object provides methods for manipulating result sets; it allows you to add,
update, delete, and scroll through records in the result set. You can retrieve and update each
record using the Fields collection and the Field objects. You can make updates on the
Recordset object in an immediate or batch mode. When you create a Recordset object, a
cursor is automatically opened.




    12
HCL                                                                               hrms


                      SQL (ORACLE) DESCRIPTION               (Back end)

SQL (Structure Query Language) is a simple and powerful language used to create, access,
and manipulate data and structure in the database. SQL statements into various categories,
which are:


(1) Data Definition Language
(2) Data Manipulation Language
(3) Transaction Control Statements
(4) Data Control Language


(1)DATA DESCRIPTION LANGUAGE (DDL) STATEMENTS:-


DDL statements are used to define, alter or drop database objects. The following table gives
an overview about usage of DDL statements in ORACLE.
The commands used are: -


(a) CREATE:- Used to create table having rows and columns
(b) ALTER:- Used to alter the structure of the database object
(c) DELETE:- Used to delete the database objects.
(d) RENAME:-Used to rename the database objects.




(2)DATA MANIPULATION LANGUAGE (DML) STATEMENTS:-


DML statements enable users to query or manipulate data in existing objects. DML statements
are normally the most commonly used commands.
The commands used are: -


(a) DELETE:- It removes rows from the database objects
(b) INSERT:- It adds new rows of data to database objects.
(c) SELECT:- It retrieves data from one or more tables.
(d) UPDATE:- It changes column values in existing rows of database objects.


    13
HCL                                                                               hrms


(3)DATA CONTROL LANGUAGE (DCL) STAEMENTS:-


The SQL sentences used to control the behavior of objects are called data control statements.
The commands used are:


(a) GRANT:- Grant statements provide access to various tables.
(b) REVOKE:- Revoke statement is used to deny the grant.


(4)TRANSACTION CONTROL LANGUAGE (TCL) STATEMENTS:-


TCL statements manage the change made by DML statements and group DML statements into
transactions. The SQL statements used to control various transactions are called transaction
control statement.
The commands used are: -


(a) COMMIT:- Make a transaction’s changes permanent.
(b) ROLLBACK:- Undo changes in a transaction, either since the transaction
started or since a save point.


Oracle is a powerful relational database management system that offers a large feature set.
Along with Microsoft SQL Server, Oracle is widely regarded as one of the two most popular
full-featured database systems on the market today.

The Oracle Database (commonly referred to as Oracle RDBMS or simply Oracle) consists
of a relational database management system (RDBMS) produced and marketed by Oracle
Corporation. As of 2009, Oracle remains a major presence in database computing.

The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form
of data files. Tablespaces can contain various types of memory segments, such as Data
Segments, Index Segments, etc. Segments in turn comprise one or more extents. Extents
comprise groups of contiguous data blocks. Data blocks form the basic units of data storage.
At the physical level, datafiles comprise one or more data blocks, where the block size can
vary between data-files.


    14
HCL                                                                             hrms

ORACLE COMPONENTS



I. Oracle DBMS

A. Oracle Display System (ODS) - activities in the system displayed on the system console.

B. Oracle Data Loader (ODL) - loads raw data into tables.

C. After Image Journaling (AIJ) - program for journaling each change to data in case of
need for recovery.

D. System Global Information (SGI) - shows shared memory set up.

E. IOR - program for start and stopping ORACLE system for the DBA. This contains the
setups and saves.

F. Export/Import - for use to restore of backup archival storage.

II. Pro*SQL - host language interface - group of subroutines which translates SQL statements
into machine code.

III. SQL*Plus - include SQL and SQL*Plus commands.




    15
HCL                                                                            hrms



OUR ROLE IN PROJECT

My role in the project is to develop the modules. HUMAN RESOURCE MANAGEMENT
SYSTEM contains a various module, which Are as given below:



   (a)    Employee
   (b)    Department
   (c)    Test
   (d)    Grade
   (e)    Job
   (f)    Benefit
   (g)    Candidate




MODULE DESCRIPTION:-

   (a)    Employee: - In this module a company can enquire about the information of any
          employee working in that company. In this module one can add, search, update and
          delete the employee’s information according to their requirement.


   (b)    Department:- In this specific module one can know about the various departments
          of that company (for ex- Finance, Marketing, HR etc) and he/she can add, search,
          update and delete the information about the various departments of that company
          according to their requirement or need.


   (c)    Test: - This module is named as test, which contain all the information related to
          those candidates who are applied for the admission in that company. It contain all
          the information such as- the maximum n minimum marks for the test, name of the
          employee by whom the test was conducted etc.


   (d)    Job:- This module of ―HR Management System‖ include the job identity number
          of an employee and the name of the job that is being performed by the employees.


   16
HCL                                                                                 hrms


    (e)    Grade:- This module include the grade identity number of an employee and the
           name of the grade that is being given to the employees. And one can add, search,
           update and delete the information about the grades of the employee according to their
           requirement.


    (f)    Candidate: - Candidate is one of the big module which contain personal as well as
           professional information of an employee. For ex- candidate id, name, address,
           phone number, experience, email id etc.


    (g)    Benefit:- This module is named as benefit which include the benefit id, name,
           benefit effective from, amount, status etc. And in this module one can add, search,
           update and delete the information about the benefit of the employee according to their
           requirement.



NOTE:-         In this project of ―HUMAN RESOURCE MANAGEMENT SYSTEM‖ we
developed the above specified modules. And till now we already completed with five of our
module those are- Employee, Department, Test, Grade and Job. Making of crystal report and
testing process is under construction.
.




    17
HCL                                                                              hrms

                             3. SYSTEM ANALYSIS



 3.1 EXISTING SYSTEM



  The HR Administration falls short of controlling the employee’s activities in analyzing
  his/her strengths and weakness. The decision for appraisal of assigning next project to the
  employee or to train him/her to enhance the skills – where lies with proper projection. He
  is not provided with the detailed project information done or to be assigned based on
  Application / Verticals.



DRAWBACKS IN EXISTING SYSTEM:



   Need of extra manual effort.
   It used to take much time to find any employee
   Not very much accurate.
   Danger of losing the files in some cases.




  18
 HCL                                                                              hrms

 3.2 PROPOSED SYSTEM



Decision in assigning proper skillful hands for the project is an important issue in HR Module.
The HR Administrator should report with the personal holding the necessary skills required for
the project assignment. The decision in making analysis about the employee’s skills is a prime
important before booting in. The proposed system of HR Module is the right software to be
incorporated into the Automation of HR Software for helping the organization needs with
respect to skilful Human Resource.



The proposed system provides detail general information about the employee along with
Educational, Certification, Skill and Project details. It enhances the HR Management in adding,
viewing and updating employees’ details and generates various reports regarding employee’s
skill and experience. Suggestions and Grievances posted by the employees are upheld for taking
care of the necessary steps in forwarding company’s obligation.

 .




         ADVANTAGES OF PROPOSED SYSTEM:



      Very fast and accurate.
      No need of any extra manual effort.
      No fever of data loss.
      Just need a little knowledge to operate the system.
      Doesn’t require any extra hardware device.
      At last very easy to find the employees.




      19
HCL                                                                                 hrms

3.3 FEASIBILITY STUDY

Once the problem is clearly understood, the next step is to conduct feasibility study, which is
high-level capsule version of the entered systems and design process. The objective is to
determine whether or not the proposed system is feasible. The three tests of feasibility have
been carried out.

     Technical Feasibility
     Economical Feasibility
     Operational Feasibility



TECHNICAL FEASIBILITY

   In Technical Feasibility study, one has to test Whether the proposed system can be
developed using existing technology or not. It is planned to implement the proposed system
using java technology. It is evident that the necessary hardware and software are available for
development and implementation of the proposed system. Hence, the solution is technically
feasible.

ECONOMICAL FEASIBILITY

  As part of this, the costs and benefits associated With the proposed system compared and
the project is economically feasible only if tangible or intangible benefits outweigh costs. The
system development costs will be significant. So the proposed system is economically
feasible.

OPERATION FEASIBILITY

It is a standard that ensures interoperability

Without stifling competition and innovation among users, to the benefit of the public both in
terms of cost and service quality. The proposed system is acceptable to users. So the proposed
system is operationally feasible.




    20
HCL                                                                       hrms

                                      PROJECT MODEL



Methodology: -


   The methodology used is ―The classic Life-cycle‖



            System

            Engineering

                           Analysis



                                          Design


                                                      Code
                                                             Testing
                                                                       Maintenance




    21
HCL                                                                                   hrms



                                     4. SYSTEM DESIGN

4.1 Detailed Design



DATABASE

             A database is a set of data, organized for easy access. The database is an actual
data; it is the database that you will be accessing when you need to retrieve data.



DATA DICTIONARY

             The data dictionary is a set of tables Oracle uses to maintain information about
the database. The data dictionary contains information about tables, indexes, clusters and so
on.



DBA (DATABASE ADMINISTRATOR)

       The DBA is the person responsible for the operation, configuration and performance of
the database. The DBA is charged with keeping the database operating smoothly, ensuring
that backups are done on regular basis (and that backups work), and installing new software.
Other responsibilities might include planning for future expansion and disk space needs,
creating databases and table spaces, adding users and maintaining security, and monitoring the
database and retuning it as necessary. Large installations might have teams of DBA’s to keep
the system running smoothly; alternatively, the task might be segmented among the DBA’s.




      22
HCL                                                                                 hrms

4.2 DATA FLOW DIAGRAMS:




A graphical tool used to describe and analyze the moment of data through a system manual or
automated including the process, stores of data, and delays in the system. Data Flow Diagrams
are the central tool and the basis from which other components are developed.                The
transformation of data from input to output, through processes, may be described logically and
independently of the physical components associated with the system. The DFD is also know
as a data flow graph or a bubble chart.




CONTEXT DIAGRAM:

The top-level diagram is often called a ―context diagram”. It contains a single process, but it
plays a very important role in studying the current system. The context diagram defines the
system that will be studied in the sense that it determines the boundaries. Anything that is not
inside the process identified in the context diagram will not be part of the system study. It
represents the entire software element as a single bubble with input and output data indicated
by incoming and outgoing arrows respectively.




TYPES OF DATA FLOW DIAGRAMS:

Data Flow Diagrams are of two types as follows:

                        (a) Physical DFD
                        (b) Logical DFD


   1. PHYSICAL DFD:

         Structured analysis states that the current system should be first understand correctly.
   The physical DFD is the model of the current system and is used to ensure that the current
   system has been clearly understood. Physical DFDs shows actual devices, departments,
   and people etc., involved in the current system




    23
HCL                                                                              hrms

   2. LOGICAL DFD:

         Logical DFDs are the model of the proposed system. They clearly should show the
   requirements on which the new system should be built. Later during design activity this is
   taken as the basis for drawing the system’s structure charts.



BASIC NOTATION:

The Basic Notation used to create a DFD’s are as follows:

DATAFLOW:

Data move in a specific direction from an origin to a destination.




PROCESS

People, procedures, or devices that use or produce (Transform) Data.            The physical
component is not identified.




SOURCE:

External sources or destination of data, which may be People, programs, organizations or
other entities.




DATA STORE:

Here data are stored or referenced by a process in the System




    24
HCL                                                                                 hrms

DESIGN:

Design is the first step in moving from problem domain to the solution domain. Design is
essentially the bridge between requirements specification and the final solution.




The goal of design process is to produce a model or representation of a system, which can be
used later to build that system. The produced model is called the ―Design of the System‖. It
is a plan for a solution for the system.




    25
HCL                                                                         hrms

                          4.3 DATABASE DESIGN


TABLES
 1. EMPLOYEE

 create table employee(emp_id varchar(10) primary key,emp_name varchar(15),emp_add
 varchar(20),date_of_join datetime,experience int,mobno int,qualification varchar(10))

 2. DEPARTMENT

 create table department(dept_id varchar(10)primary key,dept_name
 varchar(20),dept_location varchar(15))

 3. TEST

 create table test(test_id varchar(15) primary key,test_name varchar(15),test_date
 datetime,test_duration int,max_marks int,min_marks int,conducted_by varchar(15))

 4. CANDIDATE

 create table candidate (cand_id varchar(15) primary key,cand_name
 varchar(15),cand_add varchar(15),ph_no int,emailid varchar(15),experince int,industry
 varchar(15),resume varchar(100),dob datetime,qualification varchar(10))

 5. JOB

 create table job(job_id varchar(10) primary key,job_name varchar(25))

 6. GRADE

 create table grade(grade_id varchar(10) primary key,grade_name varchar(10))

 7. BENEFIT

 create table benefit(benefit_id varchar(10) primary key, benefit_name
 varchar(10),ben_effective_form datetime,ben_effective_end datetime, ben_amt
 smallmoney,ben_status varchar(5))




  26
HCL                                                                               hrms



                              4.4. VALIDATION



The validation criteria are the most important section of the system requirement specification.
The validation completion Demands the through understanding of the software requirement.

Some of the major validation putted in this system is: -

Form: Employee

1. *Name, id ,add, date of join and qualification is mandatory!
2. .*Invalid Mobile No.(10 digits)!



Form: Candidate

1.   *Invalid Mobile No.(10 digits)!
2.   * All fields are mandatory.
3.   *Invalid email id(@,. Is must)


Form: Job

1.*All fields are mandatory

Form: Test

1.*All fields are mandatory

Form: Department

1.*All fields are mandatory




     27
HCL                                                                              hrms



                               5. FORM DESIGN



FORM NAME:- MAIN




      FORM DETAILS:

      This is the main form of HUMAN RESOURCE MANAGEMENT SYSTEM which
      consists all the modules of this and displays modules named as-Employee,
      Department, Test, Candidate, Job, Grade, Benefit and Crystal Reports of all the
      modules.



  28
HCL                                                                            hrms




      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      This form deals with Employee’s personal information.In this form we insert
      Employee’s details like Name, Mobile no, Date of join, Experience, Qualification
      and their full address is stored into database by this form.




 29
HCL                                                                           hrms




  FORM NAME:-EMPLOYEE




      FORM DETAILS:

       This form is used to insert personal information of Employee as discussed above but
       this snapshot shows the validation on phone number i.e., “ENTER CORRECT
       PHONE NUMBER”.




 30
HCL                                                                       hrms




      FORM NAME:-EMPLOYEE




      FORM DETAILS:

       The form deals with searching of information of Employee status.




 31
HCL                                                                           hrms




      FORM NAME:-EMPLOYEE




      FORM DETAILS:

       The form shows the validation while searching the Employee information when no
       value(i.e., employee id) is input by the user in the input box i.e., ―YOU HAVE
       NOT ENTERED ANY ID‖.




 32
HCL                                                                         hrms




      FORM NAME:-EMPLOYEE




      FORM DETAILS:

       The form shows the validation while searching the Employee information when user
       enter incorrect value in the input box ( i.e., ―YOU HAVE ENTERED WRONG
       ID‖).




 33
HCL                                                                           hrms




      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      The form shows the operation of Delete button when the user input the employee id in
      the input box.




 34
HCL                                                                            hrms

      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      The form shows the validation of Delete button when no value(i.e., employee id) is
      input by the user in the input box.




 35
HCL                                                                             hrms

      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      The form shows the validation of Delete button when user input incorrect value(i.e.,
      employee id) in the input box.




 36
HCL                                                                             hrms

      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      The form deals with updation of employee information by entering all the values of the
      fields i.e., Employee name, address, date of join, experience, mobile number and
      qualification provided by the user.




 37
HCL                                                                           hrms

      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      The form shows the validation of Update button when no value(i.e., employee id) is
      input by the user in the input box.




 38
HCL                                                                            hrms

      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      The form shows the validation of Update button when user input incorrect value(i.e.,
      employee id) in the input box.




 39
HCL                                                                              hrms

      FORM NAME:-EMPLOYEE




      FORM DETAILS:

      The form contains navigate button which perform navigation of data from the database
      and it binds the four buttons i.e.,

      1.First: Display the first record from the database.

      2.Next: Display the next record from the database.

      3.Previous: Displays previous record of the current data displayed from the database.

      4.Last: Display the last record of the database.




 40
HCL                                                                               hrms



                        6. BIBLIOGRAPHY



Last Name       First Name            Book Name                     Edition
Publication

Awad            Elias M.           ―System Analysis & Design‖        2nd (2002)     Galgotia

Cornell         Garry              ―visual Basic 6.o‖                3rd (2003)     Personnel

Pressman        Roger              ―Software      Engineering     A 5th (2001)      TMH
                                   Practitioner’s Approach‖




Website Visited: For gathering the data related to the project.



www.microsoft.com


www.google.com




    41
HCL                                                                                    hrms

                                  7. APPENDIX
             Keyword used in this project
Textbox


A text Box control, sometimes called an edit field or edit control, displays information entered
at design time, entered by the user, or assigned to the control in code at run time.


Button


Use a Command Button control to begin, interrupt, or end a process. When chosen, a
Command Button appears pushed in and so is sometimes called a push button.


List Box


A List Box control displays a list of items from which the user can select one or more. If the
number of items exceeds the number that can be displayed, a scroll bar is automatically added
to the List Box control.


Label


A Label control is a graphical control you can use to display text that a user can’t change
directly.


Combo Box


A Combo Box control combines the features of a text box and a list box. This control allows
the user to select an item either by typing text into the combo box, or by selecting it from the
list.


Option Button


An Option Button control displays an option that can be turned on or off.




        42

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2954
posted:7/2/2011
language:English
pages:42