Asked by Andres Soler on Jun 09, 2024
Verified
Which data type is used for sequential integers controlled by Access?
A) Number
B) AutoNumber
C) SeqNumber
D) Integer
AutoNumber
A data type used in databases that automatically generates a unique number for each new record added, often used as a primary key.
Sequential Integers
A series of numbers in which each number increases by a constant value from the one before it.
- Understand the significance and operation of data types within database management systems.
Verified Answer
ZK
Zybrea KnightJun 15, 2024
Final Answer :
B
Explanation :
AutoNumber is the data type used for sequential integers controlled by Access. This type is specifically designed to create a unique identifier for each record in a table and is automatically generated by Access, so it is the best choice for this purpose. The other data types listed (Number, Integer, SeqNumber) are not specifically designed for this purpose and may not provide the same level of control or efficiency.
Learning Objectives
- Understand the significance and operation of data types within database management systems.