Building Applications with Access and SharePoint Online

Friends, I am going to show an example of Access App in SharePoint Online. In this example I will add two tables, foregn key relationship in those table

To work with access app for SharePoint Online Access 2013 and Office 365 site is required.

Now I am going to create 2 table

Customers  table with columns  (CustomerID, CustomerStatus, CustomerName, EmailAddress)

Phone table with columns (PhoneID, Customer, Status, PhoneType, PhoneNumber) 

Open Access 2013 >> Click Custom Web App >> Provide SharePoint Online site >>Create

Add table by clicking "Add a new table" link.

Create a customer table with  (CustomerID, CustomerStatus, CustomerName, EmailAddress) columns

Change the CustomerStatus to lookup Field

Save the Table by providing name Customer.

Now you can see List view and forms as below.

Similarly add the Phone table with columns (PhoneID, Customer, Status, PhoneType, PhoneNumber)

Make the Customer Lookup type column as below

This will be the foreign key to customer name.

After saving the table with table name Phone the table should look as below.

Then click the Launch App button and you will be able to view the app in SharePoint Online.

  

View as SharePoint Online App