First, you need
and install MysqlToAccess.
MysqlToAccess is a data conversion tool that helps DBA and database programmer export Mysql data to Access.
Export Mysql All Tables To Access – 4 Steps
Click “Wizard – Import All Tables” at task dialog.

then show the wizard.
1. Select source tables.

2. Access tables.

3. Select and map tables.

4. Import.

More about MysqlToAccess – the tool to batch export MySQL data to Access.