Excel or Access?

[Glenn]

I'm not sure which program to use to do what I'm needing to do.

I have a list of employees that includes employee number, name, unused sick
days, unused vacation days, etc.

I would like to keep track of their attendance in either excel or access and
then at the end of the year do a couple of things:

1) Update their sick time to include the days they are granted for the year
ahead,

and also

Give them a printout that tells how many days they had at the beginning of
the year, how many they used, how many they are being granted for the
following year, and the resulting number of days now available (unused
personal days carry forward as sick days)

The printout also needs to include information on the days they used. So,
for example the printout would look like this:

Name: John Doe
Starting Sick Days Sick Days Used Sick Days Granted for Next Year
Sick Days Available Starting Personal Days Personal Days Used
Personal Days Granted for Next Year Personal Days Available
70 2 15
84 2
1 2
2

Days Used:

March 15, 2004 Sick Day
June 5, 2004 Personal Day
August 7, 2004 Sick Day (Family)

I'm thinking Access might be the way to go with this, due to the update
table features, when it comes to doing the calculations for the following
year.

Any thoughts?

 

[Mike Labosh]

Access.

In my opinion, anything done in Excel can be done better in Access, it just
takes longer to develop it, but it is safer for the data. And Access's
reporting feature is REALLY good. And yes, you DO want that update table
feature. The graphical query designer in access makes it really easy to
process whole sets of records in a batch.

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!