Closed

Access QA Database

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.

Skills: Microsoft Access

See more: audit details, sql microsoft access, microsoft project price, microsoft access sql, audit process, QA project, in process access, sql audit table, access query table, access notes database, selection access, microsoft ticket database, microsoft price list, access table query, find closed form, access table query form, database query failure, access database process, ticket add fields, access sql query, sql query access, access ticket database, microsoft project sql query, audit sql, access project database

About the Employer:
( 25 reviews ) NA, United States

Project ID: #6692064

31 freelancers are bidding on average $127 for this job

Prashantskin

[url removed, login to view] I have gone through all the details of your project. I will develop it within 3 days or even less. Please send existing db and specs in details for further discussion Thanks for your time Regards Pra More

$111 USD in 3 days
(480 Reviews)
7.1
MDavidCrompton

I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK b More

$160 USD in 10 days
(12 Reviews)
5.3
mail2vimalarora

Hi, I have gone through your project description and feel comfortable in taking it forward. I have worked on several MS Access projects and can help you in building yours too. You need to create a new database based o More

$133 USD in 5 days
(38 Reviews)
5.1
diegogarcia0531

I can do the work, just provide me full details, and send me the actual database, I am access expert developer Regards Diego

$166 USD in 3 days
(17 Reviews)
4.9
fabest

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

$70 USD in 1 day
(13 Reviews)
4.6
jawadaman

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 [url removed, login to view] Regards, Jawad

$77 USD in 3 days
(17 Reviews)
4.3
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$100 USD in 5 days
(11 Reviews)
4.3
nblsoft

I am very interested in your project and offer my services. I have profound skills in database designing, administration. I've designed many database for even complex businesses in Microsoft Access. Please see my More

$155 USD in 3 days
(4 Reviews)
4.0
dipakmoliya

I have been in this industry for 6 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your P More

$72 USD in 3 days
(11 Reviews)
3.8
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg More

$194 USD in 4 days
(3 Reviews)
2.9
fazeelatmazhar

Sir/Madam, Greetings. This is an IT person , an experienced MS Access database developer and an experienced designer .I have tremendous expertise in VBA programming , macros , SQL queries in Access . The requiremen More

$100 USD in 5 days
(4 Reviews)
2.5
ahmedsobherfan

A proposal has not yet been provided

$125 USD in 3 days
(4 Reviews)
2.2
nksundaram

Experienced software professional with 20 years in design, development and testing of enterprise level applications.

$83 USD in 10 days
(2 Reviews)
1.8
wmvsql

I have just recently worked on an Access contest for Layaways and LayawayQuotes, although I was not picked as the winner, I do have sufficient knowledge to get the job done. I have over ten years experience in Database More

$30 USD in 3 days
(1 Review)
1.3
alekseymihalych

Hallo. Need to look at your current db. Regards,

$166 USD in 15 days
(1 Review)
0.8
ingsunkancil

hello.. to do this job i need your database or detail your app to create sql query that you needs thanks bahrul

$77 USD in 5 days
(1 Review)
0.8
ashishseth1988

Hello, I am working with a MNC based company in a BI DWH project since last 4 years. This project is DWH project which comprised of DWH concept,Informatica as ETL tool and Cognos & Qlikview as reporting tool. More

$166 USD in 3 days
(1 Review)
0.4
Jaimehuang168

i am interesting about your coding work and wish we can work it out together. thanks for your attention.

$155 USD in 3 days
(0 Reviews)
0.0
NeilSargent

I am a new Freelancer and I was browsing for small projects to allow me to create a reputation. Your project struck me as being particularly suitable for my skills and experience - but it is not necessarily a very More

$250 USD in 5 days
(0 Reviews)
0.0
KhalidShah123

We are the leading young professional software development organization having extensive technical expertise and knowledge in developing, managing, optimizing and customizing software’s by implementing these software’s More

$84 USD in 5 days
(0 Reviews)
0.0