Microsoft Access


Microsoft Access is a database management system (part of the Microsoft Office suite of applications) that uses a relational database engine, more precisely: Microsoft Jet Database Engine, and provides:

  • graphical user interface
  • software-development tools

Also, it has the capability to import or link directly to the data stored in other applications and databases.

Advantages 

  • Easy-to-use interface
  • Beginners can create databases using a large number of templates
  • Good for small businesses with small datasets and limited number of users
  • Low costs

Disadvantages

  • Difficulty dealing with databases larger than 2 GB in size
  • Microsoft Access cannot handle large data requests

Components

  • Tables
  • Relationships
  • Queries
  • Forms
  • Reports
  • Macros
  • Modules (used for writing and storing Visual Basic for Applications - VBA)

Development tools 

  • Access provides a graphical interface for database management, design and creating queries. It also provides two COM libraries for database interaction.

Versions

  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95
  • Microsoft Access 97
  • Microsoft Access 2000
  • Microsoft Access 2002
  • Microsoft Access 2003
  • Microsoft Access 2007
  • Microsoft Access 2010
  • Microsoft Access 2013