By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,846 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,846 IT Pros & Developers. It's quick & easy.

Data entry, storage and processing - MS Access okay?

P: n/a

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!


May 10 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.