Share this Page URL

Chapter 2. The Basics of Database Design > Principles of Relational Databases - Pg. 30

The Basics of Database Design 30 The data in a relational database is organized in tables, each of which stores data about a distinct subject. Tables contain fields and records; fields are arranged in columns, and records are arranged in rows. Each table includes a primary key, which is a field containing a value, such as an ID number, that uniquely identifies each record in that table. You bring together related data from separate tables by defining a relationship between the tables using a field that's common to each table. In Chapter 1, we used an example of customers and customer orders to illustrate a relationship between data. A customer's name, phone number, billing address, and similar data is stored in one table. The details about the orders each customer places are stored in another table. Customer information and order information are joined through a relationship between the tables. Let's open Access and explore the nature of table relationships some more. Here are the steps to follow. View table relationships 1. Start Access and open the file HelloWorld2.mdb in the Chap02 subfolder, located in the folder where you copied this book's sample files. In the list of tables, you'll see the Greetings table that we created in Chapter 1. The HelloWorld2 database also contains tables, forms, and queries that we'll use in the examples in this chapter. On the Tools menu, click Relationships. You'll see the following window. (The layout of the window might be different on your computer.) 2.