AuthorGini von Courter
- Creating a new app
- Building tables from different sources
- Creating relationships between tables
- Working with views
- Using macros for automation
- Saving your app in an app package
Skill Level Intermediate
- [Instructor] Hi, I'm Gini Courter. Welcome to Creating Access Web Apps in SharePoint. Access web apps are databases complete with tables, forms, and macros, but they live in SharePoint, so they're available to all of your users, whether or not they have Microsoft Access on their computers. In this course, I'll show you how to create a custom web app. You'll see how to import data or link to existing SharePoint lists, or create new tables and queries. Then we'll build the user interface, creating and modifying views which are the web app version of forms.
With our data tables and user interface in place, we'll add macros to automate our web app. And we'll end by saving our app in a package that can be installed on another SharePoint site. You'll be amazed at how quickly you can create an Access web app so that you and your team can collaborate and share data using the combined power of Access and SharePoint. Let's get started.
Q: The "Using the If macro action" movie seems to end in the middle of troubleshooting. What am I missing?
Q: This course was updated on 08/25/2017. What changed?
A: New videos were added that cover changes for Access Web Apps and migrating Access Web App data to SharePoint Online.
SharePoint 2013 for Site Champions and Power Userswith Mark Abdelnour2h 57m Intermediate
1. Creating a Simple Access App
2. Working with Views
3. Automating and Packaging
Next steps1m 35s
- 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.