Payroll and Staff Attendance Database Using MS Access

Introduction: Payroll and Staff Attendance Database Using MS Access

About: I'm a Sri Lankan and like to communicate with others in the world with my knowledge. I'm employing as an Accountant and very familiar to create and develop Ms access software. my hobby is create crafts using …

I'll give you the brief instruction to create a Payroll system using MS access for any business to manage HRM.

This way you can generate each month payroll details records and can edit or review later.

You can print pay sheets, pay slips for individual employers.

no need to install special software, no need special skill. but you need Ms access in your computer.

Now i have created very user friendly Ms access program to manage total HRM for any business.

you can view and download this software form my website here


Step 1: Create Main Basic Table

Open Ms Access.

go to main menu & create table as mention with picture..

Add following details or your details what you pay to your staff monthly.

Step 2: Create Query for Basic Main Table

Create a Query for basic main data table.



Step 3: Create Pay Sheet Details

Create a report base on monthly transaction for pay sheet.

insert formula for auto calculate OT / No pay/ and net salary

follow the image below

Step 4: Create a Salary Slip

Create a salary Slip how you want to give to your staff as below.

each and every details what you want to show in your staff salary slip..

Step 5: Create a Form to Enter Data

Now create a form to enter data to your program.

base on your table crate a form to enter data very easily.

Step 6: Enter Staff Details

Now you are already finish your program.

enter staff details .


I have Created Attendance and Payroll software to give to world .. New Version, User Friendly, Unlimited Employees Visit to my site and check the more details.

Visit

Watch how it work...

2 People Made This Project!

Recommendations

  • Crafts For Kids Challenge

    Crafts For Kids Challenge
  • Make it Glow Contest

    Make it Glow Contest
  • Game Design: Student Design Challenge

    Game Design: Student Design Challenge

14 Comments

0
phigsj
phigsj

2 years ago

Your instruction is not clear ???!!!

0
phigsj
phigsj

2 years ago

How can i create the stuff that you are telling in step number 3? Where could i access that paysheet view?? please help

0
mactriger
mactriger

2 years ago on Step 2

What is the formula on quiry sir

0
olivr22
olivr22

Question 2 years ago on Step 6

I paied and downloaded the software but wont run on a 64bit system. Please help!

0
DanJ93
DanJ93

Question 4 years ago on Step 5

how to create the form to enter data

0
Miss YK
Miss YK

5 years ago

how to download this software

0
FogsoftC
FogsoftC

5 years ago

Software development company: http://fogsoft.com/custom_software_development.aspx

0
Ali RazaM2
Ali RazaM2

7 years ago

How can I edit Heading Your Company Name

0
mina samy
mina samy

8 years ago on Introduction

hey .. how did you make the software open in separate windows without any aid from microsoft access ?? if I want to edit your project to write another data titels with the same design .. Can I ?? and if I can what should I do to edit ??

0
tle27
tle27

9 years ago on Step 6

How do you lock your database program so that noone can edit your code, tables, query, reports, form etc...??