• Article

Access Services

Version: 1.0

Description

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.

Overview

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.

System Requirements

You must have the following items to complete this lab:

  • SharePoint 2010
  • Visual Studio 2010
  • SharePoint Designer 2010
  • SharePoint Online site
    • Note: You will need administrator access to an SPO site collection to perform the steps in this lab.
Note:
These setup instructions apply to all the labs in this unit; you don’t need to repeat these steps if you already performed them in the first lab in the unit.

Task 1 – Create SharePoint Online Site

In this task, you will create a sub site for this lab in your SharePoint Online site.

  1. Navigate to your top-level SharePoint Online site, e.g., https://contoso.sharepoint.com.
  2. From Site Actions, choose New Site.
  3. Choose the Express Site template.
  4. Enter Lab05 for the name of the site to create.
    1. The site will be created at <Your SharePoint Online URL>/Lab05, e.g., https://contoso.sharepoint.com/Lab05.
  5. Click Create to create the site.
    Note:
    You have to be an administrator on your SharePoint Online website to perform the tasks in this lab, e.g., creating and publishing a SharePoint Designer workflow to the 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.

  1. Browse to C:\%Office365TrainingKit%\Assets\Code Snippets
  2. Select all the files in this directory and copy them to your clipboard by pressing [Ctrl]+[a] and then [Ctrl]+[c].
  3. Browse to ..\Documents\Visual Studio 2010\Code Snippets\Visual C#\My Code Snippets Press [Ctrl]+[v] to paste the code snippet files into this directory.
    Note:
    To reduce typing, you can right-click where you want to insert source code, select Insert Snippet, select My Code Snippets and then select the entry matching the current exercise step.

next >

Downloads

Download The Offline Training Kit
Download Hands-on Lab Document (DOCX)
Download Hands-on Lab Source Files

Contents