Question

The. Generates a sequential number whenever a new record is added to a table

Answer 1

Answer:

AutoNumber generates a sequential number whenever a new record is added to a table .

Answer 2

Answer:

The Auto Number / SERIAL data type generates a sequential number whenever a new record is added to a table

Explanation:

• AutoNumber is a datatype which is  used in Microsoft Access tables to generate an automatically incremented numeric counter.
• AutoNumber may be used to create an identity column which can identify each record of a table uniquely .
• One AutoNumber is allowed in each table. The default AutoNumber type is a start + increment counter, with a start value of 1 and an increment of 1.

• The SERIAL data type also stores a sequential integer that is automatically assigned by the database server when a new row is inserted in the table.

• The default starting serial number is 1, but one can assign an initial value n during creation  or alteration the table.

• We must specify a positive number for the starting number.

• If we specify zero as the starting number, the value that is used is the maximum positive value that already exists in the SERIAL column + 1.