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.
// Related Posted - GOOGLE!
Related Websites
- Adwords Key Phrase Research For Inexperienced Persons While you embark to your first PPC adventure, you wish to have to keep a small number of keywords at...
- State of the climate: warming, with no sign of waning [/caption] Every year since 1990, the National Oceanic and Atmospheric Administration has released an annual report detailing the state of...
- World simmers in hottest year so far [/caption] WASHINGTON – The world is enduring the hottest year on record, according to a U.S. national weather analysis, causing...
- Why is it Bad to Cancel a Credit Card? Unless the idea of streamlined credit you have in your head is having 8 credit cards in a single wallet,...
- Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
