The Basics of Database Design 72 The Database Wizard leads you through a series of steps in which you can add fields to the tables the template provides and pick a style and format for your forms and reports. After the default set of tables and other database objects have been created, you can make modifications to the structure of the tables or the design of the forms and reports. In later chapters, we'll describe many of the tasks related to work you'll do to customize a database you create from a template. For more information: See the topic "Creating and Working with Databases and Objects," in the Microsoft Office Access 2003 As- sistance, available through Microsoft Office Online. Also see the online training "Introduction to Databases," available through Microsoft Office Online. Chapter Summary Access databases are relational databases. Each table should store data about a distinct subject and be linked to other tables through relationships that tie the data together. Tables can have a one- to-one, a one-to-many, or a many-to-many relationship. Before creating a database in Access, you should gather information about the requirements for the database, determine what the people who will use the database expect it to do, and design the database logically, identifying the subject for each table, the fields that each table will include, and the relationships between tables. You should review each table to be sure that you've removed the possibility for redundant data as much as possible from the database. The efforts you make in planning your database up front will yield benefits later when you're implementing your database in Access because you'll have clear goals for what the database is intended to do.