Ask Experts Questions for FREE Help !
Ask

How to make payroll in access?

Asked Jan 20, 2012, 11:41 PM — 1 Answer
How to make payroll in access?

1 Answer
ScottGem's Avatar
ScottGem Posts: 58,586, Reputation: 28380
Computer Expert and Renaissance Man
 
#2

Jan 21, 2012, 05:36 AM


Why recreate the wheel? There are a number of good payroll apps out there that are not very expensive. Some banks include a payroll service for business banking customers.

If you really want to do it in Access, you will need several tables. An employee table for info about each employee, a payroll table for info about each paycheck (employee, pay date, pay period, etc.) and a items table which records all the amounts (mostly deductions) that are included in the paycheck. In addition, you will need look up tables for deductions and rate tables for withholding rates.

Once you have your table structure, you will need to create forms to generate each paycheck. Much of the paycheck can be automated, but, especially if you are dealing with hourly, non-exempt employees, you will have to enter hours worked to calculate pay for the period.

Your question is really too broad for a definitive answer so this is just a broad overview to get you started.
Helpful

Not your question? Ask your question View similar questions

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting

Undo
Redo
 
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

How to create payroll system in microsoft access [ 1 Answers ]

I have created a payroll system using Microsoft access 2003. I just want to ask on how do I automatically compute the SSS contribution, withholding tax automatically when I select the field ?SSS used bracket to know the contribution same thing with withholding tax.

Access is denied. Make Sure the disk is etc. [ 0 Answers ]

Put a cd-rw disk in my CD-Rom drive which is a read/write drive and I can't write to it. I get the following message: I have a DELL Dimension. It is thre years old... Access is denied: Make sure the disk is not full or write protected. That's it.. Can any help me. Thank you.


View more Access questions Search