UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> ACE SQL Body    
ACE SQL Body

Access, like many RDBMS uses Structured Query Language (SQL) to define queries. Novice developers or casual users may have never seen a single SQL keyword when building queries. This is possible thanks to Access' excellent graphical query builder. However, there are times when writing SQL may be desirable or in some cases, required.

SQL can be split into three broad classes: Data Manipulation Language (DML), which typically selects and/or makes updates to the data, Data Definition Language (DDL), which creates or alters database objects such as tables and indexes, and for Access databases using MDB format, there is also support for managing User Level Security via SQL. This last subset is classified as Data Control Language (DCL). Note that this is not available in an ACCDB format.

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 7,483 times.  This page was last modified 01:31, 10 February 2012 by Jack Leach. Contributions by George Hepworth and BananaRepublic  Disclaimers