Sorting Records

In Access 2000 sorting records may seem confusing at first. This free lesson offers step-by-step instructions.

Working in Datasheet view

When working with tables, you work in Datasheet view. In Datasheet view, you can add, edit, and view data in a table. You can also check spelling, print the table data, filter and sort records, change how the datasheet is displayed, and change the table structure by adding and deleting columns.

Because it's easiest to see the results of a sort in Datasheet view, let's convert a form (Form view) to Datasheet view.

To choose Datasheet view:

  • Open the desired form or table you want to work with.
  • Choose Viewlesson actionDatasheet View from the menu bar.
  • The form records are now displayed in Datasheet view.