Computer Learning Zone CLZ Access Excel Word Windows

Improve a mechanical device and you may double productivity. But improve man, you gain a thousandfold.

-Khan Noonien Singh
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > Help Desk
Help Desk Template

Microsoft Access Help Desk Trouble Ticket Template

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

This template is the full database created in my Help Desk TechHelp videos, including the two Member-Only Extended Cuts. When you purchase the template, you get a full downloadable version of the database, plus you can watch the two Extended Cut videos to see how this database was built.




Video 1 is a free TechHelp video. In this video, I'm going to show you how to build a trouble ticket system for a help desk using Microsoft Access.

Video 2 is the Silver Members Only Extended Cut TechHelp Video. We will learn how to create printable tickets, assign tickets to employees, filter tickets by status (open, closed, etc.), add a Show All filter, and display the count of open tickets, the count of tickets that need to be invoiced, and the total dollar amount of billable hours to be invoiced.

Video 3 is the Gold Members BONUS! Extended Cut where we will learn how to do automatic billing. We will click one button and the system will create invoices for all of the tickets that are ready to be billed. We will use VBA and some sweet recordset programming to accomplish this task.

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



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.


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.


microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, job ticket, service ticket, helpdesk, help desk app, trouble ticket, ticketing, support ticket, ticket tracking, access ticketing, how to create a ticketing system in access, microsoft help desk


Help Desk Template Upload Images   Link  
Patrick Gray 
10 days ago
I am a Gold Member why can i not down load the Help Desk database?
Alex Hedley
10 days ago
This Template is a separate PAID item.
But it is also available to TECHHELP Members, but you need to download it from the HelpDesk page instead.
See Members section above.
Add a Reply
Help Desk Template Upload Images   Link  
Bill Olivo 
13 days ago
As a Silver member, I should be able to watch the Extended Cut, but it is asking me to purchase it.
Bill Olivo
13 days ago
Sorry, I was watching the Template video not the Tech Help.
Richard Rost
13 days ago
You're the second person today to make that mistake, Bill. I'll put a bigger note up top. :)
Add a Reply
Help Desk Template Upload Images   Link  
Patrick Gray 
13 days ago
I thought i was a gold member and have and should have access to the sample database.
Richard Rost
13 days ago
Hi Patrick. You are a Gold member, and you do have access to the Help Desk template, but you have to grab the one on the Help Desk TechHelp page. This page is for people who buy the template separately who aren't members.
Richard Rost
13 days ago
Find the "Database Download" link in the Members section.
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.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
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 job ticket, service ticket, helpdesk, help desk app, trouble ticket, ticketing, support ticket, ticket tracking, access ticketing, how to create a ticketing system in access, microsoft help desk  PermaLink