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:
KZitem: / @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.
Негізгі бет How to Build a Microsoft Access Help Desk Trouble Ticket Database System
Пікірлер: 36