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.
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
- 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:
- Microsoft Access with SQL Server Blog: New book for Access Web Database and SharePoint now available!
- Utter Access:
Feeling overwhelmed? Contact Advisicon for Microsoft support, training and more.