Create a field that automatically generates numbers

1. Open a table in Design view.
   
   
2. To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.

   To add the field to the end of the table, click in the first blank row.

3. In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.
   
   
4. In the Data Type column, click the arrow and select AutoNumber.
   
   
5. To create an incrementing AutoNumber, leave the property settings in the bottom part of the window as they are (the FieldSize property is set to Long Integer and the NewValues property is set to Increment by default).

   To create a random AutoNumber, in the bottom part of the window on the General tab, set the NewValues property to Random. For more information on the types of AutoNumber fields you can create, including fields for database replication, click .

6. Set the other field properties, if desired.

   How?