Access is a database. If you want to store records it is the way to go.
Each day (or possibly each punch) can be stored as a separate record. You
can allow users to go in and enter a new record, but maybe lock them out
from changing old records. In Excel it would be easy for them to monkey
with previous lines of data, change the structure of the spreadsheet, mess
up figures or calculations (by mistake ort on purpose.) etc.
In Access you can build reports to produce only the data you want. For
example, you could click a button and have it print a timesheet for the user
signed on for the current week without them having to specify a print range
or do anything special.
You would be able to analyze the data, compare one user to another, compare
one week to another, etc. You could easily color or bold days where hours
were less than a certain requirement. You could do similar flags for people
starting work late, taking long breaks, long lunches, etc.
It just depends on what you want to do. Excel and Access are two very
different programs. There are tasks that you would almost always do in
Excel, and there are tasks that you would almost always do in Access. If I
were trying to let a group of users enter timesheet data, I would do it in
Access. I almost never do anything in Excel that will be shared by multiple
people. It's too easy for them to mess it up. When I need a spreadsheet, I
use Excel. When I need to enter data daily or weekly, store it, report on
it, edit it, evaluate it, etc, then I use a database.
--
Rick B
Anand Vaidya said:
Rick , how is it(Access) better when it comes to data entry and storing.We
can enter and store the data in Excel as well.right?I want to know - how
would an application done on Excel would be more flexible and more useful
if
done in Access?like something which can't be done/done hardly in Excel and
can be done/done easily in Access. Rick,if you could elaborate/explain
your
statement ,I would be happy.
