Document Title: Alternatives to Microsoft access, objects of Microsoft access and data types in Microsoft datasets

Paper code: 13077

Alternatives to Microsoft access, objects of Microsoft access and data types in Microsoft datasets

a) 

Microsoft Access is an information management tool, or relational database, that helps in storing information for reference, reporting and analysis. Access can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications. The following are alternatives of Microsoft access;

LibreOffice Base

Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.

OpenOffice Base

Base is a desktop database management system, designed to meet the needs of a broad array of users. Base offers wizards to help users new to database design (or Base) to create Tables, Queries, Forms and Reports, along with a set of predefined table definitions for tracking Assets, Customers, Sales Orders, Invoices and much more.

b)

MS Access uses “objects" to help the user list and organize information, as well as prepare specially designed reports.