Thinking about Database Design

Learn what database design elements to consider, as well as how to create an Access database, in this free lesson.

Plan database tables

Once we've established its purpose, we can begin brainstorming about how to break up the information into the tables the database will need to store 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.

Because we're 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 DatabaseTables for Ready-2-Read Database

TIP: Keep your database usable to others by giving your tables simple, easy-to-understand names.