Learn how to use the Saved Export tools to send a PDF of your reports to a SharePoint document library.
- [Instructor] It's been my experience that…people love their paper reports,…and they've become used to having those reports.…And again, when we integrate into SharePoint,…we want to make that reporting a little bit easier.…Let's learn how to export our reports to SharePoint.…So let's go to Home.…I'll click Home on my SharePoint site,…and I have a folder called Documents.…It would be great to be able to put our PDF copies…of those reports into Documents.…So let's click on Documents.…Let's go ahead and click up top,…and let's copy the path to Documents.…
All right, just for testing purposes,…I'm going to go add a new tab and I'm going to paste…and go there, just to verify that that link is a good link.…Perfect, okay.…So let's build macros that export our PDF reports…directly to this Documents folder.…Let's go back to our database.…We'll go ahead and close the closed issues.…Let's go to Create, let's choose Macro.…On the Design table let's go ahead and Show All Actions.…
And I'm going to drag a comment,…this exports our reports to SharePoint.…
- 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.