Payroll -- Is it even possible?!

[REJesser]

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

 

[John... Visio MVP]

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
(e-mail address removed)

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)

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

 

[John... Visio MVP]

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
(e-mail address removed)

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)

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

 

[BruceM]

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.

 

[BruceM]

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.

 

[gls858]

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

 

[gls858]

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

 

[REJesser]

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

 

[REJesser]

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

 

[John... Visio MVP]

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
(e-mail address removed)

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)

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

 

[John... Visio MVP]

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
(e-mail address removed)

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)

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

 

[tina]

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

 

[tina]

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

 

[Noëlla Gabriël]

Hi Jesser,

the general rule here: be very carefull with people that insist to help you,
for a price, on a forum which provides free help. The more if they promise a
simple, no hassle, easy to use application without having looked at the
complete problem.

 

[Noëlla Gabriël]

Hi Jesser,

the general rule here: be very carefull with people that insist to help you,
for a price, on a forum which provides free help. The more if they promise a
simple, no hassle, easy to use application without having looked at the
complete problem.

 

[Brendan Reynolds]

Good afternoon,

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

<snip>

I used to be responsible for maintaining and enhancing an Access payroll
system. Although it is possible, I would strongly advise against it. You can
get good, off-the-shelf, professional payroll apps, developed by experts in
the field, for a fraction of what it would cost to do it yourself (if you
place any kind of realistic value on your time). I just did a quick Google
search, and I see that Sage are selling QuickPay here in Ireland for 159
euro, and Thesaurus Software sell PayrollManager for 140 euro. Under those
circumstances, it just doesn't make any sense to 'roll your own'.

 

[Brendan Reynolds]

Good afternoon,

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

<snip>

I used to be responsible for maintaining and enhancing an Access payroll
system. Although it is possible, I would strongly advise against it. You can
get good, off-the-shelf, professional payroll apps, developed by experts in
the field, for a fraction of what it would cost to do it yourself (if you
place any kind of realistic value on your time). I just did a quick Google
search, and I see that Sage are selling QuickPay here in Ireland for 159
euro, and Thesaurus Software sell PayrollManager for 140 euro. Under those
circumstances, it just doesn't make any sense to 'roll your own'.

 

[Noëlla Gabriël]

Hi,

the problem we had with our boating (seafaring co) was in fact that no
commercial package really covered our needs. Naval laws and situations are
very special, like being on see working 3 months without 1 day of leave
(including Sundays and holidays), and then coming home and having a vacation
of some months. Believe us, we made a thorough study of existing packages
before deciding on writing our own.

 

[Noëlla Gabriël]

Hi,

the problem we had with our boating (seafaring co) was in fact that no
commercial package really covered our needs. Naval laws and situations are
very special, like being on see working 3 months without 1 day of leave
(including Sundays and holidays), and then coming home and having a vacation
of some months. Believe us, we made a thorough study of existing packages
before deciding on writing our own.

 

[Keith Wilby]

Contact me, you have nothing to lose.

.... except money, time, the hair the OP will tear out ...

How about another page on your web site called "Decorum and Respect". You
could have "coming soon" on it for the rest of your life on the basis of the
ineptness you demonstrate on here.