As a database system Access has many good points and many bad points. Happily most of the bad points relate to the 'class' of application that Access is. It is important to clarify the 'class' that Access falls into.
Access is a desktop database package.
In addition, Access can and does make a good front-end package larger engines such as Oracle and SQL Server. Against other desktop database packages Access has one huge advantage. It is likely that you are running Windows as your operating system and using Microsoft Office as your application base. Access integrates well with these packages and data transfer between Access and the other Office components is relatively easy. In addition, against the other desktop databases Access is both rich in features and powerful.