How to create table in MS-Access: Table Creation MS-Access
Creating Table: Tables can be created in five different ways that are shown as follows. 1. Data sheet view 2. Design View 3. Table wizard 4. Link table 5. Import table v Data sheet View: o It allows creating new tables in data sheet view. That is a grid that is similar to Excel sheet. o In the data grid directly you can rename the field names, which are initially field1, field2... by default. o Data can be directly entered into the cells. v Design View: o In design view you need to enter the field names first. o You can also setup data type for each field. o The size of the fields can be changed or it will have the default values. o Save the table. Give a name for the table. o ...