Sorting Records

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

Table and form concepts

In previous lessons, you learned to open an existing table and add, edit, and delete table records. You also learned to open an existing form and add, edit, and delete form records.

Tables are the building blocks of any database. Forms are simply a way of customizing the display of data in a table, making it easy to enter and view data.

Different methods of accessing data require that you work in different views. When working with tables, you work in Datasheet view. When working with forms, you work in Form view.

Important pointIn this lesson, you will learn to sort and find records.

Using a database, finding information is quick and easy. Depending on what you want to know, Access offers several search methods ranging from the simple to the complex.