How I can Work with Windows SharePoint Services in access

70. How to Modifying Data Types
71. How to Insert Predefined Fields
72. How to Work with Windows SharePoint Services

70. Modifying Data Types
To view or change the data type:
1. Click a cell.
2. In the Datasheet contextual tab, the Data Type and Formatting section displays the data type.
3. To change the data type, in the Data Type box, click the arrow, and then select the type you want. (Note: You may need to retype the value in your cell or cells if the type is not compatible.)
4. In the Format box, click the arrow to format how the data is displayed.
5. Select Is Required if you need to make this field mandatory. To make table and field definitions easier, Microsoft Office Access has a set of predefined templates.

71. Inserting Predefined Fields
To insert a predefined field:
1. In datasheet view, on the Ribbon, in the Fields and Columns section, click New Field.
2. In the Field Templates pane, select the field you want, and then drag it to your table.

72. Working with Windows SharePoint Services
Microsoft Office Access 2007 is deeply integrated with Windows SharePoint Services to offer a Web-based user interface, alerts, revision history, RSS feeds, a Recycle Bin, and central IT manageability. To take advantage of the capabilities offered by Windows SharePoint Services, you must move your data to the server and create a link between each Access table and the Windows SharePoint Services lists.
To move data to Windows SharePoint Services:
1. Close all open objects in Access.
2. On the External Data tab, click Move to SharePoint.
3. Type the URL of a site to which you have editing rights, and then click Next. If you want to save a copy of the Access data, click Browse, and then select a document library. Access creates a Windows SharePoint Services list for each Access table.
After your data moves to Windows SharePoint Services, you cannot change the table schema in Access. You must modify the Windows SharePoint Services list. For quick access to the list from Access, right-click the orange table icon, and then on the SharePoint List Options shortcut menu, click Open Default View.