Access 2019 Bible

CHAPTER 32Integrating Access with SharePoint

IN THIS CHAPTER

• Getting familiar with SharePoint sites
• Understanding Access and SharePoint integration
• Linking to SharePoint lists
• Importing SharePoint lists
• Exporting Access tables to SharePoint
• Upsizing Access databases to SharePoint
• Using SharePoint list templates

Throughout this book you've read about the many features that Microsoft has added to Access over the years. As exciting and interesting as these new capabilities are, they pale in comparison to the ability to upsize Access applications to Windows SharePoint Server. Each recent version of Access has demonstrated greater and greater ability to integrate with SharePoint. The most exciting aspect of this integration is the ability to actually run your Access application as a SharePoint website.

In this chapter, we'll explore the various techniques that allow you to upsize your Access databases to SharePoint. This chapter gives you an understanding of what SharePoint is and how it helps organizations share and collaborate data.

Introducing SharePoint

SharePoint is Microsoft's collaborative server environment, providing tools for sharing documents and data across various organizations within your company network.

SharePoint is typically deployed on a company's network as a series of SharePoint sites. A SharePoint site is configured as an intranet site, giving various departments the ability to control their own security, workgroups, documents, and data. These sites ...