Describe the general procedure for archiving obsolete data.

Question

What will be an ideal response?

Answer 1

The following describes the process for archiving data:Back up the database first—this is a must.Create a select query to set up the criteria for selecting the obsolete records. Test it to make sure it selects the correct records. Then convert it to a make-table action query to create a table to store the obsolete records. Run the query to create the new table. You do not need to save this query because you only need it once to create the table.Modify the new table to add a primary key. This prevents you from adding duplicate records in the future.Create a select query that will select obsolete records and then test it. Convert it to an append action query and save it without running it. Use the query when you want to move obsolete records to another table. Use parameters to make it more general, if necessary. Save and run this query on a regular basis or as needed.Regularly check the history table to make sure the records have been successfully appended before the next step.Create a delete action query to delete the obsolete records from the original table. Run this query only after the append query as needed.