A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Payroll -- Is it even possible?!



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2009, 07:34 PM posted to microsoft.public.access.gettingstarted
REJesser
external usenet poster
 
Posts: 20
Default 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


  #2  
Old May 26th, 2009, 07:49 PM posted to microsoft.public.access.gettingstarted
Steve[_70_]
external usenet poster
 
Posts: 152
Default Payroll -- Is it even possible?!

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




  #3  
Old May 26th, 2009, 07:56 PM posted to microsoft.public.access.gettingstarted
John... Visio MVP
external usenet poster
 
Posts: 900
Default 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  
Old May 26th, 2009, 08:35 PM posted to microsoft.public.access.gettingstarted
BruceM[_4_]
external usenet poster
 
Posts: 558
Default 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  
Old May 26th, 2009, 09:15 PM posted to microsoft.public.access.gettingstarted
gls858
external usenet poster
 
Posts: 473
Default 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  
Old May 26th, 2009, 09:41 PM posted to microsoft.public.access.gettingstarted
REJesser
external usenet poster
 
Posts: 20
Default 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  
Old May 26th, 2009, 09:47 PM posted to microsoft.public.access.gettingstarted
Steve[_70_]
external usenet poster
 
Posts: 152
Default 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  
Old May 26th, 2009, 11:16 PM posted to microsoft.public.access.gettingstarted
Noëlla Gabriël
external usenet poster
 
Posts: 79
Default 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  
Old May 26th, 2009, 11:21 PM posted to microsoft.public.access.gettingstarted
John... Visio MVP
external usenet poster
 
Posts: 900
Default 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  
Old May 27th, 2009, 02:38 AM posted to microsoft.public.access.gettingstarted
tina
external usenet poster
 
Posts: 1,997
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.