List all SQLite databases. To prove the database is indeed created, you can look for the todo.db file in the current folder, or simply issue the following command:. sqlite>.databases main: ...

CREATE TABLE statement column-modifier: INSERT statement VALUES clause: SELECT clause: FROM clause: Table: PROCLIB.PAYLIST This example creates the table PROCLIB.PAYLIST and inserts data into it.

Click Apply to execute the SQL Script. Your table is now ready for data. ... Congratulations, you successfully created a database, added a table, and entered data into the table.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.