How to Create a Manual Table in Access 2007

A table in Access 2007 is a list that contains rows and columns. It is used to store subject-based data and should be created before any other objects when designing a database. You can create a table in a new or existing database in Access 2007. The following steps will also show how to create a new database if needed.

Instructions

1

Start Access 2007 and create a new database, if needed. Click the "Microsoft Office" button and click on the line item labeled "New" to bring up the "File Name" box. Browse to the location where you wish to save the database and enter the name of the new database. Click on the "Create" button to create the new database.

2

Open the database in which you wish to create a table. Click on the Microsoft Office button and click on "Open" to bring up the "Open" dialog box. Select the desired database and click on the "Open" button.

3

Look on the "Create" tab for the "Tables" group. It should list four types of tables in this order: Table, Table Templates, SharePoint Lists and Table Design. Click the icon labeled "Table." This will insert a new table into the database and open that table in "Datasheet" view.

4

Set the primary key unless you have a compelling reason not to. Access automatically creates a primary key and assigns it a name of ID and a data type of AutoNumber.

5

Determine which field in your table will be the primary key. You will normally make this decision when you design your database.