Author Webcasts from Que Publishing

Webcast Archive: Moving Access Tables to SharePoint 2010 or SharePoint Online Lists

Presented by Roger Jennings

The Microsoft Access Team recommends using SharePoint lists as the shared data source for secure multi-user queries, forms and reports. If you don't have access SharePoint Services v3 for Windows Server 2003 [R2] or SharePoint Foundation 2010 for Windows Server 2008 [R2], your network administrator can install one of these no-charge add-ons in a few minutes. In this case, your IT department is responsible for backing up and managing your data. Alternatively, you can subscribe to Microsoft's low-cost Office 365 (formerly Business Productivity Online Suite, BPOS), which includes a hosted SharePoint Online instance, or to an instance provided by a Microsoft partner. In this case, you should maintain local data backups unless the the provider assures your data is backed up and always available. The SharePoint administrator manages read and update permissions for data. In this webcast, you’ll learn to:

  • Create a SharePoint-compatible application from an Access template
  • Subscribe to trial Office 365 SharePoint hosting services
  • Move your application’s tables to hosted SharePoint services with a wizard
  • Synchronize locally-stored (cached) copies with the master SharePoint list data
  • Establish role-based authentication and authorization security for intranet users
  • Deploy Web Databases to SharePoint Online’s Access Services feature
  • Modify an existing Access app to replace relationships with SharePoint lookup tables

Roger JenningsRoger Jennings is an author and consultant specializing in Microsoft .NET, SQL Server, and Access database applications, as well as Windows Azure and SQL Azure cloud computing projects. He was a technical beta tester for all 10 editions of Microsoft Access; SQL Server 6.5, 7.0, 2000, 2005, 2008, and 2008 R2; every release of Visual Basic since version 2.0 and Windows 3.1; and all subsequent Microsoft Windows operating systems. He also was one of the founding members of Microsoft's former Access Insiders group. Roger Jennings is a principal of OakLeaf Systems, a Northern California software consulting firm. He is the author of many Que titles such as Microsoft Access 2010 In Depth plus Roger Jennings' Access Blog .