I haven't found a way to do this well. If you haven't put the data in yet, then you can just right-click on the table name and choose Edit and retype the names and data types in design view. However, if you do this once data has been entered, everything is undone once you save and the table goes back to the way it was.
You might consider making a view or query of the table, with the fields in the order you want. Or export the table to a spreadsheet, rearrange the data in the spreadsheet, then bring the spreadsheet back into the database as a new table and delete the old one.
This was first published in November 2006