Preventing Duplicate Records in Access
I have a situation where I need to prevent duplicate record entry based on two fields. I found this solution here:

In table design, open the indexes Window, and add a new index. To
indicate that it is a single index with multiple fields, enter the fields on
consecutive rows, and leave the index name blank on all but the first row.
With the first row selected, set the Unique property to Yes.

Archives