Databases & Desktop Publishing · Reviewed
Microsoft Access
A Windows relational database and application-building tool that combines tables, queries, forms and reports for small business and departmental information systems.
Overview
Access provides a graphical environment for defining related tables and working with the data they contain. Queries select and transform records, forms create a usable interface, and reports turn information into printable output. Macros and VBA can automate business rules and repeated tasks.
The application can also connect to external databases, separating the user interface from another system's storage. This makes it useful for departmental tools, but deployment and concurrent usage require deliberate design. A database file is an application asset with relationships and logic, rather than simply a larger spreadsheet.
Key features
- Relational tables and queries
- Visual forms and reports
- Macros and VBA automation
- External data connectivity
- Desktop application construction
Historical significance
Access lowered the barrier to building relational business applications. Its forms and reports let non-specialist teams create usable tools around structured records. Its significance includes the strengths and responsibilities of that independence: local expertise can produce valuable software, while long-lived systems still need documentation, maintenance and an appropriate deployment model.
History and development
Microsoft released the Access relational database in 1992. It brought visual database construction into the growing Windows office market and became part of selected Office editions. The name had previously been used for an unrelated Microsoft communications product.
Later versions expanded programming, server connectivity and the database engine, including the ACCDB format. Access continued to occupy a space between individually managed office files and larger application systems, with a substantial legacy of internal tools built by users close to the underlying business process.