Microsoft Access is a relational database management system offered by Microsoft. It comes as part of the Microsoft Office Suite of software and uses the Microsoft Jet Database Engine. Microsoft Access provides the same functionality as a traditional database management system and the simple programming capabilities to make simple to navigate forms.
Access also provides the ability to use VBA, or visual application development, which means that you can create reusable modules and view them in isolation from the rest of the database. For example, an individual column in an Access table can be defined as a VBA script or function. This script can then be called during a user request, such as when a form is submitted. The advantages of using VBA for database interactions are that there is no hard coding, there are only predefined scripts that can be executed in various environments, and the code is automatically detected by the Access application, reducing the need for manual interaction with the database.
Another feature Access offers the ability to use “ormodb” and “ormp” tables. An “ormp” table is like a normal “table” in that it contains one or more embedded views. However, an “ormp” is much more efficient for many various reasons. OMRP tables have an embedded connection to the Microsoft Exchange server, so they can be used in conjunction with an Exchange server. This greatly reduces the time it takes for data to be pulled from and updated from Microsoft Exchange servers, making Access one of the more flexible databases to work with when building a website.