Learn how to import tables from another Access database.
- [Instructor] Once you have…your development database all set,…then it's time to go ahead and move it into production.…Let's get started.…I'll go ahead and minimize my SharePoint site,…I'll go ahead and close my exports,…and scroll up to my table here.…I'm going to go ahead and remove all my original tables…that I started with.…So, I'll go ahead and delete the contacts.…It tells me that it needs to delete those relationships,…and I'll go ahead and say yes to that.…I'll go ahead and delete my customers original table.…
I'll go ahead and delete my original issues.…And paste errors has been something…that's been with us from the very beginning,…and maybe that's something…that happened early on in the database…before we ever started.…We don't need it in our new production database,…so we'll go ahead and delete it as well.…We don't need that customers list,…we imported that earlier,…we'll go ahead and delete that.…Filters is our only local database,…and again, that works with our form.…So we've gotten rid of the tables we don't need,…
- 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.