I need a very simple database created. Option that I am looking for is access. My requirement is given below and budget for the project is $30.
I get a list of few thousand e-ma-ils everyday which I need to check for duplicates, unsubscribe, bounces. Here is the project detail.
1. New e-ma-il List received daily with two columns e-ma-il address and source of e-ma-il
2. Add all the e-ma-ils to the main e-ma-il database and remove the duplicates.
3. Some e-ma-ils with specific domain names needs to be deleted from the Master List. Example if an e-ma-il address is , then this e-ma-il needs to be removed from the database as we don't want any e-ma-il with "[url removed, login to view]". The list of domain names is updated on a regular basis which we don't want in our database and thus there has to be form / table where i can update the same.
4. After all this is completed, say my database is left with 1000 e-ma-ils and I need to send e-ma-ils to 200 out of these 1000 e-ma-ils today and thus I should get an option to import these 200 e-ma-ils to an excel sheet. As soon as I import these for sending out, the column next to these e-ma-ils should get updated with today's date and then we are left with 800 unsent e-ma-ils.
Next day the same process happens and we have added 500 new e-ma-ils to the database after removing duplication etc and now we are left with 1300 e-ma-ils. Thus now I should be be able to send 600 e-ma-ils and these 600 should get updated with today's date so that tomorrow i only get those e-ma-ils which have not been sent out.
The e-ma-ils that I am sending out should also cross check themselves against two separate tables called bounce table and unsubscribe table and if there are any e-ma-ils which are in these two table, those would not get imported for sending out.
I need a very simple user friendly with a GUI access database. My e-ma-ils would be over 100,000 per day and thus if you think I should go for some other option then please do recommend. My budget it $30 for the project.