Microsoft Access in a SharePoint World


SKU: 53c63fb3a4de. Category: .

Product Description

What do you get when you team Microsoft Access with Microsoft SharePoint? You get Access Web Services, an easy-to-use, rapid-development way to build and deploy information-driven databases on the web. Microsoft MVPs Tim Runcie (MS Project), Ben Clothier (MS Access) and George Hepworth (MS Access) have pooled their many years of experience with MS SharePoint and MS Access to bring you this first-of-its-kind look at building and utilizing Access databases for SharePoint.

Microsoft Access in a SharePoint World is a must-read for both developers and the IT community who want to understand how to leverage the power of MS Access in a SharePoint environment.

Book Overview:

Introduction to SharePoint and Access Services

  • What is SharePoint?
  • Line of Business Integration and Reporting Capabilities
  • The Goal of SharePoint
  • What Are Access Services?
  • A Bit of History of SharePoint
  • Defining Role Use of SharePoint and This Book

Why Has SharePoint Grown So Much?

  • Problems Solved by SharePoint
  • Simplified Document Management
  • Decentralizing IT Administration
  • Self-Creation and Self-Serve
  • How the Two Systems Work Together

Business Case for Access Services

  • Why Should You Use MS Access as a Key Tool in SharePoint?
  • Reducing IT Overhead with Data Managed with Access

Overview of Capabilities

  • A New Mindset for Developing Web Databases
  • Publishing Web Databases
  • Access and Other SharePoint Features
  • SharePoint Foundation and Access
  • Access Services and SharePoint Enterprise
  • Hybrid Applications

Designing Web Applications

  • Web Application Design Considerations

Extending Client Applications

  • Anatomy of SharePoint
  • Using SharePoint as a Data Store
  • Using SharePoint to Store and Distribute Access Databases
  • SharePoint, Performance and Optimizations
  • Disconnected Mode and Synchronization
  • SharePoint Lists & ODBC-linked Tables
  • Data Macro Behaviors in Access Client
  • SharePoint Operations
  • Workflows
  • Web Services

User Interface Customization

  • Document Library vs. Attachment Data Types
  • Document Library Considerations
  • Case Scenario
  • Associating Documents to Access Records
  • Linked WebParts
  • Customized SharePoint Menu Actions

Deployment and Security

  • SharePoint Environment Consideration
  • Distributing Client Databases
  • How to Address IT’s Concern of Managing Security
  • Security Considerations


  • SharePoint Integrated with Microsoft Office
  • Final Thoughts, Author Ben Clothier
  • Final Thoughts, Author George Hepworth

What Online Book Reviews are Saying

A lot of people are saying a lot of great things about Microsoft Access in a SharePoint World. Here are some highlights from respected tech blogs around the web:

Feeling overwhelmed? Contact Advisicon for Microsoft support, training and more.