Microsoft Access

name: Microsoft Access
description: Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.
image: https://www.microsoft.com/en-us/microsoft-365/access
tags:
  - Access Database
  - Database
  - Desktop Database
  - Microsoft
  - Relational Database
created: '2024'
modified: '2026-04-28'
url: https://www.microsoft.com/en-us/microsoft-365/access
specificationVersion: '0.18'
apis:
  - name: Microsoft Access Database Engine API
    description: >-
      API for programmatic access to Microsoft Access databases through various interfaces
      including ODBC, OLE DB, and DAO.
    image: https://www.microsoft.com/en-us/microsoft-365/access
    humanUrl: https://learn.microsoft.com/en-us/office/client-developer/access/access-home
    baseUrl: https://api.example.com/access
    tags:
      - DAO
      - Database
      - ODBC
      - OLE DB
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/
      - type: OpenAPI
        url: https://example.com/openapi.json
      - type: Tutorials
        url: https://learn.microsoft.com/en-us/office/vba/access/concepts/miscellaneous/concepts-access-vba-reference
  - name: Microsoft Graph API (for Access Online)
    description: >-
      API for accessing Microsoft Access databases stored in SharePoint or OneDrive
      through Microsoft Graph.
    image: https://learn.microsoft.com/graph/images/microsoft-graph.png
    humanUrl: https://learn.microsoft.com/en-us/graph/overview
    baseUrl: https://graph.microsoft.com/v1.0
    tags:
      - Cloud Database
      - Microsoft Graph
      - SharePoint
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/graph/api/resources/list
      - type: Authentication
        url: https://learn.microsoft.com/en-us/graph/auth/
      - type: SDKs
        url: https://learn.microsoft.com/en-us/graph/sdks/sdks-overview
  - name: Microsoft Access VBA API
    description: The Access Visual Basic for Applications (VBA) object model provides programmatic access to all Access objects, properties, methods, and events for developing custom solutions and automating database operations.
    image: https://www.microsoft.com/en-us/microsoft-365/access
    humanUrl: https://learn.microsoft.com/en-us/office/vba/api/overview/access
    tags:
      - Automation
      - Macros
      - Object Model
      - VBA
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/office/vba/api/overview/access
      - type: Object Model Reference
        url: https://learn.microsoft.com/en-us/office/vba/api/overview/access/object-model
      - type: Application Object Reference
        url: https://learn.microsoft.com/en-us/office/vba/api/access.application
      - type: DoCmd Object Reference
        url: https://learn.microsoft.com/en-us/office/vba/api/access.docmd
  - name: Microsoft Data Access Objects (DAO) API
    description: Data Access Objects (DAO) provide a programmatic interface to create, query, and modify the structure and data of Access databases, with objects like Database, Recordset, TableDef, QueryDef, and more mapping directly to database constructs.
    image: https://www.microsoft.com/en-us/microsoft-365/access
    humanUrl: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-data-access-objects-reference
    tags:
      - DAO
      - Data Access
      - QueryDef
      - Recordset
      - TableDef
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-data-access-objects-reference
      - type: Database Object Reference
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/database-object-dao
  - name: Microsoft ActiveX Data Objects (ADO) API
    description: ActiveX Data Objects (ADO) enable client applications to access and manipulate data from Access databases through OLE DB providers, supporting features for building client/server and web-based applications with extensions for multidimensional data (ADO MD) and schema management (ADOX).
    image: https://www.microsoft.com/en-us/microsoft-365/access
    humanUrl: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-activex-data-objects-reference
    tags:
      - ActiveX
      - ADO
      - Data Access
      - OLE DB
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-activex-data-objects-reference
      - type: OLE DB Providers Reference
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/ole-db-providers
  - name: Microsoft Access SQL API
    description: The Microsoft Access SQL reference provides documentation for the Access SQL dialect, including data definition language (DDL) for creating and modifying database structures and data manipulation language (DML) for querying and updating data.
    image: https://www.microsoft.com/en-us/microsoft-365/access
    humanUrl: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-access-sql-reference
    tags:
      - DDL
      - DML
      - Query
      - SQL
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/microsoft-access-sql-reference
      - type: SQL Reference Overview
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/overview-of-the-access-sql-reference
  - name: Microsoft Access Macro Actions API
    description: The Access macro actions interface provides a set of programmable actions for automating database tasks including data operations, form management, navigation, filtering, and system commands without writing VBA code.
    image: https://www.microsoft.com/en-us/microsoft-365/access
    humanUrl: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/access-macro-actions-access-developer-reference
    tags:
      - Actions
      - Automation
      - Macros
      - No-Code
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/access-macro-actions-access-developer-reference
      - type: Macro Commands Reference
        url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/macro-commands
  - name: Power Automate Access Actions API
    description: Power Automate for desktop provides built-in actions for automating Microsoft Access databases, including launching Access instances, reading tables, running stored queries, executing macros, and closing databases programmatically within desktop flows.
    image: https://www.microsoft.com/en-us/microsoft-365/access
    humanUrl: https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/access
    tags:
      - Automation
      - Desktop Flows
      - Power Automate
      - RPA
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/access
common:
  - type: Portal
    url: https://www.microsoft.com/en-us/microsoft-365
  - type: Support
    url: https://support.microsoft.com/access
  - type: Pricing
    url: https://www.microsoft.com/en-us/microsoft-365/access/compare-microsoft-access-plans-and-pricing
  - type: Blog
    url: https://techcommunity.microsoft.com/t5/access-blog/bg-p/AccessBlog
  - type: Terms of Service
    url: https://www.microsoft.com/en-us/servicesagreement
  - type: Developer Documentation
    url: https://learn.microsoft.com/en-us/office/client-developer/access/access-home
  - type: Desktop Database Reference
    url: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/
  - type: Access Database Engine Download
    url: https://www.microsoft.com/en-us/download/details.aspx?id=54920
  - type: Privacy Policy
    url: https://privacy.microsoft.com/en-us/privacystatement
  - type: JSON-LD
    url: json-ld/microsoft-access-context.jsonld
  - type: JSONSchema
    url: json-schema/microsoft-access-database-schema.json
  - type: JSONSchema
    url: json-schema/microsoft-access-table-schema.json
maintainers:
  - FN: Kin Lane
    email: [email protected]
    url: https://apievangelist.com