Microsoft Access is a desktop-based relational database management system primarily used for small-scale applications, allowing users to create and manage databases using a graphical interface.