The simple answer to your question is yes. Use ODBC.
If you haven't already done so, download the MySQL ODBC driver. Go to the Control Panel and set up a connection with the Data Source Administrator to your MySQL database.
Open up your Access database. Go to File -> Get External Data -> Import. Select an ODBC type connection, choose your connection to MySQL and pick the tables you want to import. This will download a copy of the data to your Access database.
You can also choose to link your tables so that instead of having a copy, you are actually looking at live MySQL data. The tables will show up in Access with an arrow "->" next to each table to indicate they are linked instead of local. Changing data in Access will change the data on the server using this configuration.
If this isn't detailed enough for you, either send me an email or post another question and I'll be glad to help.
