It isn't necessarily a highly sought after certification, but it is still a valid Microsoft Cert which demonstrates you proficiency and skill at that particular MS product....Besides it couldn't hurt to have it listed on your resume.
I guess MS Access MCP was cancelled few years ago. Now you can take only full Office " Exam 70-091: Designing and Implementing Solutions with Microsoft Office 2000 and Microsoft Visual Basic for Applications "
I did it two years ago and to be honest, nobody cares at all! Try SQL or full MSDBA. Don't waste your time and money with 70-091.