Project Management Central

Please login or join to subscribe to this thread
Microsoft Access as a primary tool for Project Management
Network:910



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:
Page: 1 2 3 4 5 next>
Network:973



I would like to ask you to share sample of your usage of this program
...
1 reply by Edmon Agron
May 01, 2016 4:55 AM
Edmon Agron
...
I would love to share with you but PM me your email
Network:910



May 01, 2016 4:40 AM
Replying to Mazen AlRefaai
...
I would like to ask you to share sample of your usage of this program
I would love to share with you but PM me your email
...
2 replies by George Lewis and Mridula Thyagarajan Iyer, PMP
May 01, 2016 7:43 PM
George Lewis
...
Edmon, you may want to drop a comment here as well...

http://www.projectmanagement.com/discussio...-and-Technique-
Apr 28, 2017 11:38 AM
Mridula Thyagarajan Iyer, PMP
...
Could you please share that with me as well?
Network:26233



Edmon, I have not used Access for projects however, a coworker has and he raved of the benefits. I did see how this assisted him and plan to use this in the future for my needs. I too like MS Project.
...
1 reply by Edmon Agron
May 01, 2016 8:39 AM
Edmon Agron
...
Great. MS project as far as I know is specialized on scheduling only whereas MS Access will cover everything.
Network:910



May 01, 2016 8:24 AM
Replying to John Caron, MBA, PMP, CSM
...
Edmon, I have not used Access for projects however, a coworker has and he raved of the benefits. I did see how this assisted him and plan to use this in the future for my needs. I too like MS Project.
Great. MS project as far as I know is specialized on scheduling only whereas MS Access will cover everything.
...
1 reply by Justin Wortley
May 01, 2016 10:35 AM
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.
Network:88



May 01, 2016 8:39 AM
Replying to Edmon Agron
...
Great. MS project as far as I know is specialized on scheduling only whereas MS Access will cover everything.
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.
...
1 reply by Edmon Agron
May 02, 2016 2:21 AM
Edmon Agron
...
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.
Network:76337



I have use MS-Access, and FileMaker Pro, both interesting but if you want to use it for many person you need a skill programmer. Also use Omnis 7 from Blyth for about 20 user, was great.

MS-Access would let you link with MS-Project.
...
2 replies by Edmon Agron and STEVE BOEDECKER
May 02, 2016 1:54 AM
Edmon Agron
...
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.
Oct 27, 2016 3:36 PM
STEVE BOEDECKER
...
wow, is filemaker still around?? I used that for TBT Express back in 90s to create a hub schedule protype!
Network:8929



http://www.projectmanagement.com/discussio...-and-Technique-
Network:8929



May 01, 2016 4:55 AM
Replying to Edmon Agron
...
I would love to share with you but PM me your email
Edmon, you may want to drop a comment here as well...

http://www.projectmanagement.com/discussio...-and-Technique-
...
1 reply by Edmon Agron
May 02, 2016 2:10 AM
Edmon Agron
...
Thanks Goerge. I did
Network:88



Why would you want to use MS Access, if there are loads of Project Management tools available that specialized in managing projects effectively?
...
1 reply by Edmon Agron
May 02, 2016 1:59 AM
Edmon Agron
...
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.
Network:910



May 01, 2016 4:18 PM
Replying to Vincent Guerard
...
I have use MS-Access, and FileMaker Pro, both interesting but if you want to use it for many person you need a skill programmer. Also use Omnis 7 from Blyth for about 20 user, was great.

MS-Access would let you link with MS-Project.
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.
...
1 reply by Anupam Ganguly
May 16, 2016 8:00 AM
Anupam Ganguly
...
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.
Page: 1 2 3 4 5 next>  

Please login or join to reply

Content ID:
ADVERTISEMENTS

"To stimulate creativity, one must develop the childlike inclination for play and the childlike desire for recognition."

- Albert Einstein

ADVERTISEMENT

Sponsors