Is it possible to set up a query to move records from one table to another?

Yes look up Append queries, you might want to include a Delete as well if you want to remove the entry from the original table.