|
||||||
Help Desk By Richard Rost 2 years 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. MembersSilver 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 files from class plus get access to the Code Vault. If you're not a member, Join Today!
TemplateIf 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
Keywordsmicrosoft 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
|
||||||||||||||||||||||||||||||||
| |||
Keywords: TechHelp 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 Help Desk in Microsoft Access |