Have completed the GUI interface. http://www.skylight.science.ubc.ca/admin.htm
It has a basic layout but everything works!!! Total time taken is roughly 1 week. I have also started designing dynamic components that i will include in the template that Darren is designing fro the website. Now i am starting to analyse the survey results in excel.

Well, the third design is underway. I have designed all the cold fusion componets to the third phase. Since the database has changed significantly, much of the cold fusion code had to be rewritten. The front end of the site is scheduled to start sometime next week. I am finishing up the GUI interface to update the website dynamically. Challenges overcame during the GUI interface: linking to two or three tables at the same tim (nested queries), adding multiple rows of data on one submission, file uploading and deleteing, retaining variables for updating. The last part of the GUI interface is almost finished, however it may need a more attractive layout and look, but the interface is fully functional.