How to Change the Order of Fields in a Table in Access 2003

When making an Access 2003 datasheet, there are going to be times when you need to change the order that the fields are arranged. Follow these simple steps to change the order of fields in an existing table in Access 2003. If this is a new Access 2003 datasheet, you may skip to Step 3.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Computer with Access 2003

1. Open Access 2003 on your computer. Under the “File” submenu, select “Open.”
2. Select your datasheet by choosing it in the pop-up menu.
3. Select the row that you would like to move by clicking the row selector. This is the box in the far left hand side of the row.
4. Drag the selected row up or down to its new location. As you move the row, a dark horizontal line will show you where it will be located when you release the mouse button.
5. Release the mouse button. All other rows will move down to make room for the relocated field.

Tips & Warnings

• When moving rows, you are able to move multiple rows. Just drag the mouse over the rows that you wish to move and then release the mouse button.
• There is also the possibility to rearrange rows by number or have them sorted alphabetically.
• Remember to save your work or it will be lost.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.