In/Out Device tracking system

Hello everyone! I am very new to Microsoft excel. I have a created a list of all of the devices my department uses for testing. What I am looking to do is have a barcode scanner read the barcodes I have created and prompt the user is the device is being "checked in" or "checked out." The user will click on the correct answer and then it will be time stamped in a separate column already labeled "date and time."

Is this even possible with excel? If so, how would I go about getting help with this?

Thank you