A table in a database describes one entity (People, Companies, Products,
etc.) the tables are linked by a key field so, for example, that you can
find all the products for a company. Using this, very little information
needs to be repeated.
A spreadsheet is a flat file database. You cannot relate the products to a
company unless all the data is on the same row, and thus repeated.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
Databases are great for capturing and storing data and making reports.
Spreadsheets are great for looking at data and what if's. They also
keep old timers happy because they work and look like the old paper columnar
pads they used.
