Keep tracck of all added and deleted records

Hello Dmitry, Derek, Sibprogsistem, thezimguy, ehwagner and all MVD lovers.

I have created a project on employee leave. when my employees request leave, I add a new record to the database and when they return, I delete the record from the database.

I want to keep records all leave requested and return in a table. That is, I want keep all added and deleted leaves in another table.

I want a sample project. Thank you in advance family