Microsoft Access Action Queries
Action Queries can change the data in the Tables. For example, an Update Query can find any movie released before the year 2000 and set the rental price.
The other Action Queries include Append (add more Records), Delete (subtract Records), and Make Table (Copy the Records from a Query into a new Table.)
Action Queries simplify the task of archiving the old movies.
I have a video on YouTube that shows these steps:
Buy the books at Amazon: https://thecomputermama.us/books-page/
Please consider my course on UDEMY, The Beginning Guide to Microsoft Access. This course is free.