MS Access Ticket/Tracking
$30-250 USD
Paid on delivery
I am needing a MS Access database that allows me to keep track of tickets. I know there are a lot of ticketing systems out there, but this is a custom job. Below are the needed aspects. I would like this to be done in forms. so that it is neater to look at. I am not sure if all of this can be done via Access. If not, please advise.
Ticket Type:
-Single
-Project
Ticket Status:
-Pending
-Closed
Primary Dashboard
-Option to create new ticket
-Option to input a ticket number and open that ticket
-Ability to see all previous tickets either by all tickets, or single tickets only or project tickets only.
-Ability to see tickets that are NOT in a closed state and are older than 1 day
-Ability to see tickets that have not been updated in that last day
New Ticket Options:
-Ability to enter the date the ticket was created
-Ability to insert your own ticket number
-Ability to choose the ticket type (LAN, Email, HSS
--Ticket options:
-There needs to be a section where you can enter what type of access is being requested (see above for LAN,EMAIL, HSS). Then you need to have columns for the selections.
-------If a user needs 1 group, there needs to be a column for the group, and a column for the approver.
-------If a user needs sql access, there needs to be a column for the server, the database, and the type of access (db_datareader,db_datawriter,sp_execute, dbo, custom), as well as a column for the approver.
-------If it is email, there needs there needs to be a column to put email, and a column for approver.
-------There needs to be some sort of option to add multiple elements for each ticket. So if a user needs a group and sql access, I need the ability to add both to the single ticket.
-------There needs to be some sort of option to show which requested part has been "approved". This can be a checkbox, or whatever works.
-------There needs to be a worklog so what has been done can be put in this box.
-I need the ability to edit tickets and their worklog, as well as add additional elements that they are requesting to pending tickets.
-If a request is "urgent", I need some sort of way to show that those are urgent and stick out from the rest.
-This is all I can think of for now. I know there is a call tracking system for ms access that may be easier to modify for this request: The link is located below:
[login to view URL]
Project ID: #6241861
About the project
22 freelancers are bidding on average $172 for this job
Dear, I am Access automation Expert since 11years. I confirm I can develop all your requirements, I will focus on user friendly GUI. I will be available after development, as support. Regards, Fabrice
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases More
I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I have only 3 ratings/feedback to show you. I can ass More
Dear Sir, I'm Expert at access, and interested on doing your project, it will be professional by very friendly interface. Kind Regards, NourElDeen
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft database (Access ,Sql Se More
Hi, I could develop a basic demo for your system at no charge at all, and then if you like it, you can select me to develop your project. If you don't like the demo, you just select someone else (so no strings attached More
Hi, I've done a lot of similar projects and the way I prefer to do it is in a combination Delphi and MS Access. An application that manages the database is built in Delphi. All you mentioned can be created in Access More
Experienced software professional with 20 years in design, development and maintenance of applications
I have experience working on Access database and can provide you with the required screens and database with greater accuracy and on time.
Sir I am interested in your project. Let me help you, I hope that you will be satisfied from my work Have a good day.
I've been doing vba programming for about 8 years. I can do this, and I think you will be satisfied with the results.
I have completed different jobs earlier. I can start immediately. I am waiting for your response. Thanks.
I propose to develop and supply a ticketing system using Ms Access 2007. I will bring over 20 years experience developing software to bear on this role.
Good morning I am a medical student who's trying to make his way and I am an autodidact in many other areas, my father an accounting accounter and I have manipulated MicrosoftExcel since my youngest years, I consider m More