Re: Payroll -- Is it even possible?!

it's not clear what the purpose of the data is, RE. if you're actually
wanting to calculate and track PAYROLL, that's pretty complex - unless
you're paying folks cash under the table, or working in a country that has
no tax of any kind on personal income. living in the USA, i don't think i'd
touch payroll with a ten- (make that fifty-) foot pole, especially since
there are proven solutions available out-of-the-box.

but i'm wondering if you're actually tracking employee hours / labor
expenses. that seems a bit more in line with the information you posted. and
from the description, it's related data that probably would be better
handled in Access than in Excel. but Access isn't Excel on steroids - it's a
completely different concept in storing and manipulating data. if you build
the db right, i imagine you *can* make your data entry / reporting work "a
snap". but building it right definitely will NOT be a snap.

i'm not trying to discourage you, just give you a reality check. if you're
prepared to invest a significant amount of time and energy into learning
relational design principles, and then learning to use the Access tool to
build the application you need, go for it. to get started, see
http://home.att.net/~california.db/tips.html#aTip1.

hth


"REJesser" <REJesser@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D2E63962-A794-423F-8C72-7AD85ACCFD35@xxxxxxxxxxxxxxxx
Good afternoon,

I am attempting to create a Payroll Database. I work for a boating
business. I need the database to contain:

Employee Number (linked to Employee Table)
Employee Name (linked to Employee Table)
Rate of Pay (linked to Rate of Pay Table)
Extra Pay
Boat assigned to (linked to Vessel Information Table)
Date

I have always used Excel to track this information. There are times when
I
need perform the time intensive task of going back up to 5 years and
determine how many days a crewmember was at work, what boat were they on,
and
how many total days they were on each boat. I am hoping a database can
make
this a snap.

The Payroll Database would need to be able to create a report each month
on
the 1st and 16th. The pay periods are from 1-15 and 16 - end of the
month.
I would gladly send someone a copy of the Excel Time *** I use if that
would help visualize this whole deal.

I have the Employee Table, Rate of Pay Table, and Vessel Information Table
already. Now it is just a matter of combining them into something that
alleviates - not causes - headaches.

Thank you very much for any assistance you can provide
Ron




.