Join Gini von Courter for an in-depth discussion in this video Changes for Access Web Apps, part of Creating Access Web Apps in SharePoint 2013.
- [Instructor] Whether you're just starting with Access web apps for SharePoint or have been working with it for a while, make sure you watch this movie. There have been some changes that are important that you know about, particularly if you are working in SharePoint Online. As of the end of the first quarter of 2017, Microsoft is no longer recommending creating and using Access web apps in SharePoint. What does that mean? Well, it depends on your SharePoint environment. If you are using SharePoint Online, then Access web apps are being retired from Office 365.
As of the end of June you can no longer create new apps in SharePoint Online. If you have existing SharePoint apps, if you have existing Access web apps in SharePoint Online they will continue to work but only through the end of April 2018. If this is the first you're hearing of this news and you have some apps, I'll give you a moment to breathe. There is a new strategy. This doesn't mean you can't create apps at all but you can't use Access to do it. You can create new apps using Microsoft PowerApps, a new set of tools and you have the ability to port existing Access web apps to PowerApps.
At the end of this course I've added a movie to show you how to do that, therefore, if you already have existing Access web apps and you are in the SharePoint Online environment and need to move those to PowerApps, you can get some guidance both from Microsoft and in this course. You have a slightly different timeline if you are using SharePoint Server 2013 or SharePoint Server 2016, SharePoint On Premises. The two features that are used to support Access web apps are called Access Services and Access Web Apps and they will both be included not just in the current version but in the next version of SharePoint Server whenever that comes out, so they're included in SharePoint 2016, they'll also be included in the next version and support for Access Web Apps and Access Services will remain through the product lifecycle for SharePoint.
What that means for example for SharePoint Server 2016 is if you have Access web apps running or created in SharePoint Server 2016, you'll have mainstream support for those through July of 2021, you'll have extended support through July of 2026. That's a decade almost from now. That's not too bad. So, what would you do today if you're running SharePoint On Premises? You might still choose to create some new apps in Access Web Apps or you could use PowerApps.
And then you have a much longer timeframe to be able to migrate your Access web apps. You might wonder, why would I continue to create Access web apps rather than PowerApps? And the reason would be that you have the infrastructure set up to create Access web apps but you don't yet have the infrastructure for PowerApps. If you'd like to know more about PowerApps we have two courses in the online training library that will help you. First, Learning Microsoft PowerApps which will show you how to create a generic PowerApp using Microsoft Excel and OneDrive as your platform.
Working specifically in SharePoint, look at SharePoint 2016 No-Code Workflows which uses Microsoft PowerApps and Microsoft Flow to create the same types of applications that we might create using Access Web Apps but these applications created with PowerApps will be mobile-first apps, an advantage that we don't get with our Access Web Apps. In summary then, if you are working with SharePoint Online and Office 365 the only movie you need to view is the movie at the end of the course on how to migrate your existing Access web apps.
If, on the other hand, you are working in SharePoint On Premises and you'd like to learn more about Access Web Apps then you'll need either Access 2013 or 2016. This feature was new with 2013 and you'll need SharePoint Server On Premises 2013 or 2016.
- 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.