First, you need and install MysqlToAccess.
MysqlToAccess is a data conversion tool that helps DBA and database programmer unload data from Mysql schema into Access.
Unload Data From Mysql Schema Into Access -4 Steps
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Select schema and tables.
2. Access tables.
3. Select and map tables.
4. Import data.
More about MysqlToAccess – the tool to unload Mysql schema data to Access.