I learned this feature just today, so I decided to write about it. I found that Access Services on SharePoint 2010 will take care of your database in the form of a new subsite of the site collection that you have in place. You are basically importing the database tables that you want to publish to SharePoint into a new web database. This web database is your road to SharePoint, but you can’t simply convert an Access database into a web database, so you create a web database and import the tables from your Access database to make them web compatible. Here’s how I managed to do it.
Create a new web database. Inside the new web database go to the External Data tab and select the “Access” button in the ‘Import & Link’ section. Search for the Access database that you want to grab the tables from.