PAYROLL SYSTEM

PAYROLL SYSTEM

PAYROLL SYSTEM

AIM:

To develop the payroll system by using visual basic as front end and MS-access as back end.

PROGRAM ANALYSIS AND PROJECT PLANNING

PURPOSE:

The purpose of the program analysis and project planning is to fully describe the functionality of payroll system identified and it also describe non-functional requirements and design control and other factors.

PROJECT SCOPE:

The program analysis and project planning applies to the payroll system.Initially the project is going to be implement interact level and later the organization has an idea to upgrade in internet level the project merit include this project might suppresses the complication in calculating payroll for human resources in large organization.

OBJECTIVES:

§ Easy to use

§ More robust

§ To reduce the manual operation in calculating the payroll

HARDWARE REQUIREMENTS:

1)Intel Motherboard with Pentium Processor

2)RAM 256MB(minimum)

3)Hard disk 40GB(minimum)

SOFTWARE REQUIREMENTS:

1)Microsoft VisualBasic6.0

2)Microsoft Access

3) Rational Rose

SOFTWARE REQUIRMENT ANALYSIS:

The following sub sections describe the usage of the payroll system.There are three modules.

Ø Use entry

Ø Verification of password

Ø Employee salary calculation

INTENDED AUDIENCE:

· Employee

· Administrator

PRODUCT FUNCTIONS:

Here short briefing on payroll system.It has the following four modules.The modules are:-

1. USER ENTRY:

The user has to provide the user name and the pin number.The pin is the four digit number which is also called a secret key known to the user.

2.VERIFICATION OF PASSWORD:

The password is matched with one already present in the data base is the password is scanned.If the password is correct the user is logged in else the false message is generated.

3. EMPLOYEE SALARY CALCULATION:

In the database, name of the each employee will be stored with all needed informations.Depending upon that information the salary will be calculated for employee.

PAYROLL SYSTEM

USECASE DIAGRAM:

CLASS DIAGRAM:

SEQUENCE DIAGRAM:

COLLABORATION DIAGRAM:

VB SOURCE CODE

Login Form : (Form1.frm)

Private Sub Command1_Click()

If (Text1.Text = "admin" And Text2.Text = "sec") Then

Form2.Show

Else

MsgBox "Please enter the correct username and pwd"

End If

End Sub

Private Sub Command2_Click()

Text1.Text = ""

Text2.Text = ""

End Sub

Choice Form : (Form2.frm)

Private Sub Command1_Click()

Form3.Show

Unload Me

End Sub

Private Sub Command2_Click()

Form3.Visible = False

End Sub

Payslip : (Form3.frm)

Private Sub Command1_Click()

Data1.Recordset.MoveFirst

For i = 0 To Data1.Recordset.RecordCount - 1

If Text1.Text = Data1.Recordset.Fields(5) Then

Frame1.Visible = True

Text2.Text = Data1.Recordset.Fields(0)

Text3.Text = Data1.Recordset.Fields(1)

Text4.Text = Data1.Recordset.Fields(2)

Text5.Text = Data1.Recordset.Fields(3)

Text6.Text = Data1.Recordset.Fields(4)

Text8.Text = Data1.Recordset.Fields(5)

Text9.Text = Data1.Recordset.Fields(6)

Text10.Text = Data1.Recordset.Fields(7)

Text11.Text = Data1.Recordset.Fields(8)

Text12.Text = Data1.Recordset.Fields(9)

End If

Data1.Recordset.MoveNext

Next

End Sub

Private Sub Command2_Click()

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Text6.Text = ""

Text7.Text = ""

Text8.Text = ""

Text9.Text = ""

Text10.Text = ""

Text11.Text = ""

Text12.Text = ""

End Sub

Private Sub Command3_Click()

Text7.Text = ((Val(Text4.Text) + Val(Text5.Text) + Val(Text6.Text)) - (Val(Text10.Text) + Val(Text11.Text) + Val(Text12.Text)))

End Sub

OUTPUT FORM

Login Form : (Form1.frm)

Choice : (Form2.frm)

PaySlip : (Form3.frm)

RESULT:

Thus the Payroll system was developed by using visual basic in front end and MS-Access in back end.