Learn the no-code way to create powerful browser-based SharePoint apps that let users view and enter data from many sources: Access, Excel, and even SharePoint lists!
- [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.
- 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
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.