We have an access database with 140,000 entries, and 10 fields (name, address, etc). We send 2 mailshots every year and then depending on the response need to make the following entries into the database with a FAST and EASY method:
# Purchase (record paying customer and payment method)
# Kept Goods (record non-paying customer and schedule reminder)
# Returned Unwanted (customer did not want goods)
# Returned Wrong Address (customer needs to be removed from the database)
Our company also needs to start tracking these returns for the database over several years.
We imagine a barcode tracking system to speed things up but we would need advice on how to implement this.
There is no reason to keep an access database if another system like sql will do the same job.
Creative solutions are required, and good english required.
