To use Microsoft Access as a connection in Talend Open Studio Data Integrator (TOS), create a Db Connection in the Metadata.
|Create a Db Connection with Microsoft Access in TOS|
Microsoft Office Professional 2010's installation encourages you to install the 32-bit version for compatibility reasons, even if the target machine is 64-bit. To install the 64-bit version, you have to exit out of the startup screen and navigate to a x64 folder and run that setup script.
If you want to continue using the 32-bit version (for compatibility reasons), then you'll need to run the 32-bit version of TOS which may require a 32-bit version of Java. This will pick up the 32-bit version of the ODBC drivers which includes Access drivers from the Office install.
For my setup, I'm running the 64-bit version of Java 7 with the 64-it version of TOS v5.