Access Sql Query Create Table. Click the Run button or just switch to Datasheet view The results of the query will be displayed. You would like to create a new table in a database with data defined by an SQL query.
That new table can reside in the database that you have open or you can create it in another database. Column1 datatype column2 datatype column3 datatype. For an overview of the available data types go to our complete Data Types.
This special interface method is known as Query-By-Example.
CREATE TABLE table_name. The open parenthesis follows the name of the table and the close parenthesis is located at the end of the CREATE TABLE script. The closing semicolon is optional in Access although getting into the habit of using it will be helpful when you start building complex SQL statements. To create the recipes database we first need to create a database.
