In Access data is stored in tables. To create a table first we have to go to Create in ribbon and then click on table option as shown below.

how to Create Table in access1.Create Table in Access

Access will automatically generate Id column and click to add column as shown below

How to create table in access
2.Create Table in Access

set data types for columns to short text, number, large number etc. as per requirement. Our first column is first name and second one is last name then we will assign short text for both and rename id column as employee id by double clicking on it.

How to enter data in tables in access3.Table in Access

 

By SC