Access Table operations using statements

When no table exists in access, you cannot perform operations on the table using SQL statements. You can add, delete, and modify the data.
Only one table is created in access.
Define several fields in the table.
1. Create an empty Access database, which is assumed to be test. MDB.
2. In test. mdb, use the designer to create a table with the colu1 and colu2 fields.
3. After the creation, SELECT query in the object column on the left-> Create a query in design view-> display table-> select tab1 and add and close
4. Right-click "SQL View" in the top bar of the large form to enter the SQL character statement interface. on this page, you can write and verify the SQL language and implement the results.