Explain the process you created to ensure that when an employee clocks out, the time is recorded with the most recent time record instead of overriding a previous time

What will be an ideal response?

I broke up the clock out process into three different queries:
• A Make-Table query that creates a temporary table to store the EmployeeID and the most recent Clock-In record with an empty clock-out value for the user currently logged in to the system.
• An Update query that updates the clock-out field with the Now() function in the tblClockIn-Out table for the record matching the one in the temporary table created with the first query.
• A Delete query to delete the record in the temporary table created by the first Make-Table query.
I then created a macro to run each of the queries in the appropriate sequence when the clock-out button was clicked.