Microsoft access is a database management system (DBMS) that combines a jet database engine with a graphical user interface. It is owned by the famous Microsoft company and has effectively evoluted since its release in 1992 with the Microsoft access version 1.0. Version 1.1 was introduced in 1993 but it was buggy. As a result, Microsoft updated its operating system and released the Microsoft access version 2.0. The latter was very efficient and used by many developers and designers but it required some patience to work with. As Microsoft built further operating systems, Access 95 was invented which made use of a graphical user interface instead of a 32 processing bit system followed by Access 97, Access 2000, Access 2003, Access 2007 and Access 2010. Minor enhancements were made since the Access 2000 version but the application software proved to be more stable.
The main features of Microsoft access are that the DBMS is implemented on C++ with a commercial license (not open source). It is compatible on Windows only. Microsoft Access makes use of SQL for running queries. Its access methods include DAO, OLE DB, ADO.NET and ODBC.C. It can moreover support programming languages such as C, C#, C++, JAVA, VBA and Visual Basic.Net. Microsoft Access is not a real database server, but it makes use of DLLs and is mostly used for developing small single-user-applications.
PostgreSQL
PostgreSQL is an object-relational DBMS released by the PostgreSQL Global Development Group. Micheal Stonebreaker's team first intended to add object features to relational databases. Between 1989 to 1993, they released four successful versions of their project before open-source developers holding an MIT license, adopted and converted it to Postgre95. In 1994, its query language changed from QUEL to SQL and three years later, its name itself was modified to PostgreSQL.
The main features of PostgreSQL are that the DBMS is firstly open-source. Queries can be written