Sorry for the long delay in posting, I’ve been learning new benefits and applications for SharePoint faster than I can share them.
I’m in Seattle this week for the Microsoft field employee TechReady conference. It has been good putting more faces to names and meeting some of the people responsible for the new features in the next version.
There are a lot of things I can’t demo on my site at the moment because my client/server versions are out of sync so I’ll have to save them until the beta 2 technical refresh is available.
One thing I have been using a lot is Microsoft Access 2007 to migrate data from my old sites many lists into the new resources list on this site.
A new use for Access that I only just noticed is that when you create a list view there is an option to create an Access View. This allows you to create to create forms and reports that are based on this list.
Here are the Access view templates available in the UI

I guess the dilemma for many IT departments will be that they may have removed Access from the standard desktop build or, worse, only deploying Office Standard within their enterprise.
Access can now be treated as a valuable information tool for dealing with SharePoint data in a more application like way than just mirroring the list in Excel.