Learn how to modify forms to include SharePoint functionality. Learn how to use command buttons to launch forms and run macros.
- [Instructor] As we've already discovered,…if the names of our SharePoint list…match the names of our original tables…our forms automatically know how to interact,…but as we add new features…we want to update our existing forms.…In our Access database…let's go ahead and close all of our open tabs.…And the Issues List is the main form that opens.…Let's go ahead and double-click the Issues List.…Now we want to go ahead and add our forms for Location…and Customer and add those launch macros…where we can launch those SharePoint lists.…
So let's start out by right-clicking the Issues List…and going to Design View.…So I'm going to go ahead and add command buttons…to launch those forms.…I'm going to put them to the right of the Contact List.…I want to maintain consistency with my labels…and my images.…I'll go to Design, I'll go to my command button,…and then I'll go click on my form…and draw my button out there.…I'm going to launch a form…and I'm going to open a form…and I'm going to open Customers.…
I'll choose Next.…I want to show all the records, I'll choose Next.…
- 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.