Simple database
I need a database that will have the following
GUI XP style
Tech Name
Fsr#
Customer #
Start time
Response time
Resolution time
Problem
p/n
case number
the database will track the default of 4 hour response, 8 hour resolution
I need to have a report that prints out missed response and resolution times with the tech name
Would like to see a clock within the database that shows a count down to response and resolution time.
red flag warns the administrator when 45 minutes is left on the clock counting down 4 hour response, 8 hour resolution.
I need to be able to run this on any pc.
Need to print off number of tickets a tech has and the make and miss response and resolution times.
the administrator must be able to adjust default response, resolution and warning flag times.
example: tech has a call that comes in for a hard drive
administrator puts in a start time
clock starts to count down to the two hour response time
If 45 minutes are left till a tech resolves an issue a red flag goes off flashing the tech and the call
when the tech makes the response a check box is check stopping the count down clock and recording the time
Then the 8 hour response clock run until the tech resolves the issue and if 45mins is left the red flag goes off
administrator can change the default time to adjust the count down clock and red flag.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
windows 98, 2000, XP