Access Table

Here is what happens: I generate a coupon with a bar code on it. I have a computer with a bar code scanner - it scans the coupon directly into the access database as a simply number or text. If the number is there, it marks the record as true. Then next time someone tries to redeem same barcode the database provides a dialog box stating already redeemed. This time I need to mail the coupons out and when they are redeemed, I want the database to CREATE a RECORD with a field (simple ascii) for the number and a field marked TRUE. Can you do that? Yes or NO - I need to do it right away.