O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Other Ways to Find Data

The Find and Replace features work well on individual records, but there are several more sophisticated ways of locating data in your database, as you'll learn in upcoming lessons. They include:

  • Sorting— Rearranging the data on-screen so it's easier to skim through the list to find what you want. See Lesson 18.

  • Filtering— Narrowing down the list to eliminate the data you know you don't want to see. See Lesson 18.

  • Indexing— Defining other fields besides the primary key that you want Access to keep track of (that is, keep an index of). Indexing is optional, but in large databases it makes your searching and sorting faster. See Lesson 18.

  • Querying— Creating a more formal filter with complex criteria that you can save ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required