How To Create Table With SQL View in Microsoft Access

Apply To:
Microsoft Access 2010

Problem:

How To Create Table With SQL View in Microsoft Access

1. Example syntax create table with SQL format,
CREATE TABLE [Temp_ProfileAccount](
[Group_ProfileAcc] varchar(1) NULL,
[Bank] varchar(255) NULL,
[AccountNo] varchar(150) NULL,
[Currency] varchar(5) NULL,
[BankAccount] varchar(150) NULL
)

2. Go to menu "Create > Query Design"

3. Will display this screenshot, and choose "Close"

4. Then, right-click at Query1 Layout, and choose "SQL View"

5. Next, copy Example SQL syntax in Point 1, to Query1 Layout

6. Click "Run"

7. Click icon "X" or Close.
And for the message "Do you want to save changes to the design of query 'Query1' ?"
Choose "No".

8. To check the availability of Table,
click the Expand of "Navigation Pane" and type the name of Table