the order of columns in a table has no intrinsicilly importance.
logically it its 'nice' to have the PK the first column(s), but its not required.
the order of columns in a query is determined by the order the columns appear in the column specification (unless you are using SELECT *
SELECT my2ndColumn, My4thColumn, My3rdColumn, My1stColumn FROM MyTable
again the column order is irrelevant (unless say you are using an order by clause in whcih case I guess it makes sense to place the sorted columns in order at the front of the column list, but thats only if you are viewing query results in a query browser as opposed to consuming the data in an application, where the application front end handles the actual display of the query results.
I guess the smart alexk response would be to design your tables fully AND properly first time around
I'd rather be riding on the Tiger 800 or the Norton