Introduction: Payroll and Staff Attendance Database Using MS Access
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.
2 People Made This Project!
- amrit subedi made it!
- yavwa.chiwaya made it!
14 Comments
2 years ago
Your instruction is not clear ???!!!
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
2 years ago on Step 2
What is the formula on quiry sir
Question 2 years ago on Step 6
I paied and downloaded the software but wont run on a 64bit system. Please help!
Question 4 years ago on Step 5
how to create the form to enter data
5 years ago
how to download this software
5 years ago
Software development company: http://fogsoft.com/custom_software_development.aspx
7 years ago
How can I edit Heading Your Company Name
7 years ago on Introduction
Get Access File Recovery Tool Software. That can repair mdb file and recover access database objects like, Tables, Queries, forms and reports etc.
Reference link : http://www.recoverydeletedfiles.com/access-file-recovery-tool.html
8 years ago on Introduction
You can recover lost/damage Access database with repair access tool
http://www.repairaccess.org/
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 ??
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...??
9 years ago on Introduction
Work with ms access databases with the help of repair ms access database
http://www.repairaccess.accessrepairtoolbox.com
9 years ago on Introduction
Open, read, view with the aid of how to repair access 2003
Software you can find at http://www.oemailrecovery.com/access_repair.html