Complete/Modify Repair Shop Access Database
$30-100 USD
Paid on delivery
This project is mostly completed but I’ve got caught up on some other higher priority efforts.
The coder of this project must complete the following changes and additions to the Access Database I provide. Coder may modify or create any table required to make these changes work
Most of the changes are listed below however I suspect I’ll have additional one once the following ones are completed or the coder makes suggestions. Please make sure your bid accounts for this.
This is a database solution for a Computer Repair shop
1.? The term “Investigator?? should be replaced with “Technician?? on all forms, reports and labels
2.? On main Switchboard add categories for
Check-in
2a. Under check-in add a form to capture new customer information or lookup existing customer to add or update the customer table.
Textbox Customer name
Textbox? Customer complete Address
Textbox? Customer Phone
Textbox? Customer Cell Phone?
Textbox? Customer Cell Carrier (This is for SMS notification)
Textbox? Customer Email Address
Checkbox Customer preferred contact method for status
? Phone
? Test Message
Create New Ticket button
Auto create ticket number
Fields to capture information about PC/Laptop (Type, Manufactuer, OS,)
Customer Reported issue (memo field)
Resolution (memo field)
Check-out
? Form to lookup customer by name or ticket number
? Ability to select and goto ticket record
Tech needs to checkout ticket to work it.
Ticket status becomes “Working??
Ticket assigned to becomes (Tech’s name)
Ticket becomes locked to all accept assigned person.
?
Once tech is complete he must checkin the ticket.
Status must be updated to pending, Complete-Failed or Complete-Success
I'll provide the database I've been working on which is a good starting point and? has the basic structure in place.
## Deliverables
NOTE: Do not leave just leave your company profile or portfolio.
**To insure me that? you read the complete project listing and you're not a bot Please? start your bid or comment? out with the following term "4U2READ"
Failure to do so will insure I ignore your bid or posting**
Project ID: #3200980