Excel or Access for Data Entry and Reporting Application
I need to put together as simple an application as possible to do the
following and need to know if Excel or Access should be used.
I have 3 groups in an organization who need to feed data (i.e. number of
pages printed per day) into either a worksheet or database. Each group
should have their own set of data and it's preferable to enter the data via a
form. The manager of the 3 groups needs to be able to access each of the
sets of data to review and generate reports - they'd prefer to generate them
in Excel because they are more comfortable using it than Access. Reports are
run on a daily, weekly and monthly basis. The data needs to be shared and a
harddrive on a LAN is already available. If only one person were to be
responsible for dataentry and reporting, I'd suggest setting up one workbook
with multiple worksheets. Is this still feasible in a shared setting with
multiple user access? I want to keep the solution as simple and fool proof as
possible (limited or no data loss and system crashing). All suggestions are
welcome!
|