Add multiple record quickly (details inside, void where prohibited)

[eepok]

Situation
My database stores course information for faculty in my department and prints out various reports based on that information.

The 2 mandatory fields in the form are [AcademicYear] and [Instructor] as they create the potential for classes to be added to the curriculum.

Question
Is there a way to add multiple records to the db based on the which year and instructor combinations were use prior?

ex.
2007/2008, prof-a
2007/2008, prof-b
2007/2008, prof-c
2007/2008, prof-d

This represents the 2007/2008 school year where professors a through d taught courses. Is there a way to add records for another academic year so that:

2008/2009, prof-a
2008/2009, prof-b
2008/2009, prof-c
2008/2009, prof-d

appear with just the press of a button?

I don't know if I'm being clear enough.

 

[gemma-the-husky]

yes

get an select query that selects this years courses

put this query into an append query, and add all the details backi n, jusdt changing the academic year