Azure Database Ganso

We will use Microsoft Excel / Access / Azure / Office 365 to share information sharing the database from this site.

Create tables in SharePoint Online (or convert from Access)

SharePoint is a Web-based collaborative platform provided by Microsoft.

 

If you use SharePoint Online custom list as Access table, you can cloud and convert Access data.

I will explain how to set it.

 

When you sign in to Office 365, a screen like the one shown below appears.

Select [Sites].

 

f:id:muramoto1041:20151220134703j:plain

  

We will add the application to the site content.

f:id:muramoto1041:20151220135846j:plain

The app to be added is [Custom List].

f:id:muramoto1041:20151220140003p:plain

Create table 1.

f:id:muramoto1041:20151220140132p:plain

Table 1 of the custom list was made.

f:id:muramoto1041:20151220140240p:plain

Set the table.

f:id:muramoto1041:20151220140444p:plain

Add a column to the table.

f:id:muramoto1041:20151220140826p:plain

 

Enter "Field 1" for the column name and press [OK].

f:id:muramoto1041:20151222173347j:plain

 

In this way, we will link settings created in SharePoint with Access.

f:id:muramoto1041:20151222175355p:plain

 

A custom list created in SharePoint will be displayed, so you can check it and set the link.

f:id:muramoto1041:20151223190622p:plain

 

Converting an Access database to a custom list of SharePoint Online allows you to create custom lists efficiently.