Need a self contained, customer contact database to be used at a small company (do not want to pay for online service, so this will not be in the cloud but a local database). We can use whatever you believe is the simplest to maintain (e.g. Access, MySQL, etc...). It has to run on a Windows based Server. The front-end must be browser based (IE, Safari, Firefox)
All the data will be imported into to db from an excel spreadsheet or csv file. There are only about 1500 records.
There are many customer contact db templates online but I'm looking for something that's customized for us and that can be packaged up and I can easily install on my server. We need to be up and running quickly.
Requirements:
1. Search capability
Search by Serial #
Search by Sales Order "SO #"
Search by Customer Name (wildcard)
Search by Reseller (wildcard)
2. Display results of my search (see UI mockup attached)
Display the individual result base on criteria above
Display list of results
3. Add:
Add new Records (delete or remove records for admin only)
4. Modify:
Modify existing Record contents and save the data back to the database
5. Import/Export/Reporting
Import all my records in
Export all records (for backup)
Export all contents of the results window
Be able to see who made the last change (in a log or history using a time stamp and username)
6. Users
Login by name / password
Admin can reset password
7. Documentation
Document how to take the you deliver and install on my site (Windows 7 Professional) and any other necessary instructions to install.
I am new to this site hence my low bid for the service I can give you.
I am an highly experienced database programmer, my last company ran many large processes solely on databases I designed, developed and maintained. I am looking to complete my first drop quickly and to a high standard in order to get some positive feedback under my belt.
I can consult on the specification, design and develop within 4 days. You then take some time to review and I will a med as necessary. Note if the changes go majorly off spec there will additional charges. I am not a jobsworth so additional fields and a few additional reports would not be a problem.
Please contact me should you wish to discuss this further.
Many thanks for your time,
Amanda Groves.
Techkit.