Access

View Current Viewing Revision #9 from 12/04/2018 10:22 p.m.

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.

Access has a query interface, forms to display and enter data, and reports for printing.

Checkpoints

Non-Blocking

Storage Architecture

Disk-oriented

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.

Logging

Not Supported

Foreign Keys

Supported

Compression

Bit Packing / Mostly Encoding

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.