Join Robin Hunt for an in-depth discussion in this video Exercise files, part of SharePoint: Integrating with Access.
- [Instructor] You have access to the exercise files I use in this course. I have them here in the folder on my desktop. You can download them from the course homepage. There are folders for each chapter and inside each folder are the relevant exercise files for each movie. We'll also make a copy of our production database in the production database folder. You also want to make sure you have full access to a SharePoint online site. We'll be working off a basic SharePoint online site collection that is set up as a team site. Because we're building lists and designing pages you'll want to be sure that it's a test site.
There are many versions and flavors of SharePoint. You'll encounter things like classic view or maybe even the new user experience. SharePoint online is constantly evolving. In every version you can navigate to create things via the site contents. If your version or screen looks a little bit different from mine that's okay, the core functionality we cover should still exist assuming you have the correct permissions. I have site collection admin permissions for this course. If you decide to jump in the course later in the exercises be sure to create the locations and the customer list in SharePoint like we discussed in chapter one.
You'll also need to export contacts and issues to SharePoint discussed in chapter two of this course. Then you'll need to link your list to your database file using the link table manager discussed in the last video of chapter two.
- 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.