I'll jump back in and say that in general you should really not be entering
data directly into tables.  That's what forms are for.  You can use
datasheet view of a form if you want to emulate the look of a table.  You
can base the form on a query that is sorted as you choose, or you can use
the form's Order By property.  In either case the new record will be added
to the bottom as the form appears on the screen.  The same thing applies to
a table.  If you are making a one-time (or rarely changing) list such as
departments or something of the sort you may decide to just enter the data
directly in a table, but for day-to-day use a form is the best choice.  I
would suggest that if you need to maintain a sequential order for the
records you should probably use something like an automatically incrementing
number (for example, the first record would be 0001, the second 0002, and so
forth), or maybe a date or time stamp.  For reasons already mentioned,
autonumber is not a good choice.