This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
Sign in

Subscriber portal

Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
      • SharePoint Server 2013 resources
      • SQL Server 2014 Express resources
      • Windows Server 2012 resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Access Access desktop database reference Microsoft Access SQL reference
Microsoft Access SQL reference Data Manipulation Language
Data Manipulation Language
Data Manipulation Language
Overview of the Access SQL Reference
Data Definition Language
Data Manipulation Language
DELETE Statement (Microsoft Access SQL)
EXECUTE Statement (Microsoft Access SQL)
INNER JOIN Operation (Microsoft Access SQL)
INSERT INTO Statement (Microsoft Access SQL)
LEFT JOIN, RIGHT JOIN Operations (Microsoft Access SQL)
PARAMETERS Declaration (Microsoft Access SQL)
PROCEDURE Clause (Microsoft Access SQL)
SELECT Statement (Microsoft Access SQL)
SELECT.INTO Statement (Microsoft Access SQL)
SQL Subqueries (Microsoft Access SQL)
TRANSACTION Statement (Microsoft Access SQL)
TRANSFORM Statement (Microsoft Access SQL)
UNION Operation (Microsoft Access SQL)
UPDATE Statement (Microsoft Access SQL)
WITH OWNERACCESS OPTION Declaration (Microsoft Access SQL)
Windows Registry Settings for External Data Sources
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.
This documentation is archived and is not being maintained.

Data Manipulation Language

Office 2013 and later

Last modified: November 06, 2012

Applies to: Access 2013 | Office 2013

In this section

  • DELETE Statement (Microsoft Access SQL)

  • EXECUTE Statement (Microsoft Access SQL)

  • INNER JOIN Operation (Microsoft Access SQL)

  • INSERT INTO Statement (Microsoft Access SQL)

  • LEFT JOIN, RIGHT JOIN Operations (Microsoft Access SQL)

  • PARAMETERS Declaration (Microsoft Access SQL)

  • PROCEDURE Clause (Microsoft Access SQL)

  • SELECT Statement (Microsoft Access SQL)

  • SELECT.INTO Statement (Microsoft Access SQL)

  • SQL Subqueries (Microsoft Access SQL)

  • TRANSACTION Statement (Microsoft Access SQL)

  • TRANSFORM Statement (Microsoft Access SQL)

  • UNION Operation (Microsoft Access SQL)

  • UPDATE Statement (Microsoft Access SQL)

  • WITH OWNERACCESS OPTION Declaration (Microsoft Access SQL)

Show:
Print Export (0)
Print Share
IN THIS ARTICLE
    Is this page helpful?
    Additional feedback?
    1500 characters remaining
    Thank you! We appreciate your feedback.

    Dev centers

    • Windows
    • Office
    • Visual Studio
    • Microsoft Azure
    • More...

    Learning resources

    • Microsoft Virtual Academy
    • Channel 9
    • MSDN Magazine

    Community

    • Forums
    • Blogs
    • Codeplex

    Support

    • Self support

    Programs

    • BizSpark (for startups)
    • Microsoft Imagine (for students)
    United States (English)
    • Newsletter
    • Privacy & cookies
    • Terms of use
    • Trademarks
    logo © 2017 Microsoft
    © 2017 Microsoft