Barcode scanner - status update

You could create a "Receive Order" table.. with a field for the Serial Number.   Then .. position the cursor within a row on that table and use the bar code scanner to scan the what was recived.  You will either have to tab off that field .. or click a button .. then have an Trigger After Update that searches your above table.. if it gets a match, it can set the status to Delivered.. 

I am not sure what you want to happen if it does not get a match.. perhaps an alert message.