Page 4 of 11PREVNEXT

Choose between Access and Excel

Relational structures add power to your data

We're not kidding about powerful.

A relational data structure has several advantages:

  • It lets you answer important business questions, such as who bought the most (or least) of your product last week. The figure above shows you how this can work.
  • What's more, using separate tables can make your data easier to manage, because each table holds just part of your information.
  • And finally, a relational structure helps keep your information accurate, because you can prevent users from entering data in the wrong table.
Page 4 of 11PREVNEXT