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. It won't be a steady stream/connection. I'll have to pull it by weekly and insure that data gets updated.
My questions: I know that MS Project can give me the calculations and reports, but I don't know if it can pull the data. So, can I do what MS Report does with Access? Or is there a way to pull the data with Access and then update the data in MS Project from Access?
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. It won't be a steady stream/connection. I'll have to pull it by weekly and insure that data gets updated.
My questions: I know that MS Project can give me the calculations and reports, but I don't know if it can pull the data. So, can I do what MS Report does with Access? Or is there a way to pull the data with Access and then update the data in MS Project from Access?