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



Recent posts on our blog
Remote Connections: The Name of the King
Nov 06, 2017, by Cristian
Let’s have a look at the three most popular remote desktop applications, namely Microsoft’s Remote Desktop Connection, VNC Viewer and TeamViewer.... read more
4 ways to build a killer mobile app
Aug 25, 2017, by Dragos
There still is a lot of growth potential in the mobile industry. There are untapped areas that will be discovered in the near future. You can do it as well, therefore this is the right time to choose a mobile development career.... read more
Hadoop: the future is now - and it's all about Big Data
Jun 05, 2017, by Dragos
Apache Hadoop is an open-source software written in Java, a framework that allows for the distributed processing of very large data sets across clusters of computers.... read more
Products  |  Press  |  Site Map  |  Technologies  |  Terms of Use  |  Privacy Policy
© 2017 SBP Romania. All rights reserved.