It doesn't affect the order in the table, but it does allow you to order the
data as you please. It's probably worth mentioning at this point in time
that data in an access database actually has no particular order, even when
you put an index on it.

If you enter ten names into a access database, and then go back and edit
several of the names, it's very possible that the physical order of the
names will change. I repeat, there is no particular physical order that you
can rely on in MS access.
If you want to see data in a particular order, then you use a query and set
the sort order in that query. This is the only reasonable way in which you
can set your order of data in an access application. The physical order is
completely insignificant, nor can it be relized upon.

So when you have a combo box, a form, or exporting data, you simply use a
query and set the sort order in that query, and you'll never have to worry
about the actual water of the table (which cannot be relied upon as
mentioned anyway).

For report's in MS access, you simply click on the Sorting and grouping
button and use that.

Thus, as a general rule who you can't use and rely on the physical order,
but you can use the high speed high performance indexing that MS access has
to ensure that you get good performance when you do set the order.