How to Build a Microsoft Access Help Desk Trouble Ticket Database System

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 and up get access to an Extended Cut of this video. 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.
MEMBERS VIDEO:
• Microsoft Access Help ...
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.
GOLD MEMBERS BONUS VIDEO:
• Microsoft Access Help ...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/HelpDesk
LINKS:
Relationships: 599cd.com/Relationships
Continuous Forms: 599cd.com/Continuous
Relational Combo: 599cd.com/Relational
Blank Template: 599cd.com/Blank
Contact Template: 599cd.com/Contacts
Invoicing: 599cd.com/Invoicing
Don't Delete Data: 599cd.com/DontDelete
Subforms: 599cd.com/Subform
Intro to VBA: 599cd.com/IntroVBA
Value from a Form: 599cd.com/FormName
Bang! v Dot.: 599cd.com/BangDot
Conditional Format Expression: 599cd.com/CFExpression
Custom Counter: 599cd.com/Counter
Search Seminar: 599cd.com/SearchSeminar
Security Seminar: 599cd.com/Security
Recordsets Access D16: 599cd.com/ACD16
Microsoft Access Feedback: tinyurl.com/y2dl56sr
Mike Wolfe: nolongerset.com
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@xm_tech]

I love your videos my friend. Thanks for sharing. They're really helpful. I've built a great database but after watching your videos I keep changing things around and it's looking even greater.

[@599CD]

Sweet! Glad you find them helpful.

[@tylerwilliams9541]

I’ve needed something like this for so long THANK YOU!!

[@599CD]

Welcome :)

[@TGilbertPE]

Great video. Your stuff is the best Access training I have seen. One "nit-picky" detail, there is one small item in this vid that caught my attention - the "Description" label in the ticket detail sub-form header is too narrow, the word "Description" is wider that the label and the word is truncated. Thank you for sharing your knowledge!

[@599CD]

You caught me! :)

[@MrAimalsultani]

Well-Done Sir,

[@599CD]

Thanks

[@abdulhamidalhaddadi2255]

Thanks a lot

[@599CD]

Most welcome

[@tinaomotoyosi]

Thanks Richard. You’re a rockstar!

[@599CD]

You're welcome!

[@paulnyamtowo]

Hi Richard Would you please help me on this. Is it possible to use the lookup wizard in a table, to lookup values from 2 fields in 2 different tables? Do you have a video on that already?

[@599CD]

Need more context.

[@stanTrX]

Thanks Richard.what if i also want to track and log status. Can i do that using many to many with popup form? Do you have a video for it?

[@599CD]

599cd.com/TrackLogon

[@599CD]

599cd.com/TrackChanges

[@stanTrX]

thank you richard. this was what i was exactly looking for.@@599CD

[@TechAidCaloundra]

Are you going to add a timer button toggle that you can turn on to "time" a ticket while you work on it in the extended version?

[@599CD]

599cd.com/TimeBilling

[@skotkda252]

Very important for SLA

[@gregstapells6431]

Hi there great video thank youI I found this looking for something that would convert office 365 emails to a ticket in access. Do you think that would be hard to do? So for every email that comes in to help@ it creates a new ticket which can be reviewed on a form and marked, deleted, status change, etc. Thanks very very much!

[@599CD]

I cover taking Outlook emails as they come in and importing them into your Access database in my email seminar 599cd.com/EmailSeminar

[@andreasfenopo2819]

Hi! How can I get the full template as ah the end of the video and note the empty template version?

[@599CD]

599cd.com/HelpDesk

[@khalidpervez8959]

I am working on a data base but i got stuck while generating statement with in date range, can u help me.

[@599CD]

599cd.com/Between

[@gregoryjeffries8475]

Code optimization, I consider best practice.

[@599CD]

Yep!

[@stephenbeswick2163]

Hi Richard can you run 2 different database together.

[@599CD]

Sure. You could run 20.

[@shinrafahell]

How to share the form for multiple users without design access?

[@599CD]

599cd.com/ACCDE

[@599CD]

599cd.com/Split

[@mohammedalsarraj9963]

First

[@599CD]

People still do that? :)