Project Management, Gantt Chart, Scheduling

Videos

•  0. Introduction (4:41)
•  1. Developer Walkthru (16:40)

Description

This database template will allow you to track unlimited projects and their associated tasks. It includes a Gantt chart form and printable report. It’s great for all kinds of scheduling, whether it’s projects, personnel, or resources.  This template is built 100% in Access with no add-ins, DLLs, or 3rd-party components to install. There is a free 4 minute video, above, that you can watch which will walk you through all of the features.

Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable version of the template which will let you see it work in action. The sample database requires 64-bit Access 2013 or higher. If you're still using 32-bit Office, read this.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and click on the Download button below. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2013 or higher (possibly 2007, but I haven't tested it).

Links

• Access Beginner 1: https://599cd.com/ACB1
• Blank TechHelp Template: https://599cd.com/Blank
• Nested Continuous Forms: https://599cd.com/NestedContinuous
• Intro to VBA: https://599cd.com/IntroVBA
• Access Developer 1: https://599cd.com/ACD1

Notes

• This is a relatively simple project management database template. It's more of a "proof of concept" than an actual full-fledged project management system. I designed it to show how a Gantt chart could be put together in Access, and it's a stepping-stone for other developers to add whatever they want. It doesn't have a ton of features "out of the box" but it's a template you can modify for your own needs, however you see fit.

Possible Future Upgrades

The following are possible upgrades that I'm considering for a future version, if there is interest. If you are interested in any of these, or have suggestions of your own, please post them in the comments section below.

• More colors than red and blue
• Multiple time slots for the same task instead of just one
• Hourly time slots, 15 min increments, instead of just whole days
• Hide weekends
• Display some data in the blocks, hover tooltips for more, double-click to edit
• Zoom in and out (timeframe): Workday, 1 day, 1 week, 3 weeks, month, quarter, year
• Also see this older thread discussing this template

I didn't include a lot of the simple, standard fields (project address, cost, etc.) or add a customer table or things of that nature because this was designed to be a simple template that you can integrate into your existing database. This is designed for the Access developer who knows how to add their own fields and additional tables for things they need. However, if you would like to see this built into a more "full featured" database with all of those extraneous fields, tables, reports, etc. Let me know. Your feedback is very important. I'll take this project in whatever direction there is demand.

License

For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Not a Finished Product

Please keep in mind that most of my template databases are not designed to be finished products that are ready to go in a working environment. My templates are meant as starting points for you to customize for yourself so you don't have to reinvent the wheel. This requires that you have a basic understanding of Microsoft Access development. To work on most of my databases you should have completed my Access Beginner series and the first couple levels of my Expert series at a minimum. Most of my databases require knowledge of SQL and VBA as well. 

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. If you have a problem with one of my databases, I will only support the unmodified database exactly as it's downloaded from my site. If you have modified it in any way, it may not be something I can help you with. You can post in the Forums, and I may be able to help you, but if the issue doesn't exist in my unmodified database, it's not something I can support.

Questions?

Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.

Keywords

microsoft access project management, microsoft access gantt chart template, project schedule, project planning, project management, task planner, task scheduler, bar chart, gantt chart microsoft access, free template, free download, microsoft access, ms access, #msaccess, #microsoftaccess, #database, #template, #gantt, #projectmanagement