ABSTRACT
A databases is a structured method of storing data so that it can be retrieved easily. Some databases are created simply to provide single items of information as and when required. This chapter gives examples of how a simple database could be created in Excel for Surveyors. This involved records of sales of houses, including price, number of rooms, and other information. This enables to revise the eventual structure before getting too far into the compilation of the worksheet. The criteria for sorting in Excel for Surveyors, and pointed out that numbers could be sorted in ascending or descending order. The binary numbers are read left to right across each column and are the basis for sorting. Data validation permits you to specify conditions about numbers which are acceptable. Validation allows other conditions about acceptable data, including text length, and also allows one to specify input messages and error messages.
