View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don[_32_] Don[_32_] is offline
external usenet poster
 
Posts: 3
Default I need help making the next step, please

I hope I'm in the right place. Please direct me else where if the is
a more appropriate forum.

Some background: I work for a hospital and keep departmental work
stats--ie # of patients treated, a database of doctors, patients,
etc. I do this all in Excel. I am self taught and I am pretty good
with it. To be sure, I went and took the MOS test in Excel and passed
the expert level test. Not tooting my own horn, just trying to give
you a feel for my ability.

Everything feels disjointed. I have several different workbooks
going. My goal: consolidate where possible, offer a clean, easy to
use interface so management can "ask questions" of the databases
easily (they are far from computer savy :)

The hospital does not have MS Access on it's machines, so I want to
maximize Excel's capabilities. How do I do that? SQL? OLAP cubes?
Web Page Access? Where do I turn and what hardware/software obstacles
do I face?

I'm more than willing to invest the time/money for research and
learning materials, but I need some real person input about what to
do.

Any suggestions you may have would be very appreciated.

Thank you,
Don