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.

242d1273659220setfieldvaluesinsertedunique Set Field Values To Be Inserted As Unique [Access 2010]View in gallery

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

241d1273659218setfieldvaluesinsertedunique Set Field Values To Be Inserted As Unique [Access 2010]View in gallery