Access 2007
Thinking about Database Design
Plan database tables
Once you have established the purpose, you can begin brainstorming about how to break the information up into the tables your database will need to store the data. Recall that a table is a collection of records, and each record is broken up into the smallest pieces of needed information, called fields.
Since we are planning a database to track our customers, the books we have, and the orders our customers place, we will need a table for each one of these.
Tables for Ready-2-Read Database
TIP: Keep your database usable to others by giving your tables simple, easy-to-understand names.
