I am wondering if there is a way to archive prior year records or move them to another table?

So by default when a table reaches 10,000+ records QB options to not display them right away (for speed and performance reasons).

However, What you can do is set up a  report that filters out old records, and then set that report as the table homepage. 

Then every time somebody clicks the table they see the filtered report that in effect "archives" all the old records.

If you need more details on how to set that up, just post back with your questions or where you get stuck.

When the table home page is set to the default report, you get the default behavior.

The default behavior is as Matthew described,

But if you change your table home page report to be a report, even the List All report, then it will continue to behave as it used to with the full report and a filter box. The assumption is that if you consciencly choose the list all report and knowing choose to take the risk of slowing down your app, then that is your choice.