Computer Learning Zone CLZ Access Excel Word Windows

Take the attitude of a student, never be too big to ask questions, never know too much to learn something new.

-Og Mandino
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > Project Management
 
Project Management

Project Management, Gantt Chart, Scheduling


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  Buy Now

Videos

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

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 database for your business needs and for use within your organization. You may not resell or distribute it 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 database you are reselling. 

Customize For Your Needs

If you would like to discuss customizing this database for your needs, and integrating it into your current setup, please see my consulting page for details on rates and other information. 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 do not specific, custom work just for you, visit my Access Developer Network.

Questions?

Got sales or customer service questions about this template? Feel free to post them below. If you have a questions, or you discover a bug or want to suggest a new feature, then please by all means 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

 

Project Manager Template Upload Images   Link 
David Wilcox 
18 days ago
Richard- I love the Project Manager Template I just purchased and Im trying to modify it a bit to meet my specific needs. My difficulty is that I need to be able to number calculate a value between the date in label D00 on the Task Planner and another date (Incumbent Expire Date) in my table and query. I want to use that calculated number in some conditional formatting to set background colors in the boxes corresponding to the dates in D00 through D20.  Ive tried several options including DateDif, etc. but without success. It seems as if the data in D00 is just not recognized as a date or a number.  So, please help me Obi Wan! Youre my only hope! Read More...
Adam Schwanz
18 days ago
What are you having happen? Is it giving you an error or a strange value back? You could always CDate Or CInt/CDbl it and see if it works to confirm it sees it as a date or number.
Richard Rost
17 days ago
If this is a value you added to a new table yourself, then you should be able to use the same logic that I used for changing colors. If you're trying to change the HEADER fields, then you don't need to use conditional formatting. A simple D00.BackColor= will work since there's only one of those.
Add a Reply
PM 20 Upload Images   Link 
Juan C Rivera 
24 days ago
I like to see a chart start from the project name start date , end date kind of a birds eye view.  then click on a specific tasker and see the breakdown as you have it now.
Juan C Rivera
22 days ago
Loving the simple ways of this project Mangt.  Kicking MS Project to the curb it simple and does what i need thanks Richard.
Now Im going to try to add diffrent colors so when I mess it up Il scream for help.  Adam, Scott be on the look out I can break a bowlling ball.

Juan
LLNP
Richard Rost
20 days ago
Haha.
Add a Reply
Dates Conditional Formatting Upload Images   Link 
David Wilcox 
24 days ago
Richard. I love the Project Management template. As you know, I'm an OAM (Official Access Moron) however I couldn't stop myself from purchasing the template.  So being an OAM,  I (obviously) have a question? Is there a way to use the 'dates' in the template labels (D00, D01, etc.) in a conditional formatting statement for Boxes 00 through 20, so that when that date coincides with another benchmark date I designate from my query?  I've tried a couple of times, but I not sure if the "label" data is being recognized in the conditional statements. For example, when the data in Label D00 coincides with a benchmark date of 10/1 from my query, I'd like Box00 to change color. Can that be done? And if so, how? Thanks and live long and prosper.
Richard Rost
20 days ago
Yeah... you could do it, but you wouldn't need conditional formatting. Since it's just a simple block of labels in the header, adjust their .BackColor manually. You'd need an event to check if the dates shown coincide with a benchmark date, which you'd need to designate somehow in your table. It's very possible.
Add a Reply
Project Management Upload Images   Link 
Achim Marliani 
26 days ago
Richard,
I really would love to see all the tasks for one person in one row, and it would be nice to split tasks down to the hour.
But I do also have a question: I've played around with those colors and came across a limitation. What if you need more than five colors? AFAIK Access doesn't allow more than five conditional formats for one field. Any idea?
Richard Rost
26 days ago
You must have an older version of Microsoft Access. Access 365 allows more. I have one database with 14 conditional formatting levels in it. Time to upgrade. :)
David Hawley
26 days ago
Similar but different to Achim's comment -- I'd like to see an adjustable timescale for the Planner view as well. In my case though, I'd like to be able to zoom out from individual days and instead see weeks. This would be helpful for projects that span a couple quarters.
Add a Reply
Project Manager 10 Upload Images   Link 
Walter Hamilton 
26 days ago
Richard,
Thanks for the Project Manager 1.0 template.  I'd like to see you add the nested personnel functions so on both the TaskF and the TaskPlannerF.

I'd ultimately like to incorporate this into the Management Database we are using.  We have Contracts/Purchase orders employees are assigned to.  I'd like to be able to select the Project Name/Charge Code from a combo box, it show the start and end date then be able to select the employee from another combo box.  I would then need to be able to override the start and end dates if a specific employee was only supporting for a specific time period. Read More...
Add a Reply
Project Management Upload Images   Link 
Graham Hendricks 
26 days ago
Very Good. What I like to see : Example Dave on one single row with the different task dates and with values inside the boxes. You said it possible, can show us please?
Add a Reply
Project Management Upload Images   Link 
William Dowler 
27 days ago
Richard,
I don't see any ability to add dependencies between tasks or add resources to tasks. Any plans to add that functionality?
Richard Rost
27 days ago
I'd be happy to add it to the list. Explain a little more about what you're looking for.
William Dowler
26 days ago
Richard,
Normally when defining tasks I would add which people would be working on each task. If Sue was working on both Tasks 1 and 2 then Task 2 would be dependent upon the completion of Task 1. If I increase (or decrease) the duration of Task 1 then the start date for Task 2 would be adjusted accordingly. That way I can see the impact of adding or removing people from tasks.
The above is an example of a Finish-To-Start dependency. I may also have Start-To-Start dependencies where both tasks may be started on the same date but only if both tasks are ready.
It would help if each Task had a Start Date and a Duration. The Duration is normally set for how long it would take one resource to complete, then if I add resources (or remove Resources later), the Duration (and thus the Finish Date) would change accordingly.
Percentage of work complete for each task is also important.

Reports would be helpful, for example "Which Resources are over allocated (working more than 8 hours day)".
Add a Reply

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: templates access 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  PermaLink