Creating Access Web Apps in SharePoint 2013

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!

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! Gini Courter walks through creating a simple Access web app with data imported from Excel, linked via SharePoint lists, or even from tables you create from scratch. She also shows how to define relationships between the tables in the database, create a user interface from views, use macros to automate events and calculations, and bundle your app in a package that can be installed on another SharePoint site.

Introduction

• Welcome
• Changes for Access Web Apps
• Using the exercise files
• Software needed for this course
• Introduction to Access web apps

1. Creating a Simple Access App

• Enabling Access in SharePoint
• Creating a new app
• Creating tables from a template
• Launching the app
• Viewing relationships
• Creating a table from Excel data
• Creating a table from a SharePoint list
• Creating a new table from scratch
• Deleting relationships and tables
• Creating relationships between tables
• Creating a query
• Formatting the table icon
• Changing settings in the list control

2. Working with Views

• Entering data using a view
• Modifying a view
• Creating a new view
• Working with view settings
• Adding a calculation for related items
• Managing views

3. Automating and Packaging

• Understanding view events
• Understanding web macros
• Creating a simple web macro
• Understanding data events and data macros
• Creating a simple data macro
• Running a macro from an action button
• Creating a data macro to check for records
• Using the If macro action
• How to report on web app data
• Saving your app as an app package
• Migrate Access Web App data to SharePoint Online

Conclusion

• Next steps