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
AngularJS – how to write a simple application for listing products
Sep 01, 2016, by AdrianC
In the first article you got to know something about Angular, and now it's time to get underway and see it in action.... read more
Programmers are bound to make an impact on the Romanian administration
Aug 31, 2016, by VladC
The Romanian Government tries to develop a new platform called GovITHub, which is designed to simplify all aspects regarding the Romanian public administration.... read more
Romanian students innovate at Microsoft's Imagine Cup
Jul 14, 2016, by BogdanD
Romanian students, Flavia Oprea, Iulian Mateșică and Cristian Alexandrescu from the Polytechnic University of Bucharest won the Innovation challenge in Microsoft's Imagine Cup competition.... read more
Products  |  Press  |  Site Map  |  Technologies  |  Terms of Use  |  Privacy Policy
© 2017 SBP Romania. All rights reserved.