Project Management

Please login or join to subscribe to this thread

Microsoft Access as a primary tool for Project Management

linkedin twitter facebook   Business Intelligence   Construction   Requirements Management   Strategy   Work Breakdown Structures (WBS)  
avatar
Edmon Agron System Coordinator / Document Controller| MBO Architects and Engineering Consultant Jeddah, 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.
Sort By:
< 1 2 3 4 5 >
avatar
Morne Beeslaar Managing Director| Faolan Consulting Pretoria, 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.
avatar
Kim Pehlke Corporate Project Manager| Church Mutual Insurance Company Tomahawk, 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?
avatar
Peter Ambrosy Weinheim, Germany
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)
avatar
David Thompson Human Resources Specialist (Information Systems)| US Bureau of Reclamation Salt 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.
avatar
Angelo Andrade Project Management| Howden Australia Australia
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 ?
avatar
Angelo Andrade Project Management| Howden Australia Australia
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.
avatar
David Holbrook David Holbrook | Holbrook & Company LLC Ny, 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.
avatar
Kevin Drake Perth, Western Australia, Australia
I have not used it for a while, but I think I would love to explore it on a small project without a team.
< 1 2 3 4 5 >

Please login or join to reply

Content ID:
ADVERTISEMENTS

"The power of accurate observation is often called cynicism by those who don't have it."

- George Bernard Shaw

ADVERTISEMENT

Sponsors