When you delete a record containing an auto number field, access discards the value in the auto number field and does not reuse the value.
What is an auto number field?
- For each entry, an auto number column generates a unique, automatically incremented number.
- When you need a unique identifier for each record or when utilizing a formula in the primary field, the auto number can be useful.
- AutoNumber is a form of data used in Microsoft Access tables to generate a numeric counter that is automatically incremented.
- It can be used to build an identity column that uniquely identifies each table entry.
- Each table can only have one AutoNumber.
- In Access 2.0, the data type was called Counter.
- When you remove a record that has an auto number field, Access discards and does not reuse the value in the auto number field.
Therefore when you delete a record containing an auto number field, access discards the value in the auto number field and does not reuse the value.
Know more about auto number fields here:
https://brainly.com/question/2526290
#SPJ4
