Microsoft Access

Microsoft Access. It is a relational database management system (RDBMS) developed by Microsoft and included as part of the Microsoft 365 suite of applications. Primarily aimed at individual users, small teams, and business units, it combines a graphical user interface with software development tools and the Jet Database Engine. This integration allows users to create desktop-based database applications without needing extensive programming knowledge, though it supports advanced automation through Visual Basic for Applications.

Overview

Introduced in 1992, the software was developed to provide a user-friendly database tool for the Microsoft Windows platform, competing with products like Paradox and dBase. It quickly became a staple in many business environments for creating custom database solutions, forms, and reports. As a member of the Microsoft Office suite, it shares common interface elements and integration capabilities with applications like Microsoft Excel and Microsoft Word. Its architecture is centered on the Jet Database Engine, which handles data storage, querying, and retrieval, while the application itself provides the tools for building the user interface and application logic.

Features

A core feature is its ability to create and manage database objects, including tables, queries, forms, reports, macros, and modules. Users can design tables with various data types and establish relationships between them. The Query by Example interface allows for the visual creation of SQL statements to filter and combine data. For building user interfaces, the Form Designer enables the creation of data entry screens with controls like text boxes, combo boxes, and command buttons. Reporting tools can generate formatted outputs for printing or distribution, often pulling data from complex queries. Advanced functionality is achieved through Visual Basic for Applications, which allows for writing procedures and functions to automate tasks and extend application capabilities beyond the built-in wizards.

File formats and extensions

The primary file format uses the .accdb extension, introduced with the Microsoft Office 2007 release. This format succeeded the older .mdb format used by default since the software's inception. The .accdb format supports newer features such as multivalued fields, attachment data types, and improved encryption. For runtime distribution of applications without the full development environment installed, the Microsoft Access Runtime is available. Data can also be linked to or from external sources in various formats, including other database systems like Microsoft SQL Server, ODBC-compliant databases, and flat files such as Microsoft Excel spreadsheets or CSV text files.

Development

The initial version, code-named "Cirrus," was created by a team led by key developers from the former FoxPro team after its acquisition by Microsoft. It represented a strategic move to dominate the desktop database market on the Windows 3.1 operating system. Major milestones include the transition to a 32-bit architecture with Access 97, integration of the Visual Basic for Applications programming environment, and the shift to the Ribbon interface starting with Microsoft Office 2007. Development has continued within the broader Microsoft Office and Microsoft 365 release cycles, with ongoing updates focusing on connectivity to cloud services like Microsoft SharePoint and Microsoft Azure SQL Database, though it remains primarily a desktop-centric development platform.

Use cases and alternatives

Typical applications include departmental systems for inventory control, contact management, small-scale project tracking, and as a front-end for enterprise SQL Server databases. Its rapid application development environment makes it suitable for prototyping or for solutions where the cost of a full-scale ERP system is not justified. Common alternatives in the desktop database space include FileMaker Pro and OpenOffice Base. For more robust, server-based applications requiring higher concurrency and security, platforms like Oracle Database, MySQL, PostgreSQL, and Microsoft SQL Server itself are often chosen. The rise of low-code platforms and SaaS applications from vendors like Salesforce and Zoho Corporation has also shifted many use cases previously served by desktop database tools to cloud-based solutions.

Category:Microsoft database software Category:Relational database management systems Category:Microsoft Office Category:Proprietary database management systems