I have an Access database that I created for a survey in 2010 with data already entered. My company has decided to make some changes to the 2011 survey, so I need to make those changes in the database, including tables and forms. The main changes are the addition and deletion of a few questions and changes to some of the question's response options.
My question is: what is the best most efficient way to create the new database? Should I copy all the forms and tables over to a new database or should I delete the old data in the 2010 database and then make changes?