If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Payroll -- Is it even possible?!
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 Sheet 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 |
#3
|
|||
|
|||
Payroll -- Is it even possible?! - Little stevie is at it again!!
"Steve" wrote in message
... Hello Ron, I provide help with Access applications for a very modest fee. I would like to offer to put this database together for you for a very nominal fee. If you want my help, contact me. Steve These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. A few gems gleaned from the Word New User newsgroup over the Christmas holidays to show Stevie's "expertise" in Word. Dec 17, 2008 7:47 pm Word 2007 .......... In older versions of Word you could highlght some text then go to Format - Change Case and change the case of the hoghloghted text. Is this still available in Word 2007? Where? Thanks! Steve Dec 22, 2008 8:22 pm I am designing a series of paystubs for a client. I start in landscape and draw a table then add columns and rows to setup labels and their corresponding value. This all works fine. After a landscape version is completed, I next need to design a portrait version. Rather than strating from scratch, I'd like to be able to cut and paste from the landscape version and design the portrait version. Steve Dec 24, 2008, 1:12 PM How do you protect the document for filling in forms? Steve One of my favourites: Dec 30, 2008 8:07 PM - a reply to stevie (The original poster asked how to sort a list and stevie offered to create the OP an Access database) Steve wrote: Yes, you are right but a database is the correct tool to use not a spreadsheet. Not at all. If it's just a simple list then a spreadsheet is perfectly adequate... John... Visio MVP |
#4
|
|||
|
|||
Payroll -- Is it even possible?!
Steve, Steve! You were doing rather well for a while, but then you tried to
slip in a solicitation for paid work. You should know you will be called out every time you try that trick. To the OP, visit www.pcdatasheet.com for more of an idea about Steve's capabilities. Be sure to check out the Excel/Access tips. Oh wait, they're "coming soon". That notice has only been there for a few years, so any day now they should be ready. "Steve" wrote in message ... Hello Ron, I provide help with Access applications for a very modest fee. I would like to offer to put this database together for you for a very nominal fee. If you want my help, contact me. Steve "REJesser" wrote in message news 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 Sheet 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 |
#5
|
|||
|
|||
Payroll -- Is it even possible?!
REJesser wrote:
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 Sheet 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 Depending on your skills and desire, you may be better to buy an off the shelf solution. Take a look at Quickbooks(there are others). It may sound a little pricey but if you consider all of the extra stuff you get and the time your going to invest, my guess is you would be money ahead. gls858 |
#6
|
|||
|
|||
Payroll -- Is it even possible?! - Little stevie is at it agai
Thank you for the advice John.
Going back to my original database question, if it is possible, how can I create the desired table? I would like to be able to enter the information in a view similar to my Excel Time Sheet. The columns across the spreadsheet are labeled: Employee Name / Employee Number / Day of Month (1-15 or 16 – End of Month) / Rate of Pay / Extra Pay Thanks again |
#7
|
|||
|
|||
Payroll -- Is it even possible?!
gls858 is right. If you go to the do-it-yourself route, expect to invest a
lot of time. The Quickbooks suggestion is way too much overkill for what you need. You also won't be able to do the kind of searches you want. I can build you a simple, no hassle, easy to use database that will do all you want for a modest fee. Steve "gls858" wrote in message ... REJesser wrote: 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 Sheet 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 Depending on your skills and desire, you may be better to buy an off the shelf solution. Take a look at Quickbooks(there are others). It may sound a little pricey but if you consider all of the extra stuff you get and the time your going to invest, my guess is you would be money ahead. gls858 |
#8
|
|||
|
|||
Payroll -- Is it even possible?!
Hi,
it's certainly possible to do it. I worked on a similar project some years ago. That boating co (towboats and sea rescue operations) couldn't use a ready made package because the social laws are to different in this world. So we build a custom app. The magic world here is "we". A team of 4 worked for more then a year on this project (Access on SQL server). The problem is you need people who know the social laws ect. very well, together with people who know the marine world well and programmers very closely together. You're handling payroll info, which is very important and touchy info for people. You can't make mistakes there. For instance: how do you handle payed holidays they work, or sick days? A lot of rules with a lot of exceptions there, but sure it can be done, after all, we did it... -- Kind regards Noëlla "REJesser" wrote: 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) ........... Thank you very much for any assistance you can provide Ron |
#9
|
|||
|
|||
Payroll -- Is it even possible?!
"Steve" wrote in message
m... gls858 is right. If you go to the do-it-yourself route, expect to invest a lot of time. The Quickbooks suggestion is way too much overkill for what you need. You also won't be able to do the kind of searches you want. I can build you a simple, no hassle, easy to use database that will do all you want for a modest fee. Steve Still trying to pimp your services? These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. A few gems gleaned from the Word New User newsgroup over the Christmas holidays to show Stevie's "expertise" in Word. Dec 17, 2008 7:47 pm Word 2007 .......... In older versions of Word you could highlght some text then go to Format - Change Case and change the case of the hoghloghted text. Is this still available in Word 2007? Where? Thanks! Steve Dec 22, 2008 8:22 pm I am designing a series of paystubs for a client. I start in landscape and draw a table then add columns and rows to setup labels and their corresponding value. This all works fine. After a landscape version is completed, I next need to design a portrait version. Rather than strating from scratch, I'd like to be able to cut and paste from the landscape version and design the portrait version. Steve Dec 24, 2008, 1:12 PM How do you protect the document for filling in forms? Steve One of my favourites: Dec 30, 2008 8:07 PM - a reply to stevie (The original poster asked how to sort a list and stevie offered to create the OP an Access database) Steve wrote: Yes, you are right but a database is the correct tool to use not a spreadsheet. Not at all. If it's just a simple list then a spreadsheet is perfectly adequate... John... Visio MVP |
#10
|
|||
|
|||
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" wrote in message news 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 Sheet 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 |
Thread Tools | |
Display Modes | |
|
|