Learn how to build your lists into calendar views. Calendar views provide valuable visualization of information that is date sensitive.
- [Instructor] One of the benefits of adding…your Access data to SharePoint lists…is that you can build views that are not easily accomplished…with Access or Excel.…Let's go build a calendar view…so we can visualize our due dates.…So from the list tab, let's choose create view.…We'll do a calendar view.…Okay, let's go ahead and call this Due Date Calendar.…It's going to be a public view.…
So we're not going to worry with timing on this.…We just want to see the dates…that these active issues become due…so we're going to hit the begin column…and we'll choose due date…and end column and we'll choose due date.…When we look at the calendar,…we want to be able to see what issue is actually due…so the month view title is actually going to be title,…the week view title, again if we're looking at the week,…we want to see the actual title so what the task actually is.…
We don't have to have a subheading but if we wanted to,…we could choose that.…We'll go ahead and choose assign to.…The day view title,…again I do want to be able to just see the title.…
- 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.