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...
Edmon AgronSystem Coordinator / Document Controller| MBO Architects and Engineering ConsultantJeddah, Saudi Arabia
May 01, 2016 9:38 PM
Replying to Kerain Shah PMP
...
Why would you want to use MS Access, if there are loads of Project Management tools available that specialized in managing projects effectively?
Sure why not. what I mean is why do I need to spend more if there is a tool readily available in my hand? MS Access is package with your MS Office. Saving Changes...
Edmon AgronSystem Coordinator / Document Controller| MBO Architects and Engineering ConsultantJeddah, Saudi Arabia
May 01, 2016 7:43 PM
Replying to George Lewis
...
Edmon, you may want to drop a comment here as well...
Edmon AgronSystem Coordinator / Document Controller| MBO Architects and Engineering ConsultantJeddah, Saudi Arabia
May 01, 2016 10:35 AM
Replying to Justin Wortley
...
I feel like you could use MS Access to do pretty much whatever you needed for your project management, but you would need to either A. be really skilled at Access DB design or B. be able to find someone that is that could meet your requirements. It's certainly not OotB friendly for the average PM which is its real drawback.
Agree. In fact not only for MS Access but to all tools available out there -- you need to have at least the fundamental knowledge to use it effectively.
However it terms of programming or developing your DB system through MS Access, I'm not a hard core programmer anyway I just learned it from the internet and explore it myself. Saving Changes...
Linda MillerProject ManagementHuntington, Ny, United States
I found it useful to help with some number crunching on a backlog I had in a Kanban run project Saving Changes...
STEVE BOEDECKERUnemployed Project Manager| FutureVision ProductionsVernon, Nj, United States
I created an MS Access database back in 2006 for a project because we didn't have PROJECT at the office nor did they see the need for Project. LightWeight thinking of course considering all the sales and marketing projects they had with fewer employees.
The problem was that there is no portablility that can be easily accomplished, and the quantity of raw data needed to be summarized can be daunting, especially when you want to link or embed the reports into a presentation or document for lessons learned, or Change Management.
...
1 reply by Edmon Agron
May 16, 2016 8:52 AM
Edmon Agron
...
I see. But I just don't understand what you mean by
"The problem was that there is no portablility that can be easily accomplished, and the quantity of raw data needed to be summarized can be daunting, especially when you want to link or embed the reports into a presentation"
MS Access and MS PowerPoint are both Microsofts and I believe they support each other in terms of linking and embedding.
Great. This is what I particularly did. I created a hierarchy of folders where all the documents should be stored and linked it to MS Access -- that whenever I need to retrieve information I just open my Microsoft access and search from there - to exaggerate it - it does like Google but only at my local network.
You can use MS Excel, write VBA macro to create hierarchical links and retrieve information.
Another much simpler approach is - Mozilla Firefox. It creates the link and arranges the contents in a folder hierarchically. All you need to do is type the folder path in URL and press enter. This will create index page.
I have used MS Access as a database only, for publishing KPI dashboards that is used by leadership.
MS Project is a good option for Project Management.
...
1 reply by Edmon Agron
May 16, 2016 8:59 AM
Edmon Agron
...
What I mean was. I created external folders where files are stored and linked to the database for easier retrieval.
Saving Changes...
Edmon AgronSystem Coordinator / Document Controller| MBO Architects and Engineering ConsultantJeddah, Saudi Arabia
May 02, 2016 8:45 AM
Replying to STEVE BOEDECKER
...
I created an MS Access database back in 2006 for a project because we didn't have PROJECT at the office nor did they see the need for Project. LightWeight thinking of course considering all the sales and marketing projects they had with fewer employees.
The problem was that there is no portablility that can be easily accomplished, and the quantity of raw data needed to be summarized can be daunting, especially when you want to link or embed the reports into a presentation or document for lessons learned, or Change Management.
I see. But I just don't understand what you mean by
"The problem was that there is no portablility that can be easily accomplished, and the quantity of raw data needed to be summarized can be daunting, especially when you want to link or embed the reports into a presentation"
MS Access and MS PowerPoint are both Microsofts and I believe they support each other in terms of linking and embedding. Saving Changes...
Edmon AgronSystem Coordinator / Document Controller| MBO Architects and Engineering ConsultantJeddah, Saudi Arabia
May 16, 2016 8:00 AM
Replying to Anupam
...
You can use MS Excel, write VBA macro to create hierarchical links and retrieve information.
Another much simpler approach is - Mozilla Firefox. It creates the link and arranges the contents in a folder hierarchically. All you need to do is type the folder path in URL and press enter. This will create index page.
I have used MS Access as a database only, for publishing KPI dashboards that is used by leadership.
MS Project is a good option for Project Management.
What I mean was. I created external folders where files are stored and linked to the database for easier retrieval.
