| 1 |
The SELECT INTO Statement: It is unique to Access SQL, Used to create a new table from the rows in another table or query.
|
| 2 |
Syntax: SELECT column1 [,column2[,..]] INTO new-table
|
| 3 |
Example: SELECT OrderId, OderDate INTO tblJonesOrders FROM tblOrder WHERE CustomerId=9;
|
| 4 |
Access SQL supports 4 DDL (Data Definition Language) statements:
-
CREATE TABLE - Creates a new table schema
-
ALTER TABLE - Modifies an existing table schema
-
CREATE INDEX - Creates a new index
-
DROP - Deletes a table schema or an index
|
| 5 |
Data Access Objects (DAO) is another method, like DDL, to programmatically create and manipulate table schemas in Access.
|
