Storing, retrieving, finding and deleting details from Access Database

[Victor_TanTW]

Hi all. I'm building a buffer reference list like for keeping track of the books taken out. Here's the step-by-step process.

1. Item has been scanned by reader.
2. Deduct one item from inventory program and add the tag ID and content to reference list.
3. If item is not the intended item, returns back to the inventory.
4. Reader detects the same ID and content.
5. Search for the ID in the reference list.
6. Delete the data from the reference list and add one item back to the inventory program.
7. Clear all data in the reference list upon program shut down.

For this case, can I use MS Access Database to handle this? If yes, how can I add the data into the database automatically whereby a tag is present? Is there a way to search for data if the same ID and content is display? Is there a way to clear all data in the database upon program shut down?

Thank you.