How do I create a template for monthly payroll?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm fairly new to Access, so i really only know the basic operations, but my
boss has left me with the task of somehow creating a database for monthly
payroll for the company. He wants me to just create a template that we can
use over and over agian and just fill in the values for each new month,
rather than having to create a new table/query/form for each month. I have
absolutely NO idea where to even begin, so any help would be greatly
appreciated.
Thanks!
 
Why would you create a new table every month? You can include DATES in your
records

You should create a DATABASE, not a TEMPLATE. The records will have dates,
so you can specify what data to pull to reports, queries, and forms. Using
a TEMPLATE, you'd have to create new employee records every time you created
a database.

This will allow you to pull historical data as well as current data.


As far as how to build it, there are hundreds of variables we'd need to know
to help you there. Obviously you will need an employee table including the
employee number, name, social, rate and type of pay, etc.

If you plan to retain salary changes, this would need to be a separate
table.

Tables to store tax rates and entities would be needed.

A detail table for check history would be needed.

This is a VERY complex and VERY sensitive request. I'd never even TRY to
build a payroll database in Access. It is not secure, involves very complex
computations, and you can buy a commercial product like QuickBooks for a few
hundred dollars. Doing this in Access would take you hundreds of hours to
get it exactly right and may result in horrible consequences if you
miscalculate an item.

I'd go to Office Max and spend $299 for an off-the-shelf product.
 
sarah, i have to agree with Rick. payroll is a very complex task even for an
experienced and highly skilled developer. and i'm afraid that when you say
you "know the basic operations" in Access, you're referring to the mechanics
of using the software. however, that is only one part of the equation in
building an Access database; the first, hardest, and most essential step is
learning and then applying the principles of relational data modeling to
correctly design your tables and relationships. most people need repeated
practice, moving from easy to harder, to master these principles; modeling
payroll data is definitely not the place to start.

i strongly urge you to follow Rick's advice and recommend that your boss
invest in a proven commercial payroll software product.

hth
 
Take a look at something like quickbooks!!

I agree, with Tina and Rick, payroll can quickly become complex.
starting with the basic -- do people have to record their 'start and
stop time' or do you handle the time 'by exception', do you have to account
for sick leave, annual leave, travel, away without pay, part-time, etc, etc,

That said.
I've been working on a 'small' office's payroll for the past five
years and it is constantly in a state of change -- that's good, now could
you make it do ....!

However, if we have not scared the be-j--- out of you;
you will need the following
a table to hold stuff about the employees (firstname, lastname,
IdNumber, address)
a table to hold stuff about paylevels (jobs) (jobId, department, pay
scale (hours, salary, monthly, semi-monthly, whatever)
a table to hold stuff about an 'employment episode' (employmentID,
PersonID, date hired, date dismissed, etc)
a table to hold stuff about a 'payrecord' (personID, employmentID,
JobID, datestart, dateend)
----depending on your employment setting several more tables will be
required.
After you have all the tables built, and their relationships correct, you
will 'almost be ready to start' building queries, forms, reports, etc.

Lot's of luck

Ed Warren.
 
Back
Top