Hi,
Problem statement: We have some amount of data stored in various excel
sheets and we generate a few reports from these data. We are in the
process of consolidating all data to reside in a single repository.
Currently, it is semi-automated i.e. we are using MS Excel for data
entry, consolidation and report generation (i.e. using formulas). We
require a tool that will provide:
a) A web-based interface for data entry (i.e. remote,
location-independent information access/updates)
b) Reports on a monthly basis (Simple dashboard type of reports with
simple data processing rules)
c) Multi-user support (Say 15 - 20 concurrent users)
d) Data backup and recovery support (The data volume is not huge but
the data is sensitive and critical)
Is MS Access a good choice to solve this problem? We are also
considering MS Excel + Sharepoint portal solution. An open source
third-party solution should also be fine.
I would like to know expert comments from this group regarding the
directions we can take to solve this problem. Please help!