Learn how to export an Access table to SharePoint to create a new interactive list. Convert existing tables to new interactive SharePoint lists.
- [Instructor] With 20 years of experience in data,…I've see a lot of mission critical data inside…of Access databases.…I love Access databases for sure,…but I can't help but love the benefits…of moving those tables to SharePoint.…Let's take a look.…Often times our tables are already created.…For example, Customers, we just recently created.…Now I don't want to go into SharePoint…and start it from scratch.…I can just simply export Customers and…make a SharePoint list out of it.…
I'll go ahead and right click Customers.…I'll choose Export.…I'll choose SharePoint list.…I'm going to export it to my Issues Tracking list.…I'll go ahead and give it a name.…List of our customers…and notice it says open the list when finished,…which is perfect; I'll go ahead and choose OK.…Now Access with go ahead and export this table…to SharePoint for me and then you'll notice…that I get a Customers list.…
When you export your list to SharePoint this way,…by default, it will open in editing.…You will create views to correct that…so we'll go ahead and choose stop here.…
- 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.