Edmon AgronSystem Coordinator / Document Controller| MBO Architects and Engineering ConsultantJeddah, Saudi Arabia
Microsoft access has been my primary weapon in terms data management and whole nitty gritty of my corporate experience.
I started to use it for inventory management, then to monitor daily time record (DTR) and now I'm using it as primary tool for document control, management and the whole aspects of reporting required which I believe critical in project management.
Does anyone here uses Microsoft Access for project management? I am sure Microsoft Access is one thing you need to consider before attempting to purchase a sky high premium database. I'm not from Microsoft by the way - I just love this tool and I love to hear from people who have used it as well. Saving Changes...
Morne BeeslaarManaging Director| Faolan ConsultingPretoria, South Africa
Access is a great tool for data management but I would not use it for planning and cost control. Unless all users are very informed with the software you either end up doing everything yourself. The reason software is developed is that it sits on the front end of databases and uses inherent tools to manage data input. This allows users who are not specialists to apply the tool. Saving Changes...
Kim PehlkeCorporate Project Manager| Church Mutual Insurance CompanyTomahawk, Wi, United States
I am looking for ways to create/manage a Lessons Learned repository. Do you use it for something like this by chance? If so, would you consider sharing it with me so I can see how you have it established? Saving Changes...
Just a short hint on all the comments already provided:
For collaborative planning and task/ issue mangement in a team, I can suggest from my project experience the following combination:
MS Project Server + SharePoint (and here using SharePoint List functionality) Saving Changes...
David ThompsonHuman Resources Specialist (Information Systems)| US Bureau of ReclamationSalt Lake City, Ut, United States
I am an Access database junkie. Been developing in Access for over a decade now, and yes, I have my own project management database, built in Access. The flexibility this affords me is beyond any ROI that I can think of - particularly because I have become very adept at downloading data from my corporate IBM and Oracle databases, then joining that data in my Access databases.
Data analytics is among the most neglected, and under-used corporate tools available. But, it *does* take somebody who is proficient in Access databases, for sure! And my biggest conflict with management is succession planning. Who will maintain my databases when I leave? Management is not interested in training anybody to replace my skill set, and for several years (prior to now), I swore off developing Access databases. But, management needs data - in my case, they need turnover data. The only way I can provide that is with my Access databases.
Sorry, I got a little off-topic from the Project Mangement database. But, the same discussion applies to it, as well. Saving Changes...
Hi Edmon and others, for many years I have used MS Access for project management, for me it has been an essential tool for managing the several aspects of PM. I even went as far as publishing MS Access data bases in the web (in SharePoint server), to share my data bases with others. Nevertheless, seems Microsoft SharePoint no longer can host MS Access, and I've been trying to find a way to share my MS Access data bases with others in the project team, within the same office and remotely, unsuccessfully so far. Has anyone had any experience with sharing MS Access data bases with others ? Saving Changes...
Also, for those who feel that they need to be very skilled at using MS Access in order to use it in Project Management, you can do as I did some years ago, start with very simple data bases, for which there are even templates available, and move up to more complex DB's. I started with a simple suppliers/contractors, and purchase order data base, to help the procurement function, which is an essential element of PM. Saving Changes...
David HolbrookDavid Holbrook | Holbrook & Company LLCNy, United States
May 01, 2016 4:55 AM
Replying to Edmon Agron
...
I would love to share with you but PM me your email
Please send to me as well. System is limiting my ability to "add" you. Saving Changes...