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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
