1. Home
  2. MS Office
We are reader supported and may earn a commission when you buy through links on our site. Learn more

Set Field Values To Be Inserted As Unique [Access 2010]

Access 2010 places simple field validation options on the ribbon, so users can easily make a field’s content Indexed, Unique or Required, By enabling option Unique prevent others from repeating  data in the defined table’s field.

To begin, select the table’s field for which you need to change or add validation rule, head over Table Tools Fields tab and under Field Validation group, enable Unique checkbox.

242d1273659220-set-field-values-inserted-unique-

Now on entering same values in selected field, Access wont let you to save it.

241d1273659218-set-field-values-inserted-unique-

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.