Records and fields

Although you’re used to thinking in terms of rows and columns in Excel worksheets, when you’re using Excel to track lists of information as in a database program, the proper database parlance is to call the rows “records” and the columns “fields.” Thus, every database record (a row of cells) is composed of the data in each cell in that row (the individual field entries).

Whereas a row (or “record”) can contain many types of data, the data that goes into a particular column (or “field”) is always the same kind. For instance, you might have a database that consists of annual mean temperatures for a range of years.

The first column would be the year, the second the mean temperature for a city, the third the temperature for another city, and so on. For the database to make sense, in each row the year would always have to be entered in the first column. If you entered it in the third column, it would be impossible for you to properly utilize the information because the database would be looking for a temperature and find the year instead.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>