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. It is supported by Visual Basic for Applications (VBA) and allows developers to develop application software.
- Developer
- Country of Origin
- US
- Start Year
- 1992
- Acquired By
- Project Type
- Commercial
- Operating System
- Windows
- License
- Proprietary
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. It is supported by Visual Basic for Applications (VBA) and allows developers to develop application software.
History
Access originated from Project Cirrus of Microsoft during late 1980s. The project aimed to create an application on Windows that can compete with Paradox or dBase. It used some code from both the Omega project and a pre-release version of Visual Basic. In July 1992, betas of Cirrus was released as a product and Access became its official name.
Data Model
Access tables support a variety of standard field types, indices, and referential integrity including cascading updates and deletes.
Query Execution
They incorporate Fox's Rushmore query optimization routines into Access.
Query Interface
Access has a query interface, forms to display and enter data, and reports for printing.
Storage Architecture
Microsoft Access can scaled to enterprise-level solutions by linking to multiple databases on disk or using a back-end database like Microsoft SQL Server.
DittoBitto
Citations
2 sources- Microsoft 365 for Individuals: Subscription for Productivity Apps microsoft.com
- Microsoft Access - Wikipedia wikipedia.org