Access: Create an auto-increment field in a table in Access 2007

Also learn how to create an auto-increment field in a table in Access 2003/XP/2000/97.

Question:  In Access 2007, how can I create a numeric field in a table that automatically increments?

Answer:  To create a numeric field that automatically increments, you need to create an AutoNumber field.

To do this, open your table in design view by right-clicking on the table name in the left window and selecting Design View from the popup menu.

Next, create a new field in your table. Select the data type called "AutoNumber".

In the example below, we've created an AutoNumber field called Supplier_ID.