The Total solution for NCERT class 6-12
When you want to increment the number automatically as you add or delete the records. AutoNumber data type is preferred. Also, if the table does not have a primary key, then AutoNumber uniquely identifies the record.