In this lab, you will learn how to use SharePoint Access Services to publish an existing Microsoft Access database to SharePoint Online. Doing so will create a new SharePoint web and convert Access tables into SharePoint lists, and Access forms into corresponding HTML and CSS. You will then use this database as a bug tracking database. You will learn how to proactively log exceptions in SharePoint Online.
Lab Time: 20 minutes.
Lab Folder: C:\%Office365TrainingKit%\Labs\5.2\Source\Before
Lab Overview: In this lab, you will learn how to use SharePoint Access Services to publish an existing Microsoft Access database to SharePoint Online. Doing so will create a new SharePoint web and convert Access tables into SharePoint lists, and Access forms into corresponding HTML and CSS. By publishing a database to SharePoint Online, you allow everyone with access to your site to interact with an Access database without the complexities of sharing an access database file (.accdb).
In the first exercise, you will explore the newly created site to view the site lists that correspond to the Access tables. Next, you will update one of the lists and see the corresponding SharePoint website and Access database updated.
The second exercise will leverage this database to demonstrate how to prepare for and handle exceptions in your solutions after the solution has been deployed to SharePoint Online. You will do this by proactively catching any exceptions and logging the details to a list that was defined as part of publishing the database to SharePoint online.
You must have the following items to complete this lab:
Task 1 – Create SharePoint Online Site
In this task, you will create a sub site for this lab in your SharePoint Online site.
Task 2 – Prepare Code Snippets
This lab contains code snippets that you will use to complete the solution. You can either copy the snippets from the lab script itself or install the code snippets so that you can access them directly from Visual Studio.