Home » Microsoft Access » 05 - Tables
5

Creating a Table in the Datasheet View

Here we go over creating a new table directly from the datasheet view.

1. In the database window click Tables tab.

2. Click New > Datasheet View > OK.

3. In the new table, double click a field name and rename it.

4. Enter all fields and click close.

5. Click Save changes.

6. Enter the table name.

7. Click OK.

8. A dialogue box opens, and will ask you to create or specify a primary key.