By Richard Rost 14 months ago
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.
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
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
Subscribe to Help Desk
Get notifications when this page is updated
Check out these other pages that may be of interest to you: