I have some new tables that need to be added to a mysql database, claimtamer.com. These tables (10 in total) are in both microsoft access or excel formats. I also need to make some minor changes to the format of the report and the main screen and add some fields to the report. One new field will be a calculated field (summation of snowfall accumulation over multiple days). I will also need a procedure for all tables in [url removed, login to view] to be updatable through a bulk update and an individual record update (search to find a particular record, retrieve it, edit, add or delete) and will need some kind of user interface to do these updates. I also want no reduction in report retrieval speed after all the tables are added. As you get into the project, please look at the current system and give me your opinion on any ways to improve the system. If we agree, you can implement your suggestions and we can test the solutions, modifying as needed.
Most important of all - I would like a daily status update and an email within 24 hours if I have a question.
I have all the new tables and the updates to how the report should look and can upload all that to you. All I need from you is make the changes.
I would like this update completed in 7-10 days after programmer is selected. Thank you.