CREATE TABLE  Order

(OrderId AUTOINCREMENT (1,1)  PRIMARY KEY ,
OrderDate DateTime NOT NULL,
,
Amount  CURRENCY
)
Here i have created an order table with query and tested with access 2010 , it works!

---

Reply from Richard Rost:

Oh, sure. This is definitely possible. In fact, I cover this in part 3 of my SQL SEMINAR. However, I wouldn't say it's a "better" way to create a table. It's a good option if you need to create temporary tables, or want to allow the user to add a table on the fly without having to know anything about Access design. However, for the average Access user I would still recommend sticking with the good-old table designer.