Start Microsoft Access 2007
1) Select the Start Button -> All Programs -> Microsoft Office -> Microsoft Access 2007.

Creating a table in Access 2007
1) Click the Microsoft Office Button, and then click New. 
2) In the File Name box, type a file name for the new database. 
3) To browse to a different location to save the database, click the folder icon. 
4) Click Create.


Enter data in the Add New Field column.
1) Create or open a table in Datasheet view.
 Note   For more information about creating a table, see the section, Create a new table.
2) In the Add New Field column, enter the name of the field that you want to create.
Use a descriptive name so that the field will be easier to identify.
3) Enter data in the new field. 


Add an AutoNumber primary key
1) In the Navigation Pane, right-click the table to which you want to add a primary key and 
then click Design View on the shortcut menu. 
2) In the first empty row of the table design grid, in the Field Name column, type a name, 
such as CustomerID. 
3) In the Data Type column, click the drop-down arrow and then click AutoNumber. 
4) Under Field Properties, in New Values, click Increment to use incremental numeric values 
for the primary key, or click Random to use random numbers. 
5) On the Design tab, in the Tools group, click Primary Key.

A key indicator appears to the left of the AutoNumber field.
Press CTRL+S to save your table design changes.



Save a Table:
1) Click the Microsoft Office Button  and then click Save, or press CTRL+S. 
2) If you are saving the table for the first time, type a name for the table, and then click OK.