online web based data collection system february 2011 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Utah State Pawn Database PowerPoint Presentation
Download Presentation
Utah State Pawn Database

play fullscreen
1 / 38

Utah State Pawn Database

747 Views Download Presentation
Download Presentation

Utah State Pawn Database

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Online, Web-Based Data Collection System February, 2011 Utah State Pawn Database

  2. Background • Pawn shops must upload transaction data to the Statewide Pawn Records Database. • A limited number of file formats are accepted for uploading Pawn transaction data. • For those shops that can’t provide data in one of the standard formats, an Access-based data entry system was made available to collect transaction data and upload to the database.

  3. Issues with Access-based System • Requires Microsoft Access license. • Can only be used on one computer. • Does not provide editing/cross checking of data. • Requires files to be uploaded manually. • Files could contain errors or missing data.

  4. Web-Based Data Collection System • A new web-based data collection system has been created to replace the Access-based system. • Eventually everyone that uses the Access-based system will be asked to use the Web-based system.

  5. Benefits of Web-based System • Doesn’t require Microsoft Access License. • Can be run from any computer with Internet access. • Can be run from multiple computers. • Data is verified for accuracy before being accepted. • Data selections are contained in drop-down lists and menus.

  6. Web Pawn System Menu Location

  7. Ticket Summary Page

  8. Ticket List Page

  9. Ticket Entry Form

  10. Ticket Entry Form

  11. Ticket Entry Form (Data)

  12. Ticket Entry Form

  13. Ticket List with New Ticket

  14. Ticket List – Add Items

  15. Ticket Item List

  16. Ticket Item List – New Item

  17. Ticket Item Form

  18. Item Form – Data Entry

  19. Item Form – Data Entry

  20. Item Form – Data Entry

  21. Item Form – Data Entry Item Form – Data Entry

  22. Item Form – Data Entry

  23. Ticket Item List – Item Added

  24. Add Remaining Items Repeat using the Item Form to add each of the remaining items on the ticket.

  25. Ticket Item List – All Items

  26. Return to Ticket List

  27. Ticket List

  28. Add additional Tickets Add additional tickets and items by repeating the process of adding the ticket information (using the Ticket Form) and adding items to the ticket (using the Items Form).

  29. Ticket List – Additional Tickets

  30. Finished Entering Tickets

  31. Summary Page

  32. Submit Tickets to Database Repeat using the Item Form to add each of the remaining items on the ticket.

  33. Submit to Database

  34. Tickets Submitted • After being submitted to the Database, the tickets submitted are no longer available for editing. • The Summary Page lists the last 10 submissions.

  35. Summary Page

  36. Summary • The Web-based data collection system will take the place of the Microsoft Access-based system. • Everyone who currently uses the Access-based system will be asked to use the Web-based system. • Shops that use inventory systems that extract and upload transaction data may still continue to do so.

  37. Contact • To have your shop set up to use the Web-based system, please contact us: pawn.ucadm@state.ut.us

  38. Utah Statewide Pawn Information System Thank You