Another way (if you are not familiar with SQL) is to use the Column Headings on the Property Sheet and enter the fields in the order you want them to appear.
Eg. In Design View click on the Field that has the Column Heading and enter the column headings you want in the Column Headings property...