Learn how to create macros that will allow you to launch directly to your SharePoint lists via your database using OpenSharePointList.
- [Instructor] When people start using SharePoint and…Access together, you may want your users to be able to…access the SharePoint list from inside the database.…We can create simple macros to do this,…let's go take a look at our database.…So, lets go ahead and choose create, and lets go to Macro.…We want to create a macro that will actually launch the…issues list, and we want to launch the issues list in…SharePoint.…One of the key design elements for a database is that…you don't want to give your users access to the tables,…so they won't use that feature where we right click,…go to more options, and then open the default view.…
But we do want them to have that flexibility.…The easiest way to do that is to create a macro that uses…open SharePoint list.…I'm going to go to show all actions, and the very first thing…I want to do is have accessed select the Issues list.…So I'm going to choose, 'SelectObject' and the object I want to…select is the Issues.…And I just want the plain Issues.…You do want to select it in the Database Window.…
- 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: Branding SharePoint Siteswith Gini von Courter56m 10s Intermediate
SharePoint 2016: No-Code Workflowswith Gini von Courter1h 19m Intermediate
Access 2016: Reporting to Web Systemswith Adam Wilbert1h 47m 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.