One abiding mystery with Access is the documentation for its flavor of SQL (not to mention the occult and bizarre functions, abandoned bastard children of VisualBasic, one can embed into queries). I've often searched on "Microsoft Access SQL" and found nothing . Recently, reading the very good Wikipedia article on Access I came across a clue. Since the default database engine is "Jet", maybe a search on "Jet SQL" would work better.
It does: Microsoft Office Assistance: Microsoft Jet SQL Reference
 For example: Create View.
CREATE VIEW can be executed only through the ADO library.If you try to create a view within Access itself, you get a very helpful error message: "Syntax error in create table statement". Sigh. I do love my Mac.
Access itself uses DAO, so any attempt to CREATE VIEW from the query design
window will fail.
 It's mostly in the help file but Microsoft's brilliantly helpful implementation obscures this. BTW, I think Vista and Office 2007 will be, both, catastrophes.