Microsoft Access

Microsoft Access is a database management system (part of the Microsoft Office suite of applications) that uses a relational database engine (Microsoft Jet Database Engine). It provides a graphical user interface and 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.