LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 125
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Database JeremyH1982 Excel Discussion (Misc queries) 8 July 19th 06 01:16 PM
data entry in excel by linking to other word doc. or excel sheets wangxuqin Excel Worksheet Functions 1 April 14th 06 12:33 PM
common entry reporting Jeff Excel Worksheet Functions 1 March 1st 06 02:30 PM
Excel as a reporting tool [email protected] Excel Discussion (Misc queries) 2 May 12th 05 04:30 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"