IV. DESCRIPCIÓN DE LOS ESTUDIOS
4.3. Estudio Socioeconómico y de Expectativas Educativas
Data was copied in the previous section so that the same data could be stored in both a list on a SharePoint site and either an Access app or an Access desktop database. If you do not want to maintain two copies of that data, but you do need to refer to the data within the Access app or an Access desktop database, then Access provides methods of accessing
12 12
Linking Linking to to a a listlist 435435
external data that are physically located outside an Access database, known as linked tables, which were known as attached tables prior to Access 95.
TIP
TIP When using linked tables to reference a SharePoint list in an Access app, Access 2013 currently only supports read-only connections to SharePoint lists. Also, the list must be in the site where the Access app was added.
The easiest way to reference a SharePoint list externally is to use linked tables. You should use linking rather than importing if the data is maintained by either a user or a separate ap-plication on the SharePoint website. Also, to set up a connection to a list, the user who cre-ates the linked table must have Change permissions rights to the list.
With a desktop database, the data from the linked tables is cached in local tables when the user is online with SharePoint, thereby improving large list performance. When server con-nectivity is lost, the database automatically goes into offline mode. When concon-nectivity is restored, Access automatically synchronizes data changes for you. Text in the far right of the status bar at the bottom of the Access window indicates the connectivity status of Access with SharePoint.
With an Access app, the data is not displayed in Access; it is displayed in the browser and data is directly accessed from the tables in the app's database.
TIP
TIP External content types can be used to reveal external data in Office 2013 and Microsoft Office 2010 applications, including Access 2013 and Outlook 2013. Information on how to create External content types and how to use them in Access 2013 can be found in Chapter 22, "Working with external content," in Microsoft SharePoint 2013 Inside Out , by Darvish Shadravan, Penelope Coventry, Thomas Resing, and Christina Wheeler (Microsoft Press, 2013).
In this exercise, you will link a table to a SharePoint list, enter data in Access, and check that the data appears in the list.
SET UP
Start Access 20Start Access 2013 and 13 and open the open the ExpImpWideWorldImporters.ExpImpWideWorldImporters.accdb databaseaccdb database that you used in the previous exercise, if it is not already open. You can use your own that you used in the previous exercise, if it is not already open. You can use your own Access database if you wish. Remember to use your SharePoint site location in place of Access database if you wish. Remember to use your SharePoint site location in place of http://wideworldimporters in the following exercise. in the following exercise.IMPORTANT
IMPORTANT Verify that you have sufcient rights to edit items in the list. If in doubt, see Appendix A.
1
On the Access ribbon, click the External DataExternal Data tab. In the Import & LinkImport & Link group, click MoreMore, and then click SharePoint ListSharePoint List. If an Access dialog box opens, stating that all objects must be closed prior to continuing this operation, click YesYes to close the objects.2
On the Get External Data - SharePoint SiteGet External Data - SharePoint Site dialog box, in the Specify a SharePointSpecify a SharePoint sitesite area, select the site that contains the list to which you wish to link.TROUBLESHOOTING
TROUBLESHOOTING If the URL for the SharePoint site does not appear, type the URL in the text box.
3
Check that the Link to the data source by creating a linked tableLink to the data source by creating a linked table option is selected, and then click NextNext.4
On the Choose the SharePoint lists you want to link toChoose the SharePoint lists you want to link to page, select the check box to the left of the list to which you wish to link, such as exportFurniturePricesexportFurniturePrices.5
Click OK OK .6
Under TablesTables, right-click the linked exportFurniturePrices1exportFurniturePrices1 table, and then select More optionsMore options.
7
Click Open Default ViewOpen Default View to display the exportFurniturePricesexportFurniturePrices list in the browser.12 12
Linking Linking to to a a listlist 437437
8
Switch back to Access. Under TablesTables, double-click exportFurniturePrices1exportFurniturePrices1 to open the linked table in Datasheet view, and then click the cell in the rst row under the Furniture NameFurniture Name column, and type Base UnitBase Unit.
9
Click the cell in the second row under the Furniture NameFurniture Name column.IMPORTANT
IMPORTANT By moving to another row, Access automatically synchronizes changes to the SharePoint list.
10
Switch back to the browser, click RefreshRefresh, and then verify that the rst row has been modied.11
On the ribbon, click the ItemsItems tab, and then click New ItemNew Item in the NewNew group.12
In the StockNoStockNo text box, type W0033W0033, and then click SaveSave to add the W0033 list item to the list.TIP
TIP To see the new item in the browser, you will need to scroll to the bottom of the list and click the right arrow to display the next page.
13
Switch back to Access. On the HomeHome tab, in the RecordsRecords group, click Refresh AllRefresh All.+
CLEAN UP
Exit the Exit the ExpImpWideWorldImporters.ExpImpWideWorldImporters.accdb database and accdb database and close any close any openopen browser windows.browser windows.