This is a longer than normal video tutorial that I typically post on my blog but this is an important introduction for developers (and end-users too of course!) who are considering building an Access database for deployment over the internet as well as managed via the native application objects of Microsoft Access.
You will need SharePoint Services 2010 or an Access hosting service to handle ‘live’ web application’s objects and with Access 2010, simple tools to help check, manage and publish to the web.
Be patient, stick to the full video demonstration and get a feel for the true power of Microsoft Access 2010.
At the end of the day, you still need to know the objects of ‘native’ Access and the main objects which will mean learning about the Tables, Queries, Forms, Reports and RDBMS (Relational Database Management System).
Perhaps my eBooks would be a good start?