Discover things to consider when designing Access databases and integrating SharePoint for expanding data access and reporting.
- [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…
- Building an Access table and a SharePoint list
- Linking a SharePoint list to Access
- Exporting a table to SharePoint
- Connecting SharePoint to Access
- Creating macros to open lists
- Modifying Access forms
- Working with views
- Building reports for your integration
- Building views for data in SharePoint
- Sharing a SharePoint site with permissions
Skill Level Intermediate
SharePoint 2016: No-Code Workflowswith Gini von Courter1h 19m Intermediate
Access 2016: Reporting to Web Systemswith Adam Wilbert1h 47m Intermediate
SharePoint 2016: Branding SharePoint Siteswith Gini von Courter56m 10s Intermediate
1. Aligning Data between SharePoint and Access
2. Connecting SharePoint to Access
3. Building Forms for Your Integration
4. Building Reports for Your Integration
5. Building Views for Data in SharePoint
6. Generating Excel Reports for SharePoint
Linking data to Excel2m 26s
7. Finalizing the Database for Production
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.