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!
- Hi, I'm Gini Courter. Welcome to Creating Access Web Apps in SharePoint 2013. This course will get you started with one of the most exciting and yet, least explored new features for Access 2013. Web Apps. 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 DataTables and user interface in place, we'll add macros to automate our Web App. And we'll end by saying 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