300 likes | 499 Views
CSC203. Access 2007 with SharePoint Better Data Manageability. Mbwana Alliy Product Manager- Office Managed Business Microsoft Corporation malliy@microsoft.com. What will be Covered. Why use Access and SharePoint Key Capabilities Key Scenarios Customer Case Study Questions & Feedback.
E N D
CSC203 Access 2007 with SharePointBetter Data Manageability Mbwana Alliy Product Manager- Office Managed Business Microsoft Corporation malliy@microsoft.com
What will be Covered • Why use Access and SharePoint • Key Capabilities • Key Scenarios • Customer Case Study • Questions & Feedback
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
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
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
Databases: Organizational view Flexibility & Rapid Application Development Complexity Security Reliability Scalability Cost
Collaborative Data Applications • Applications that are based on tracking data about concepts like • Orders • Customers • Documents • Processes • Used by • Teams • Departments • Enterprises
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
Get Productive Quickly • Getting Started with Access 2003 • New! Start with prebuilt applications with Access 2007
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
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
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
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.
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
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.
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.
Limitations- Customer feedback • Over 5,000 rows/records, performance may slow • At this point, it’s probably time to migrate.
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
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.
Resources • Microsoft Access Homepage http://office.micorosft.com/access • The Microsoft Office Access blog http://blogs.msdn.com/access • E-mail malliy@microsoft.com
SUBMIT AN EVALUATION For a chance to win an 8GB ZUNE! Submit evaluations on MySPC www.MicrosoftSharePointConference.com
© 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.