You can construct your tables in access and export them to MySQL , then link them back in .
When creating tables in access , you must have a primary key defined in order to have write access to the table in access .