Choosing the right (Microsoft) tool for the job.

I work in events and facilities management for a University and often have multiple projects to track as well as multiple work orders open with various other departments on campus (i.e., IT, facilities, custodial, dining, security, etc.). I'm looking for a better way to track and manage all these various and disparate projects. I'm fairly savvy with excel and am starting to get in to the more advanced features, but I want to make sure I use the right tool for the job. Based on the software I already have access to due to institutional licenses, my choices come down to Microsoft Excel, Access, or Project.

I'm looking for advice and opinions on which of the three would be the best choice. I don't mind a learning curve and don't mind doing front end work, as long as the payoff in the end is worth it. The main things I'm looking for are:

•Tracking work orders from multiple different departments. If I can create something in VBA to take the automatic emails I get through outlook every time I submit a work order and input the information into whichever program I end up using, so much the better.
•Assign employees to different projects either as the person heading it up or as the person that needs to follow up to make sure that the other department completes the work.
•Create reports to see project progress and timelines.
•Ability to set task dependencies.
•Ability to create multiple parts for each project/task.
•Ability to attach or link to supporting documentation.
•Integrate budgets from other excel workbooks.

I already do all of this on paper or in simple excel workbooks and already do a good job of pre-planning, but overall I just need a more streamlined way to do everything. We're growing as a department and I'm taking on more responsibilities so I need a way to automate a lot of this, or at least make my digital work product "smarter."
Joe XAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
What you need is a database application; don't try to make Excel do database work, use Access.

There are lots of people here in the Access community who will be glad to help you with the process of developing the application, as long as you don't ask them to do it for you.

I don't know what version of Office you have access to, but there is a sample task management database available for download here:https://support.office.com/en-us/article/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb?ui=en-US&rs=en-US&ad=US

I have not downloaded and looked at this, but I would anticipate it would already have a lot of what you are looking for.

Depending on the version of Office you have access to, you might also be able to select from among the templates which are displayed when you open Access.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joe XAuthor Commented:
I've never used Access before so I wasn't sure if it was right for what I needed and as I said, I don't mind putting in the effort to learn it, but I don't have the time to put effort into something that isn't going to pay off.

I'm currently using Office 365 so I'll definitely check out those templates. Thank you!
0
Joe XAuthor Commented:
For those with this same question, essentially, I just needed confirmation on what I already knew, that I should use Access.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
>  right tool for the job.... ..... I don't mind a learning curve

You have ms project and I suggest putting some time aside to learn that. You may already have something being at a university, but there will be online courses and examples.  Spend your time to learn about that tool, then start moving what you have in excel to project.

From experience, trying to develop something in access/sql server is going to take a lot more time than you think and will need to be continually marinated and updated.  

There are also free online tools worth looking into such as a kanboard. I use https://kanboard.org/.  You can run this locally or if the university gives you some web space to host open source projects, you will be in business.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
If you already have office 365 project, that sounds like your answer!  https://products.office.com/en-us/project/project-online-professional
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.