How do you save queries and forms but start over w/ all new data

[MO]

I am very new to Access I have a database that has 2007 data in it. I want
to keep all of the forms and queries but enter 2008 data. How do I go about
creating a new database but keep all of those forms and queries?

 

[Jerry Whittle]

You don't. Creating a new database for each year or month is almost always a
mistake.

Instead have a date field in the table for the records which would define
what year's data is what. Then filter on that date field to return the 2008
data or what ever year(s) you want to see.

A good way to do this would be with the Year function on that date field.
Something like below in the field of a query will show the year:

TheYear: Year([TheDateField])

Then you could put 2009 in the criteria to return only 2009's records.