The AutoNumber field is another specialized Number data type. When an AutoNumber field is added to a table, Access automatically assigns an integer value to the field (beginning at 1) and increments the value each time a record is added to the table. Alternatively (determined by the New Values property), the value of the AutoNumber field is a random integer that is automatically inserted into new records.

Only one AutoNumber field can appear in a table. Once assigned to a record, the value of an AutoNumber field cannot be changed programmatically or by the user. AutoNumber fields are equivalent to the Long Integer data type and occupy 4 bytes, but display only positive values. The range of possible values for AutoNumber fields range from 1 to 4,294,967,296—more than adequate to use as the primary key for most tables.

• A login system with PHP and MySQL Many interactive websites these days need a user to log in into the website's system to provide a customized experience...
• The value of photographic prints Stephan R. Lewis is a professional photographer. He accepted to share his knowledge with us, with this exclusive article. The...
• The interaction between insight, value and integration Here's a diagram depicting various interactions involved in the modern marketing function. I don't quite know what to call it....
• The 7-Day Turnaround, Day 1: Take an Inventory of Your Finances This is the first in Frugal Dad's week-long series, The 7-Day Turnaround: One Week to Change Your Family's Financial Destiny....
• Which Classic and Modern Commemorative Coins are Worth Collecting? The answer to the question of which classic and modern commemorative coins are worth collecting is subjective. There are many...