Computer Learning Zone CLZ Access Excel Word Windows

Education is a progressive discovery of our own ignorance.

-Will Durant
 
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 
24 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
24 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
23 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 
30 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
28 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
26 days ago
Haha.
Add a Reply
Dates Conditional Formatting Upload Images   Link 
David Wilcox 
30 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
26 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

Show Older Comments...
View in Table Format

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