I’ve not used Access for, oh, years now I think… but here’s an interesting video on Channel 9 showing new features in Access 2010 and Access Services:
http://channel9.msdn.com/shows/Access/Microsoft-Access-2010-Demo/
Not only can you publish Access databases, including any UI, up to Sharepoint in Office 2010, but you can create reports in your Access database and once they get published they become SSRS reports (the last few minutes of the video talks about this). Yet another way to create dashboards and BI reports then…
Chris – Alan Cossey and I will be demonstrating the new Access 2010 features including SharePoint 2010 integration (now that NDA is lifted) at the UK Access User Group National Seminar on 26th November – some initial details here http://www.ukaugcommunity.co.uk/Lists/Announcements/DispForm.aspx?ID=12Derek Goodridge
where to find a summury of all ways to create bi report and their pros and cons?"Yet another way to create dashboards and BI reports then…"
I don\’t think there is one, certainly not one that crosses the whole MS stack. Perhaps a subject for a future blog post…