[SOLVED] Access 2007 or Excel 2007 Question

**russkris** · 10-20-2009, 10:56 PM

Hello,

Firstly I am not looking for anyone's direct help at this stage, this thread is more to ask some advise.

I have an Excel Workbook at the moment which has been functioning quite well for the past few years.

I have attached a screenshot of most of the sheets and columns

As you will see there is quite a bit of data that gets recorded and a number of different sheets.And a whole range of formulas to keep everyone up to date with what is and has been entered and the last sheet sums up(performance indicators) the entire month

I would like to simplify the excel workbook, maybe move towards just one simple "front page" where users can simply tick and flick a few boxs, enter some data etc, etc, leaning towards a "real" database. I was also hoping to add a search function so if anyone needed data from X date to Y date then they would just put the date range in and bingo... The current way is to manually scroll up the rows etc, etc..

Just wondering if anyone had any ideas or suggestions..

Sorry if this all seems very open and now real questions.. I just need some form of direction from you guys who know more then me.. I havent used Access much before but it would be good to read a few books and leanr something new..

Thanks for taking the time to read

**split_atom18** · 10-21-2009, 07:32 PM

It doesn't really look like your database would be very complex. Which is a great place to start with Access. I would recommend the Access Bible. It is a good book.

Hope this helps,

Dan