Microsoft Access is a desktop database application that combines a relational data engine with a graphical user interface and development tools. It is distributed as part of certain Microsoft Office editions and is intended primarily for single users, small teams, and rapid application development. For product details see the official page: Microsoft Access overview.
Key components
- Tables store structured records and define fields and data types.
- Queries select, filter and manipulate data using a visual designer or SQL.
- Forms provide data entry and navigation interfaces for users.
- Reports format and print data summaries for distribution.
- Macros and modules automate tasks and extend functionality with simple scripts or Visual Basic for Applications (VBA).
Access uses a file-based database engine (historically Jet, later ACE) and stores objects and data in a single file, which makes it easy to deploy for desktop scenarios. It also supports links to external data sources and can act as a front end to server-based databases.
History and development. Microsoft Access first appeared in the early 1990s and has evolved alongside Office, adding new file formats and integration capabilities. For version and support notes consult official documentation: version history and docs.
Uses and limitations. Access is widely used for small-business systems, departmental tracking, ad hoc reporting, and prototypes because it enables non-specialist developers to build solutions quickly. It is less suited to very large, multiuser enterprise deployments where client-server databases such as SQL Server are preferred. For guidance on integration with other tools and migration options, see related guidance.
Notable distinctions: Access emphasizes rapid development and ease of use rather than high-concurrency, distributed transaction processing. Understanding its scope helps choose whether it is the right tool for a particular data application.