Complete/Modify Repair Shop Access Database

Completed Posted Feb 22, 2010 Paid on delivery
Completed 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

? Email

? 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**

PHP

Project ID: #3200980

About the project

15 proposals Remote project Active Feb 25, 2010

Awarded to:

wjscomputer

See private message.

$63.75 USD in 10 days
(18 Reviews)
3.4

15 freelancers are bidding on average $86 for this job

fastudiovw

See private message.

$68 USD in 10 days
(584 Reviews)
7.2
brightsolnslx

See private message.

$42.5 USD in 10 days
(289 Reviews)
6.3
VedAlek

See private message.

$68 USD in 10 days
(48 Reviews)
5.2
developernoman

See private message.

$42.5 USD in 10 days
(38 Reviews)
4.4
handygeek

See private message.

$85 USD in 10 days
(4 Reviews)
3.8
gendolftsl

See private message.

$80.75 USD in 10 days
(29 Reviews)
3.6
bendickson

See private message.

$63.75 USD in 10 days
(4 Reviews)
3.2
LMAFla

See private message.

$255 USD in 10 days
(6 Reviews)
3.0
manojyohannan

See private message.

$85 USD in 10 days
(18 Reviews)
3.1
mlmdeveloperssl

See private message.

$76.5 USD in 10 days
(3 Reviews)
2.7
SilentCodingOne

See private message.

$42.5 USD in 10 days
(4 Reviews)
2.5
moizsr

See private message.

$85 USD in 10 days
(1 Review)
0.7
lhartonoeu

See private message.

$169.15 USD in 10 days
(0 Reviews)
0.0
XBTC

See private message.

$63.75 USD in 10 days
(0 Reviews)
0.0