SRR Workspace ( rightclick to download ) is a MS Access desktop database. As a retail technician for Sprint, my responsibilities included inventory control and ordering warranty replacement handsets for customers. There was no system in place for keeping track of warranty replacements - this database allowed for quick, easy tracking. Occasionally, due to theft, we would have to clamp down on inventory control. Rather than handwriting (ugh) an equipment log, SRR Workspace allowed us to barcode scan the equipment out to agents and, more importantly, check them back in quickly.
Requirements :
- Inventory Control
- Check out equipment to an agent (barcode scanner capable)
- Change status of equipment if returned or sold, quickly & simply
- Display, on main screen, all currently checked out equipment
- Research equipment issues by searching log
- Manage warranty replacement program
- record customer info for a replacement
- see all replacements, filter by status ( ordered, received, called, etc )
- search for a particular customer or phone number
- sort list by model
- print out a scannable backorder list
- easily find and change status of a replacement
- take notes on each replacement
- auto generate notes when status changes
SRR Workspace was developed on my initiative, during down time & my off time - over several months. VBA powers all the buttons & the search & filtering.
- Best features
- I am most proud of the user interface in the DHRP screen ... it has great sorting & search functions. & it was easy to manipulate the records from the list view. The key to getting this system to be really useful was to make it completely simple & quick. I got close.
- automatic backup of the entire database/application file.
- Things to improve: ( this was not a company supported project - all design
choices had to consider the amount of unpaid time it would take to build)
- I would have improved the Edit Equipment system ... it powers the equipment dropdown lists throughout the app - but the Add/Edit Equipment screens were crude & ugly. The system was functional but not pretty.
- Security - there is no security implemented on this database. I did limit the menu functionality, just to prevent colleagues from breaking things, but we were in a secure environment & logins would have complicated things more than it was worth.
