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


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


You May Also Like

Related Searches

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