SETHA SITE INFORMATION

  • Increase font size
  • Default font size
  • Decrease font size

How to Create Table in Microsoft Access 2010

E-mail Print PDF

After you created new blank database you will see one table is created named Table1 which is not yet save. If you do not prefer to continue with that default table just click on the x button on the right hand side without saving.

Create New Table in Microsoft Access 2010
  • Click on Create Tab
  • Click on Table Design Button
  • You will see the table designation windows appear
  • Enter fields name and its data type as below:
  • Set field stdid to Primary Key (Not allow duplicate data for stdid) by Right Click on that field and choose Primary Key
  • Click <Ctrl-S> to Save the Table