View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff
 
Posts: n/a
Default Excel vs. Access

Hi Ric

If a project like that has "one-to-many-relations" or
"many-to-many-relations" then it is database work, not spreadsheet work.
One-to-many relations work like this:

One building, one or more fathers.
One father, one or more children.
One child, one or more books

many-to-many relations in this context:

Many books, many authors.

HTH. Best wishes Harald

skrev i melding
oups.com...
I'm just wondering what the pro's here think the answer would be to
this question.
Would a school markbook program be more suitable as an Excel project or
an Access project?

I know it would be possible to come up with something in either
program, but what would be the more natural and easy fit?

TIA Ric