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 ...