Question

how to make SQL CREATE TABLE in Microsoft Access?

how to make SQL INSERT in Microsoft access?

please answer by giving step by step

Answer 1

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')