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

 


Have a project in mind?

Get in touch with us for your Microsoft Access development needs!

 

 



Recent posts on our blog
New alternatives for mainstream server-side programming
Aug 30, 2018, by Cristian
We take a look at the advantages of 5 up and coming programming languages, namely Ruby, Node.js, Go, Scala, and Rust.... read more
Nginx - top contender in the web server game
May 17, 2018, by Dragos
Nginx is a well-known open-source web server that has undergone a rapid growth in popularity. Even at this point it looks like the growth is sustainable, so this software will keep on catching up with both Apache and IIS. Additionally, more and more web applications (websites), especially those with a high traffic, are switching to Nginx.... read more
Top 5 Best Visual Studio Extensions
Mar 28, 2018, by Cristian
One of the strengths of Visual Studio is represented by the powerful customization options (both design and functionality). ... read more
Press  |  Site Map  |  Technologies  |  Terms of Use  |  Privacy Policy
© 2018 SBP Romania. All rights reserved.