Computers and Technology

Question

A table has several fields related to computer data. You want the serial number (Sr. No.) field to increase by one every time you add a new record. Which data type would you use for the Sr. No. field?
autonumber
memo
null
BLOb

2 Answer

  • autonumber
    -----------------------------------------
  • The answer is Autonumber.

    AutoNumber data type is commonly used for primary key fields and it automatically generates a unique number for each record. This data type stores an integer that Access increments automatically as you continue adding new records. Primary keys are great but Auto numbers are also important for insuring that records are uniquely identified.  


NEWS TODAY