how to make SQL CREATE TABLE in Microsoft Access how to make

how to make SQL CREATE TABLE in Microsoft Access?

how to make SQL INSERT in Microsoft access?

please answer by giving step by step

Solution

1)
CREATE TABLE table_name (
   column_1 data_type,
   column_2 data_type,
   .................
   .................
   column_n data_type,

   PRIMARY KEY (column_k)
)

Example:
   CREATE TABLE my_table (col1 INTEGER NOT NULL,
   col2 CHAR(25),
   col3 VARCHAR(25) NOT NULL,
   col4 DATETIME,
   PRIMARY KEY (col1))

2)
INSERT INTO table_name(
   col1,
   col2,
   col3,
   ....
   ....
   coln
   )
VALUES (
   col1_value,
   col2_value,
   col3_value,
   .....,
   .......,
   coln_value
)

Ex:
   INSERT INTO my_table (teacher, subject, period) VALUES (\'test\', \'test\', \'test\')