• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

6. Access Structured Query Language (SQL... > 6.7. The DML Component of Access SQL

The DML Component of Access SQL

We now turn to the DML component of SQL. The commands we will consider are:

  • SELECT

  • UNION

  • UPDATE

  • DELETE

  • INSERT INTO

  • SELECT INTO

  • TRANSFORM

  • PARAMETER

Before getting to these statements, however, we must discuss a few relevant points.

Updatable Queries

In many situations, a query is updatable , meaning that we may edit the values in the result table, and the changes are automatically reflected in the underlying tables. The details of when this is permitted are fairly involved, but they are completely detailed in the Access Help facility. (This information is not easy to find, however. You can locate it by entering “updatable query” in the Access Answer Wizard and choosing Determine when I can update data from a query.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint