Page 5 of 11PREVNEXT

Design tables for a new Access 2007 database

Grouping data

Sets of unique information

As you list the data you want to capture, you'll see it naturally falls into one or more subject matter categories or groups. For example, your information may group itself like this:

  • Asset data, such as models, purchase dates, and costs.
  • Support data — who you call for help or spare parts. This category will probably include company names, addresses, phone numbers, and contact names.
  • Supplier data, which looks a lot like support data because it includes companies and contact names.

Grouping is important because each category can correspond to a table, such as Assets, Support, and Suppliers. Your groups may not result in a complete list of tables, but they're a good starting point. Just make sure each group contains unique data — just the asset information in one group, only the supplier data in another, and so on.

Page 5 of 11PREVNEXT