I currently have an Access database and a specific SQL query that runs in it that provides ticket information. I am in need of a new database that I can add this query to that will allow me to do the below tasks. First let me provide a bit of information about the query:
-The query returns a list of tickets closed from the prior day or specified date that specific user's completed. It shows Their name, the ticket number, and the project number it if the ticket was a part of a project.
-When doing QA, I must go through each user and a certain number of their tickets (could be all tickets, random 3, random 5, or random 10), and ensure they were processed correctly.
**What I need the database to do**
-Run/Examine the above mentioned query
-Allow me to choose a user and the amount of tickets I would like to QA
-Have a form that populates the user's info and tickets/ticket numbers I am going to review, and have additional fields for if the ticket was correct (yes/no), if not, what type of failure it was(Audit/Process), a notes section for comments, and the date in which the ticket was actually closed.
-The form should be able to pull a random selection from the entire query, or pull for a specific user.
-The QA results should be able to be saved to a table and appended each day.
-I am not looking to go broke on this, but am hoping to find someone that would enjoy doing this for a fair price. I can provide any additional details needed, just let me know what you need to know.
31 freelancers are bidding on average $127 for this job
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access query. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
Hi, I am interested in this project. If interested in hiring me then please let me know so that we can discuss it further. we can also skypeeee on it. my id is [login to view URL] Regards, Jawad