O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

Setting a Criteria Range

The data form that you worked with in Hour 21 can be an easy way to enter, view, and delete records. As your database grows, however, you might need a more efficient way of maintaining it.

Excel provides an alternative method for finding, viewing, and deleting records. You can set up a criteria range, a range of information separate from the data form criteria. This criteria range allows you to easily inspect data from a large database.

The criteria range you use to view the database can contain comparison criteria, such as the type you use in the data form, or computed criteria. A computed criterion finds the result of computing several values in the database, such as EmpPeriod*2.

The criteria range is a special section ...

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