Let's put aside the database part first. The setup is like this:
An Android app will communicate with a web service written in say PHP with necessary parameters and PHP will contact the database and will fetch the result and return the results to the Android app. For this part, learn to do it here Android PHP/MYSQL Tutorial
Once you understand it, the actual database connectivity is between PHP and the MS Access, check this out: Using an Access Database with PHP
Last but not least, for serious app development, you should use real RDBMS like mysql, mssql, oracle etc. Not MS Access.
Enjoy your learning.