Learn how to create append queries to add data to SharePoint lists. Learn how to write unmatched queries.
- [Instructor] Now that we have our…production data in place,…we need to write the appropriate queries to copy the data…to our SharePoint site.…Let's take a look at our options.…If you've worked with Access database design…then you probably already are aware of append queries.…Now, our production data hasn't updated…because we're working with exercise files that are flat…but let me just go through the motions…to show you some of the query options that you have.…Okay, first of all, we stopped our issues tracking…on a certain date.…Let's go ahead and double click issues.…
We want to go in and pull anything…that has been opened since the date of our copied data.…Let me go ahead and sort…and then I'll sort newest to oldest.…So we want to bring on anything that has been opened…after 3/29 into our database.…We'll do this by writing an append query…and we'll append from issues one to our new issues table…and we'll use the open date to do that.…I'll go ahead and choose close.…
I don't need to save the design.…I can go to create, I'll choose query design,…
- 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.