eHow launches Android app: Get the best of eHow on the go.

How To

How to Sort Records in a Microsoft Access Table

Contributor
By eHow Contributing Writer
(7 Ratings)

Sorting records simplifies information retrieval and makes it easier for you to arrange your database content. These instructions are for Access 97.

Difficulty: Moderately Easy
Instructions

Things You'll Need:

  1. Step 1

    Open your database file in Microsoft Access.

  2. Step 2

    Use the F11 key to open the Database window.

  3. Step 3

    Click on either the Form tab or the Table tab, depending on which view you want to work in. A list of forms or tables appears.

  4. Step 4

    Select the table or form you want to work with and click Open.

  5. Step 5

    Click the field that you want to use for sorting records.

  6. Step 6

    From the Records menu, click Sort Ascending if you want to sort from 0 to 9 or from A to Z.

  7. Step 7

    Click Sort Descending if you want to sort the field from 9 to 0 or from Z to A.

Tips & Warnings
  • To undo a sort order, click Remove Filter/Sort in the Records menu.
Subscribe

Post a Comment

Post a Comment

Related Ads

  • Have you done this? Click here to let us know.
I Did This
Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Computers
eHow_eHow Technology and Electronics