Access 2007 with SharePoint Better Data Manageability

2. CSC203 Access 2007 with SharePointBetter Data Manageability Mbwana Alliy Product Manager- Office Managed Business Microsoft Corporation malliy@microsoft.com

3. What will be Covered • Why use Access and SharePoint • Key Capabilities • Key Scenarios • Customer Case Study • Questions & Feedback

4. Data tracking needs

5. Access is thriving! “A growing number of enterprises are using Microsoft's Access desktop database. Yuhanna says 25 percent used Access in some form three years ago, and now that figure is up to 40 percent.” Forrester quote, Redmond Developer December 2007

6. Customer Challenges Too much information to track • Where do I start? • Database software is too hard to use • Most of my information is already stored in another application Access 2007 offers: • A library of prebuilt applications • Results-oriented user interface • Paste your data from Office Excel® or import contacts from Office Outlook® Access 2007 offers: • One click report creation • WYSIWYG Report editing • Grouping Pane simplifies changing views • Filter options adapt to data type Make sense of complex information • Little time for decision making • Decisions have many dependencies • Same data feeds different decisions Sharing and managing information • Increased reliance on others • Too much data is scattered in hard disks • Increased pressure from compliance and regulations Access 2007 offers: • Easy data migration to Windows ® SharePoint® Services keeping • Work online or offline • Permission-based Web access to data • Records revision history tracking

7. Challenges turn into Opportunities & Risks • Lowers the bar for end users and information workers to create and share applications. • Risk of poorly designed applications created that are business critical. Sharing and managing information • Increased reliance on others • Too much data is scattered in hard disks • Increased pressure from compliance and regulations Access 2007 offers: • Easy data migration to Windows ® SharePoint® Services keeping • Work online or offline • Permission-based Web access to data • Records revision history tracking

8. Databases: Organizational view Flexibility & Rapid Application Development Complexity Security Reliability Scalability Cost

9. Collaborative Data Applications • Applications that are based on tracking data about concepts like • Orders • Customers • Documents • Processes • Used by • Teams • Departments • Enterprises

10. How Does Access Deliver • Rich client development environment: • Codeless development • Single or multi-user applications • Connects to different data storages • Integration with Microsoft Office system • Excel, InfoPath and Outlook integration

11. Get Productive Quickly • Getting Started with Access 2003 • New! Start with prebuilt applications with Access 2007

12. How Does Access Deliver • Windows SharePoint Services • Collaboration and workflow • IT Managed data source • Security • Web permissions • List item permissions • Archived • IT archives the server • Version history • Recycle bin • 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 Build and deploy, reliable, IT managed applications easily

15. Different Users 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 SharePoint 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

16. Server-Based Collaboration • Dual entry mode • Move data from Access applications to server • Open WSS lists with Access and extend with richer Access objects • Access as rich front end to WSS • Reach web access to data • Report and form views published on web site • Integrated workflow: solutions can integrate pre-defined workflow for rich scenarios • Extend work offline

17. Manage and Audit Information • Data Server Backup: Migrate data from your local database file to a server with Windows SharePoint Services • Permission Setting: Manage which users have access to your data • Recycle Bin: Recover lost data • Revision History: Track records and see who created, edited, or deleted information.

18. Collecting Information • Avoid chasing coworkers for updated information. • Collect new information by e-mail • Keep information up to date • Use automatically generated Microsoft Office InfoPath or HTML

20. Access deployment options in SharePoint

21. Key Scenarios • As a landing pad and collection point for disparate data sources • Collect data from multiple SharePoint lists • Other data • Excel Spreadsheets • ODBC connections (e.g. SQL) • Even e-mail… • Create reports and republish back to SharePoint • Move your desktop based application onto SharePoint • Visible by IT • Audit and backup.

22. Key Scenarios • Set up templates for other users to access and update information and publish back reports in lists. • A method to deploy “approved” applications. • Manage user access/permissions • Use Access client as a reporting front end.

23. Limitations- Customer feedback • Over 5,000 rows/records, performance may slow • At this point, it’s probably time to migrate.

24. How others are using it • SharePoint & Access as a B2B platform, not intranet • 18,000 vehicles in 28 countries. • SharePoint holds data from a management/strategic perspective- feeds MIS on SQL backend • Access Client updates the SharePoint with the management data • Conducting tenders- 10 OEMs quoting terms and conditions for a fleet in all 28 countries

25. Summary: Access & SharePoint • Database driven environment connected to a server/portal and great place to bring in your LOB applications. • Access and SharePoint helps empower end users: • Bring together different data sources, in a rich client • Manage that data • Share and collaborate.

26. Questions?

27. Resources • Microsoft Access Homepage http://office.micorosft.com/access • The Microsoft Office Access blog http://blogs.msdn.com/access • E-mail malliy@microsoft.com

28. Post Event DVD brought to you courtesy of:

29. SUBMIT AN EVALUATION For a chance to win an 8GB ZUNE! Submit evaluations on MySPC www.MicrosoftSharePointConference.com

30. © 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.