AutoNumber field type does what?

AutoNumber field type does what?

• A. Automatically increments on each new record
• B. Stores boolean values
• C. Holds dates
• D. Stores large text

Answer: (A)

AutoNumber fields generate a unique value automatically for every new record, typically by increasing the previous value by one. This creates a distinct identifier for each row, which is why it’s commonly used as the primary key. It’s specifically about producing an auto-incremented ID, not about storing other kinds of data. By contrast, a boolean field stores true/false values, a date field stores dates, and a text field stores strings (with large text stored in a long text or memo type).

AutoNumber fields generate a unique value automatically for every new record, typically by increasing the previous value by one. This creates a distinct identifier for each row, which is why it’s commonly used as the primary key. It’s specifically about producing an auto-incremented ID, not about storing other kinds of data. By contrast, a boolean field stores true/false values, a date field stores dates, and a text field stores strings (with large text stored in a long text or memo type).