I have a growing list of customers with there details and reference to the paper form of the invoice number along with the cost of the service.
The receipts are in paper form and contain information such as the service performed, the way paid, when the service was started/done, customers signature, and the costs of the service.
I would like to have a database either via online or software to purchase that will be able to just keep the customers contact information along with the ability to view order numbers and dates associated with them. Example - I look up John James and it shows on 05.05.08 he had a service performed and it shows that the invoice# is 125. This way i can know where to pull this up and in what time frame to look for in my filing cabinet.
So the database has to be able to :
1. allow me to add/delete customers
2. allow me to view all the customers and there details (address, #)
3. view reports which will show me things such as the amount of customer in one zip code or the annual income from all invoices totaled
Do any of you have a recommendations on software or whats the easiest and most cost effective way of handling this?
I might want more than 1 person be able to view this in the future (thus my thought on online database with user credentials) or i was even thinking of making an access database.
The receipts are in paper form and contain information such as the service performed, the way paid, when the service was started/done, customers signature, and the costs of the service.
I would like to have a database either via online or software to purchase that will be able to just keep the customers contact information along with the ability to view order numbers and dates associated with them. Example - I look up John James and it shows on 05.05.08 he had a service performed and it shows that the invoice# is 125. This way i can know where to pull this up and in what time frame to look for in my filing cabinet.
So the database has to be able to :
1. allow me to add/delete customers
2. allow me to view all the customers and there details (address, #)
3. view reports which will show me things such as the amount of customer in one zip code or the annual income from all invoices totaled
Do any of you have a recommendations on software or whats the easiest and most cost effective way of handling this?
I might want more than 1 person be able to view this in the future (thus my thought on online database with user credentials) or i was even thinking of making an access database.