Database Answers A Handshake with a Customer

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Customers and Jobs 
Back to the Data Model
Subject: I'm running a PC Repair business and I need a customer/job database

Question: Hiya, I have been running my mobile PC repair business for nearly two and a half years and
have been keeping customer records in Excel,
it's clunky, but I can produce invoices as I need them.
It's really a job database with customers appearing several times if I have had repeat business.
There is no easy way to tie all the jobs for a single customer together, which makes my work harder and
the service the customer receives isn't as good as it could be either.

I would like to be able to do a quick check when a customer calls and know their details and the work I
have . for them in the past.

I have about 1,000 records that I would like to import from Excel.

Ideally as I am mobile, I would like to have a web interface, so if necessary I can login and obtain
this information while I'm out and about (I have a hosting account that has all the necessary SQL abilities).

I don't mind paying a reasonable amount for a good solution and I can see that you have a huge quantity of sample databases that might fit the bill,
but I wouldn't know whether I had chosen the best one from your list.

It has to be easy to use, with a simple interface, so that rather than manually writing a customer job sheet then having to input it into Excel,

I am more inclined to type their details straight into the database.

I guess my questions are therefore:
1. Do you have something on the shelf that would fit?
2. If not is there a way to get you to create something for a reasonable price?

Thanks in advance

Gary

B. Barry says the Things of Interest are :- 1. Customers 2. Invoices 3. Jobs 4. Others to be determined C. The Business Rules are as follows :- 1. To be determined.


© DataBase Answers Ltd. 2011
About Us Contact Us