The AutoNumber field doesn't need to begin with a value of 1. You can override Access's default autonumbering scheme to better suit your requirements.
A great feature that Access brings to the table-creation process is the AutoNumber field. This field type places a value of 1 in the first record and automatically increases the value by 1 as records are added. It doesn't contain any significant or meaningful data. Its basic purpose is to become the key field and thereby provide uniqueness to the data records.
Just plop a field into the table design, and designate it as an AutoNumber field. Typically such a field has a name with ID or Num in it, such as CustomerID or RecordNum. Note that a table can have only one AutoNumber field.
All in all, AutoNumber is a great feature, but there is one gotcha: the value always starts at 1. Often, this isn't an issue because the field value really is unimportant. The fact that the values are unique is what matters more. But what if you need to use a self-incrementing number that starts at a different value? Can you do this? Of course!
On the occasion of the presentation of the 2009 Pugsley Medal for my years of conservation and park advocacy, I had to prepare an acceptance speech to a prestigious national audience, many of whom were past recipients of the award. The principal guideline for my speech was the long list of my life’s work to appear in the evening program. The list was complete, but it did not answer the question that often haunts my own deliberations. Why? How didI come from Democratic Party activist and businessman to conservationist?
As is often the case, the answer entails sheer happenstance. Sometime in the 1990s I happened to come upon an old issue of Life magazine, one dated August 5, 1940, six days before my birth. I flipped through it, and found among the slightly yellowing pages an article on American vacation venues. Prominently featured there were two photographs in color—unusual for the magazine at that time—scenes of Glacier National Park. I was immediately struck, and I wrote a poem about what might have occurred in those days leading up to my birth, something that might have set the stage for my journey to Glacier, and thus for my future work to save a few more “last best places.”
“In time, who knows, the agitation of inexperience would have passed …”
Puberty is a time when bodily changes occur more rapidly than during any other period of life, except in the womb. This rapidity of change naturally brings with it enormous psychological upheaval. And yet the distinction between the states of mind associated with the latter part of latency (ten or eleven) and those associated with the early part of puberty (twelve or thirteen) is a complex one; and one which is not necessarily as closely linked to biological changes as is sometimes supposed. The physiological changes of puberty tend to occur earlier than the emotional ones, especially in girls—many of whom are beginning to menstruate and develop secondary sexual characteristics by the age of ten, or even nine. Traditionally the physiological and the emotional were felt to coincide. But now a discrimination is made between the kinds of bodily changes which would seem to herald the onset of puberty and the mental and emotional shifts in states of mind which psychologically mark the transition from one phase of life to another. The physical ability to have a baby is wholly distinct from the emotional readiness to have a boyfriend. Thus although the statistically and chronologically recognized years of puberty may generally fall roughly between the ages of twelve and fourteen or fifteen, an understanding of where the “psychic” part of this psycho-sexual change finds its place in the overall development of the personality, or fails to find it, is a different matter. For, as usual, it is a question of states of mind as well as of stages of development.