I've used the crap out of Access for about 20 years. I love it, but I also recognize it's limitations -- it's primarily for building small workgroup applications (e.g., 5 concurrent users or less). Beyond that you're taxing it (unless you build the front-end in Access and attach it to something like SQL Server on the backend). It's also not the most secure platform -- something to keep in mind if your data is sensitive. Depending on relationships and how the db is built, Access can handle in the 10's of thousands to 100's of thousands of records. Beyond that you really need something more robust. Otherwise, it's great for quickly solving business / data management solutions.
I've built a couple of CRM systems for customers over the years -- the relational nature of data is well suited for something like Access (or something more robust).
Access does have a learning curve. Some people never quite get it, but if you're willing to learn, it's a pretty cool tool and really useful as a tool for small groups (or individuals). It REALLY helps to learn macros and
VB. With some experience you can build some pretty slick applications using forms and coding.
Are you pretty good at picking up skills like that?