


Many databases, however, use several tables. For more information, see Introduction to tables.Ī simple database, such as a contact list, might use only a single table. This article explains how to create a table, add fields to a table, set a table's primary key, and how to set field and table properties.īefore you create tables and add fields, make sure you understand the background concepts. For instance, you can create a Contacts table to store a list of names, addresses, and telephone numbers, or a Products table to store information about products. When you create an Access database, you store your data in tables-subject-based lists that contain rows and columns.
