
When you create a new database, you create a new file on your computer that acts as a container for all of the objects in your database, including your tables. 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.
