MS Access - Such a simple question

[kimmiea]

But is seems no one at Microsoft can answer me.

I simply need to know if Access will do what we need it to before we spend a fortune on training.

I work for a construction company and we track all our job material on a spreadsheet, in the workbook there is a database and then several sheets that have queries to the database page.

Would we be better off setting up a central database in Access and keep the excel spreadsheet for the queries??? or setting up reports in Access. We can have anywhere from 50-70 projects on the go at the same time and need to be able to track for each project. Note - several users access these spreadsheets with varied levels of knowledge, I would like to keep them as simple and locked down as possible.

It's very hard to explain all this without being able to show a visual but any feedback would be greatly appreciated.

Thank you so much for your time.

Kim

 

[mintjulep]

So your question is?

 

[gbaughma]

I would look into some sort of project management software instead, or perhaps a web-based solution using either Access or SQL as a back end.



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[kimmiea]

Thanks for your help