Create a table and New Database

Create a table and New Database 

When you create an Access database, you store your data in tables—subject-based lists that contain rows and columns. 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. 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.

Create Table

A simple database, such as a contact list, might use only a single table. Many databases, however, use several tables. 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.

You can create a table by creating a new database, by inserting a table into an existing database, or by importing or linking to a table from another data source — such as a Microsoft Excel workbook, a Microsoft Word document, a text file, or another database. When you create a new, blank database, a new, empty table is automatically inserted for you. You can then enter data in the table to start defining your fields.

Create a new table in a new database

1. Click File > New, and then select Blank desktop database.
2. In the File Name box, type a file name for the new database.
3. To browse to a different location and save the database, click the folder icon.Click Create.
4. The new database opens, and a new table named Table1 is created and opens in Datasheet view.