A table has several fields related to computer data. You want the serial number (Sr. No.) field to increase by one every time yo

Question

Rudik [331]

3 years ago

6

A table has several fields related to computer data. You want the serial number (Sr. No.) field to increase by one every time yo

u add a new record. Which data type would you use for the Sr. No. field?
autonumber
memo
null
BLOb

Computers and Technology

2 answers:

Scilla [17] · Answer 1 · 2022-03-23T10:33:52+03:00

Scilla [17]3 years ago

6 0

Autonumber
-----------------------------------------

Korvikt [17] · Answer 2 · 2022-03-23T12:06:09+03:00

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.