Creating Access Web Apps in SharePoint 2013
Created By
Gini von Courter via LinkedIn Learning
- 0
- 2-3 hours worth of material
- LinkedIn Learning
- English
Course Overview
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.
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.
Course Circullum
Introduction
- Welcome
- Changes for Access Web Apps
- Using the exercise files
- Software needed for this course
- Introduction to Access web apps
- 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
- Entering data using a view
- Modifying a view
- Creating a new view
- Working with view settings
- Adding a calculation for related items
- Managing views
- 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
- Next steps
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Welcome
- Changes for Access Web Apps
- Using the exercise files
- Software needed for this course
- Introduction to Access web apps
- 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
- Entering data using a view
- Modifying a view
- Creating a new view
- Working with view settings
- Adding a calculation for related items
- Managing views
- 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
- Next steps
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:2-3 hours worth of material
- Language CC: