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

Save

After creating an Access table, you might realize that you'd prefer the fields to be in a different order. This is easy to fix. These instructions are for Access 97.

Things You'll Need

  • Microsoft Access
  • Open your database file in MS Access.

  • Use the F11 key to open database view.

  • Click on the Table tab. A list of tables appears.

  • Select the table you want to work with and click Open. The table will open.

  • Locate the field that you want to relocate. Select the field label (name).

  • Drag the column to its new location, and release the cursor.

  • The column (field) is now in its new location and the order has been changed.

Tips & Warnings

  • In Access, a database is made up of various "tables," but each table is probably what you'd think of as a "database" - it's a collection of records.
  • If you typically work with some fields more often than others, it will be convenient to drag those fields to the beginning of the table. This arrangement reduces your scrolling.
  • You can move the fields back to the original placement, or to any other placement, by dragging and dropping.
Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!