Create Ms Access Database software to prepare salary in your company
Create Ms Access Database software to prepare salary in your company
I created a small database program to create monthly salaries and print salary slips easily.
This way you can keep monthly salary records given pay sheets calculate Overtime only filling main basic data.
no need to install special software, no need special skill.



My Blog

Step 1: Create Main Basic Table

Create Ms Access Database software to prepare salary in your company
Open Ms Access.

go to main menu & create table as you want

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

Step 2: Create Query for Basic main table

Create Ms Access Database software to prepare salary in your company
Create a Query for basic main data table. as below




Step 3: Create Pay sheet details

Create Ms Access Database software to prepare salary in your company
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 Ms Access Database software to prepare salary in your company
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

Create Ms Access Database software to prepare salary in your company
Create Ms Access Database software to prepare salary in your company
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

Create Ms Access Database software to prepare salary in your company
Now you are already finish your program.
enter staff details .

you can download my file how i crate here with this location and enjoy.

Download this Software free


 
 

Tag cloud

make build easy simple arduino making homemade solar laser printed portable cheap mini building custom cardboard wooden create super lego turn paracord chocolate your paper light intel