We just published a white paper on writing managed code inside Access. Here is the abstract:

Learn how you can extend Access 2007 by creating and incorporating managed add-ins into your applications. This article demonstrates how to create a simple add-in that consumes data returned from a Web service, by using the Visual Studio Shared Add-In template. (26 printed pages)

http://msdn2.microsoft.com/en-us/library/aa902693.aspx

Clint