This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Dev Center
  • Explore
    • Why Office?
    • Office UI Fabric
    • Microsoft Graph
    • Better with Office
    • Word
    • Excel
    • Powerpoint
    • Access
    • Project
    • OneDrive
    • OneNote
    • Outlook
    • SharePoint
    • Skype
    • Yammer
    • Android
    • ASP .NET
    • iOS
    • JavaScript
    • Node.js
    • PHP (coming soon)
    • Python (coming soon)
    • Ruby (coming soon)
  • Getting Started
  • Code Samples
  • Resources
    • Patterns and Practices
    • App Registration Tool
    • Events
    • Podcasts
    • Training
    • API Sandbox
    • Videos
  • Documentation
    • Office Add-ins
    • Office Add-in Availability
    • Office Add-ins Changelog
    • Microsoft Graph API
    • Office 365 Connectors
    • Office 365 REST APIs
    • SharePoint Add-ins
    • Office UI Fabric
    • Submit to the Office Store
    • All Documentation
  • https://www.yammer.com/
  • http://feeds.feedburner.com/office/fmNx
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.
    Is this page helpful?
    Your feedback about this content is important.
    Let us know what you think.
    Additional feedback?
    1500 characters remaining
    Thank you!
    We appreciate your feedback.
    Community Resources
    • O365 Technical Network
    • MSDN Forums
    • UserVoice
    • Stack Overflow
    Follow Us
    • Twitter
    • Facebook
    • Office Dev Blog
    © 2017 Microsoft
    United States - English
    • Terms of Use
    • Trademarks
    • Privacy Statement
    © 2017 Microsoft