Computer Learning Zone CLZ Access Excel Word Windows

All things good to know are difficult to learn.

-Greek proverb
 
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  |  Bookmark 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 Management Upload Images   Link  
Graham Hendricks 
2 months ago
I purchase this template, cannot use the forms, reports or module. What is the purpose of selling the template if you don't allow us to use it and customize it.
Graham Hendricks
2 months ago
Sorry my mistake I download you sample database
Richard Rost
2 months ago
Yep... the sample database is just for looky loos. :)
Add a Reply
Project Manager Template Upload Images   Link  
David Wilcox 
3 months 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
3 months 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
3 months 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 
3 months 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
3 months 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
3 months ago
Haha.
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