Question

write the difference between number and autonumber data typeer

Answer 1

The AutoNumber data type automatically generates a unique number for each record that’s added to a table, and is commonly used for primary key fields. Seldom, if ever, should the value of the AutoNumber field be shown to your database users. If the value of the AutoNumber field is relevant to your Access forms and reports, then it may be that you shouldn’t be using the AutoNumber type, since there will frequently be gaps in the numbers.
................

Hope it helps you..........
Pls Mark as Brainliast

Answer 2

Number type is used to store data the value of an integer or float type which will depend on the specified decimal precision value.

On the other hand, Auto Number has all the calculated values by the system that is referred to as Auto-increment values.

You can’t change these types of value and have no control over them.