Considerations

- [Instructor] Before changing anything…in your production database that already works really well,…there are things to consider…and get yourself up to speed on…before you make any changes…of integrating SharePoint and Access together.…Some key considerations for you to understand…is that lists in SharePoint are automatically…available to users who are in that SharePoint site.…You can easily control permissions on a list by list basis…versus in Access where once you give them the database,…they have access to the database.…

Lists can keep a version history…of all of the list items…when they've been changed or modified.…It automatically, for auditing tracks it created,…by and modified by, date and who information,…and the recycle bin for deleted records…can be extremely valuable.…SharePoint is built with data recovery…and auditing in mind.…You ought to ask yourself some basic questions…to see if you're ready to actually convert…your Access database with some SharePoint integration.…If you currently need more data availability…

Resume Transcript Auto-Scroll

Author

Released

4/27/2018

Using the user-friendly data input features of SharePoint Online—along with an Access database—you can build business apps that mobilize workflows and create easy-to-manage databases. In this course, learn how to integrate Access with SharePoint to make data-rich applications. Instructor Robin Hunt shares strategies and techniques that can help you work smarter with these two programs. Robin explains how to align data between SharePoint and Access and set up alerts from Access. She also covers how to build forms and reports for your integration—including how to create views that recreate some of your most valuable reports; how to build views for data in SharePoint; how to generate Excel reports for SharePoint; and how to finalize a database for production.