| Avoid
creating multiple fields that repeat the same kind of data. |
| | This
table design is hard to use: -
It
is hard to search or sort-data could be in any of the fields. -
It is difficult
to create a query that returns only Yes responses, because that data could be
in any of three fields. |
| | |
| Use
the following table design instead: |
|
|
Each
type of information is contained in only one field - searching, sorting, and calculating
data is much easier.
|
