Introduction: Create Ms Access Database Software to Prepare Salary in Your Company

Picture of Create Ms Access Database Software to Prepare Salary in Your Company

I'll give you the brief instruction to create a Payroll system using MS access for generate monthly salaries and print salary slips easily with this .


This way you can keep each month salary details records under database and can edit or review later. You can print pay sheets for individual employers and salary details also.
no need to install special software, no need special skill. but you need Ms access in your computer.

Step 1: Create Main Basic Table

Picture of 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

Picture of Create Query for Basic Main Table

Create a Query for basic main data table.



Step 3: Create Pay Sheet Details

Picture of 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

Picture of 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

Picture of 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

Picture of Enter Staff Details

Now you are already finish your program.
enter staff details .

I already created MS access salary software to give to world free .. it can configure your company details and user friend.

You can download with my blog here..
Download this Software free

Comments

Miss YK (author)2017-10-07

how to download this software

amrit subedi made it! (author)2017-08-08

how to make

FogsoftC (author)2017-02-20

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

Ali RazaM2 (author)2016-01-19

How can I edit Heading Your Company Name

danalott (author)2015-05-28

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

yavwa.chiwaya made it! (author)2014-11-05

How do you unlock your database program

JohnP4 (author)2014-07-29

You can recover lost/damage Access database with repair access tool

http://www.repairaccess.org/

mina samy (author)2014-07-22

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 ??

tle27 (author)2013-08-31

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

jackolsen (author)2013-07-30

Work with ms access databases with the help of repair ms access database

http://www.repairaccess.accessrepairtoolbox.com

jeffreyoksen (author)2013-04-19

Open, read, view with the aid of how to repair access 2003

Software you can find at http://www.oemailrecovery.com/access_repair.html

About This Instructable

156,029views

24favorites

Bio: I'm Sri Lankan and like to learn new things and communicate with others in the world. I'm employing as an Accountant in Maldives ... More »
More by WYGWORLD:INVOICING BILLING AND INVENTORY CONTROL SYSTEMDesign a form filling database using Microsoft access.Flower Vars from newspaper tube
Add instructable to: