w/r/t Access, you will need to download the MySQL odbc drivers for access. This is not officially supported, and is not a super easy task. There is a thread in this forum which discusses the proceedure for doing this. Keeping the information up-to-date might be tricky, though.
Some of us do this internally, although I haven’t personally had much experience with it.
Not so sure about your other questions, so I’ll leave it to others to answer.
Regarding documentation on databases, have you done a search for “MySQL” in the kbase? That should bring up at least some documentation.