Tables in Access are not kept in order. The information is stored on a first
come first served basic.
What you do is sort it when you display it. So, if you want to see a list of
people in alphabetical order, you use a query to select them, sort them and
then display them in a form or a report.
As for the numbers, you may have to create an update query to re-number
them - it depends on what you want to do. Just don't make the number the
primary key.

Mike L
I have a free tutorial on Access that you might want to check out.
It's at www.profsr.com  Profsr.com Tutorials