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.[02]
- Developer
- Country of Origin
- US
- Start Year
- 1992
- Acquired By
- Project Type
- Commercial
- Written in
- Visual Basic
- Supported Languages
- Visual Basic
- Compatible With
- SQL Server
- 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.[02]
History[02]
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.
Compression[03]
By default, Microsoft Access uses unicode compression when creating the field via the table properties., all data for the text data types (Text, Memo, or Hyperlink field) are stored in the Unicode 2-byte character format.
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
4 sources- Microsoft 365 for Individuals: Subscription for Productivity Apps microsoft.com
- Microsoft Access - Wikipedia wikipedia.org
- Microsoft Access Tip: Beware of SQL Code that Creates Tables without Unicode Compression fmsinc.com
- Comparison of relational database management systems - Wikipedia wikipedia.org