When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

A) reuses the same value in the next new record
B) does not reuse the value
C) changes the AutoNumber values in all other records
D) prompts you for the value of the next new record

AutoNumber Field

A field in a database that automatically generates a unique number for each record, often used as a primary key.

Delete Record

The action of removing a data entry or record from a database, application, or digital ledger, making it no longer retrievable within the system.

Reuses Value

The practice of using an already defined value or resource multiple times within a program or system to optimize performance or maintain consistency.