As Juan may have mentioned earlier, I had been working with two other MVPs, Tim Runcie and George Hepworth in producing the first of its kind, a book dedicated to using Access with SharePoint. The book can be bought online at the Advisicon store.
If you’re wanting to learn more about the capabilities and limitations of Access and SharePoint, this book is a wonderful starting point in getting the fundamentals as well discussion on what’s going on under the hood. It will help you make informed design decisions whether you build an Access web database or use traditional Access application linked to SharePoint lists.
If you do buy the book, please let the authors know how it has helped!