Microsoft Office Access 2007 A rich client for Windows SharePoint Services 3.0

1. Microsoft Office Access 2007 A rich client for Windows SharePoint Services 3.0 Mark Bower Senior Consultant Microsoft UK http://blogs.msdn.com/bowerm

2. Challenges • Trend towards Web applications • Centralised and Managed vs. Decentralised and ad-hoc • Collaboration & Sharing • MSDE & SQL Express

3. Introducing Access 2007 Allows end users to easily track information, build quick business applications, and collaborate via Windows SharePoint ServicesGives professional developers and IT easy to customize and manage business applications that combine the best of the client and server Pro Developers / IT Power Users Whole new class of apps integrated with WSS Rich and reach interfaces Server-side manageability Utilize managed code Confident upgrade path End Users WSS for collaboration WYSIWYG authoringfor forms and reports “Codeless” macros Outlook data collection Much easier to use Out-of-the-box apps Easy to add a field, form, and report

4. Better Together • Microsoft Office Access 2007 • Rich visualizations • Easy to build • Easy to use • Use multiple data sources • Collect data via e-mail • Use the application offline • Windows SharePoint Services 3.0 • Collaboration and workflow • IT Managed data source • Security • Web permissions • List item permissions • Archived • IT archives the server • Version history • Recycle bin Build and deploy, reliable, IT managed applications easily

5. Let’s Build A Solution • A Sales pipeline (An Opportunity tracker) • Lists • Opportunities • Employees • Customers • Views • Multiple forms and reports

6. Where Do We Begin? • Start anywhere • On the client with local data • Easy to use move and link wizard for SharePoint • Publish your views • On the server with SharePoint lists • Create your lists and link to them in Access • Create views as you go along

7. Deploying Our Solution • Today • Client / File share • Office 12 • Deploy/ publish the latest version using the site • End-Users would get updated copies of the solution • Use out of the box or customized entry points to launch the solution • Enable design collaboration or lock down your application using SharePoint permissions

8. The Sales Pipeline Solution

9. Recap • Deploying Access Solution to WSS • Creating a new Access solution from WSS • Using WSS as datastore • Conflict resolution • Offline • Data Collection in Email • Versioning and Recycle Bin

10. Raising The Bar • Add external data • Using the client to fetch data from other sources • Using workflow • Process enforced on the server • Reported by the client • Set up reminders for reports • Create them on the client • Distribute them using the server

11. Raising The Bar

12. Why Would I Be Interested? • We’ve built an application that was • Easy to build, deploy, use • Managed by IT • Has rich and robust visualizations • Used multiple data sources • Multi user with workflow • Used offline • Key scenarios • Departmental Solutions • Small-mid market