Microsoft Access Help Desk Trouble Ticket Database

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

Bryce from Independence, Missouri (a Platinum Member) asks: I run a tech support call center help desk. Right now we're just using email to track everything, and it's a mess. Can you show me how to put together a database to track tickets, so we can get a list of what's open, what's closed, what still needs to be billed, and so on? It would also be nice if we could sort them by priority. If this guy's whole system is down, he should get first priority. If that guys speakers are making a funny noise, he can wait. That kind of stuff.

Members

Silver Members 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.

Gold Members will get an extra 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.

•  Extended Cut Video - Silver
•  Gold BONUS! Video - Gold
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Template

If you wish to purchase a copy of this database as a template, without committing to becoming a monthly member, you can do so here: Help Desk Template

Links

• Relationships: https://599cd.com/Relationships
• Continuous Forms: https://599cd.com/Continuous
• Relational Combo: https://599cd.com/Relational
• Blank Template: https://599cd.com/Blank
• Contact Template: https://599cd.com/Contacts
• Invoicing: https://599cd.com/Invoicing
• Don't Delete Data: https://599cd.com/DontDelete
• Subforms: https://599cd.com/Subform
• Intro to VBA: https://599cd.com/IntroVBA
• Value from a Form: https://599cd.com/FormName
• Bang! v Dot.: https://599cd.com/BangDot
• Conditional Format Expression: https://599cd.com/CFExpression
• Custom Counter: https://599cd.com/Counter
• Search Seminar: https://599cd.com/SearchSeminar
• Security Seminar: https://599cd.com/Security
• Recordsets Access D16: https://599cd.com/ACD16
• Microsoft Access Feedback: https://tinyurl.com/y2dl56sr
• Mike Wolfe: https://nolongerset.com

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

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