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: GitHubOrganization
  url: https://github.com/microsoft
- 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: TermsOfService
  url: https://www.microsoft.com/en-us/servicesagreement
- type: 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: PrivacyPolicy
  url: https://privacy.microsoft.com/en-us/privacystatement
- type: JSONLD
  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
- type: Integrations
  url: https://www.microsoft.com/en-us/marketplace
integrations:
- name: Microsoft
- name: Two people looking at a computer.
- name: This is placeholder text for
- name: IDC
- name: Nationwide
- name: RSA company
- name: Teleperformance
- name: A woman smiling at a laptop
- name: A man holding a laptop.
maintainers:
- FN: Kin Lane
  email: kin@apievangelist.com
  url: https://apievangelist.com