Payroll -- Is it even possible?!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


.

Quantcast