Microsoft Access

Microsoft Access
source
Name	Microsoft Access
Developer	Microsoft
Initial release	1992
Latest release	Microsoft 365 (ongoing)
Operating system	Microsoft Windows
Genre	Database management system

Microsoft Access

Microsoft Access is a proprietary desktop relational database management system and graphical user interface database builder developed by Microsoft. It combines a database engine, a design environment, and a suite of tools for building forms, reports, and queries used by organizations and developers. Access has been bundled with several editions of Microsoft Office and is used in conjunction with server products, development platforms, and third-party tools across enterprise and small-business contexts.

Overview

Microsoft Access serves as an application development environment with a focus on rapid application development for data-driven solutions used by administrators, analysts, and citizen developers. It integrates a file-based engine alongside design surfaces for forms and reports and supports scripting and automation with Visual Basic for Applications. Access is commonly used alongside server-based systems such as Microsoft SQL Server, cloud platforms like Microsoft Azure, and enterprise tools including SharePoint and Power BI.

History

Access was originally introduced in 1992 as part of Microsoft's strategy to compete in desktop database markets dominated by vendors such as Borland and FileMaker. Early versions leveraged technologies from relational database research and followed the evolution of the Windows application platform through the 1990s and 2000s. Integration points expanded with releases of Microsoft Office 97, Microsoft Office XP, and the shift to subscription models with Microsoft 365. Over time, Microsoft adapted Access to interoperate with server and cloud offerings including SQL Server Express and services on Azure.

Features and architecture

Access combines a desktop database engine, a query processor, and a graphical user interface with drag-and-drop design tools and wizards. The application exposes design objects such as tables, queries, forms, reports, macros, and modules that map to programmatic interfaces used by developers familiar with Visual Basic and VBA environments. Security and multiuser concurrency rely on Jet/ACE engine behaviors and can be augmented using backend servers like Microsoft SQL Server, connection technologies such as ODBC, and authentication services including Active Directory. Reporting and data visualization are extended through integration with tools developed by Microsoft Power Platform stakeholders and third parties.

Data storage and file formats

Access stores data in single-file containers using the Jet Database Engine in early releases and the Access Connectivity Engine (ACE) in later releases. Common file formats include .mdb for legacy databases and .accdb for newer format support with enhanced data types and features. Access can link to external data sources via drivers and providers, including ODBC drivers for MySQL, Oracle Database, and PostgreSQL, as well as connectors for Excel workbooks and SharePoint lists. File-level portability supports local desktop scenarios while backend migration paths target SQL Server and cloud-hosted databases on Azure SQL Database.

Development and customization (VBA, macros, add-ins)

Customization in Access is centered on Visual Basic for Applications and macro objects that automate user interactions and enforce business logic. VBA modules allow developers familiar with Visual Basic and COM technologies to implement event-driven procedures, create ActiveX controls, and interact with external automation servers like Microsoft Outlook and Windows Scripting Host. Add-ins and extensions can be developed using COM add-in frameworks or by integrating .NET components via COM Interop, and deployment scenarios often involve packaging with Microsoft Installer technologies and enterprise management solutions from System Center.

Integration and interoperability

Access is designed to interoperate with a wide array of Microsoft and third-party systems. Common integration targets include Microsoft SQL Server for scalable backends, Excel for data exchange, SharePoint for web-based lists and collaboration, and Power BI for analytics and dashboards. Connectivity leverages protocols and standards such as ODBC, OLE DB, and XML for data exchange with enterprise systems like SAP and databases from vendors such as Oracle Corporation and IBM.

Editions and licensing

Access has been distributed in multiple editions tied to suites and licensing models, including retail copies, volume licensing for organizations through Microsoft Volume Licensing, and subscription-based access via Microsoft 365 plans. Historically it appeared in consumer and professional bundles of Microsoft Office such as Office Professional, and availability has been influenced by Microsoft's product strategy across desktop productivity, server products, and cloud services. Deployment and support are governed by licensing terms set by Microsoft and applicable enterprise agreements with organizations such as multinational corporations and government institutions.

Category:Microsoft software