My boss has given my 1 day to find out which program to use - Access or MS Project.
Situation: We have a large Oracle based Database for work management which has no project management capabilities.
What needs to be done:**I will need to pull data from the DB and place it in a format that will allow me to do time, cost, productivity, and hrs per person per project type productivity.**It won't be a steady stream/connection.**I'll have to pull it bi weekly and insure that data gets updated.
My questions:
1) I know that MS Project can give me the analysts and reports, but I don't know if it can pull the data from an oracle based db
2) Can I do what MS Project does in Access?**I know about the 3rd party gantt chart software, but can Access float a custom basecalendar with exceptions on each person?
3) Or is there a way to pull the data with Access and then update the data in MS Project from Access?**
Bookmarks