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."