Join Gini von Courter for an in-depth discussion in this video Introduction to Access web apps, part of Creating Access Web Apps in SharePoint 2013.
- [Narrator] This is an Access web app. It's the Access web app that we're going to create in this course and it's something that can be created in a matter of hours rather than a matter of days or weeks and it runs in a browser. It's hosted in SharePoint. We have tables. Those tables have relationships. Users can add new items to tables. They can delete items. Edit items if they wish. We have different views, data sheet views, and list views. And we have the ability to add code or macros so we can do some pretty remarkable things like create a filter that finds the open issues that are due in the next 30 days or reports that there aren't any.
We have navigation that's just beautiful and the ability to look at comments or related issues for different issues that we're examining. We can look at any of the tables so we can look at an employee for example and find any items that were opened by that person or issues that were assigned to them. And the background that we see is actually based on the site because this is running inside of SharePoint. This is part of the KinetEco Team Site so if I say I want to go back to the site, I'm simply leaving this particular app and returning to KinetEco.
For those of you who are SharePoint focused, if we go take a look at the site contents, what you'll find is that this app called issues lives right here inside of SharePoint. So what is an Access web app? Access web apps allow you to collaborate with your team or organization with your data securely on the web in a browser. Apps can be simple like the app I just showed you or incredibly complex. You can jump start your app creation process by using templates. That's what we're going to do.
Or you can create totally custom apps building every single table from scratch or importing data from tables that you have already. So if you imagine that you have a data table that you want to share and have many people be able to work with it and be able to view it, one way you can do that is in a SharePoint list. But another way that you could do that would be to take that same data from Excel or wherever it's stored now, perhaps even in a SharePoint list, import it into Access and create a web app that would allow all of your users to work with that data in an environment that's relatively easy to create and easy to maintain.
Access web apps are brand new for Access 2013. Access web apps were new in Access 2013. They're also available in 2016. Access web apps are Access applications that are hosted in Microsoft SharePoint, originally in SharePoint Online or SharePoint On-Premises, but now you can only create new Access web apps in SharePoint On-Premises and existing web apps that were created in SharePoint Online or SharePoint for Office 365 need to be migrated to work with power apps rather than with web apps.
If you're in a SharePoint On-Premises environment though, you will design or modify your web apps using the tools that you have in Access. You are going to design these using the tools that you have in Access. So this is my design environment. I can work with tables and edit them. If you're an Access person, that should look familiar. And I can also edit the forms which are called views. I also have the ability, if I wish, to add queries and to add macros.
And of course, when I'm done, my product runs in a browser. That means that I don't need to ensure that anyone has access to Microsoft Access. Many organizations only put Access on some desktops rather than all. And if you're thinking, "I'd like to do some development in Access, "but not everybody has it," they don't need to as long as they have SharePoint and you have Access 2013. This is a step up from the last version. In Access 2010, we had web databases and they stored their data in SharePoint lists.
They ran on Access Services 2010. Web apps, on the other hand, are created and designed in Access 2013. Their data is stored in SQL Server and in the newest version of SQL Server. You can't use SQL 2008. You need to use SQL 2013 and run Access Services 2013. What that means is that if you have a web database, you really can't simply upgrade it. There's not a migration path for that. So if right now you are working in the environment that you see on your right where you have Access 2013 available to you, you have SQL Server 2012, you have SharePoint Online or SharePoint On-Premises running Access Services 2013, there is no reason that you would develop a web database because web apps, not web databases, are the future.
They create browser-based applications that are simple and easy to use. Who wouldn't love this? If you were an Access developer in the past, particularly if you haven't done this in a while and you're wondering is there something in this for me, this is different than anything you've seen before in Microsoft Access. And if you're primarily a SharePoint power user and you're wondering, is there something that I might want to learn here? If you have data you want to share, I would like to encourage you to take a look at what you can do with Microsoft Access 2013 web apps for SharePoint.
Let's get going.
- 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.