Contents
With Microsoft SharePoint Designer 2010, you can connect to a variety of databases, including Microsoft SQL Server, Oracle, and other databases that are accessible by using the OLE DB protocol. By default, your Microsoft SharePoint site does not contain any database connections.
If you have been working with SharePoint as long as we have, you may be frustrated with the fact that SharePoint does not provide the ability to create a relational data model. In fact, all SharePoint list data is stored in a single table called AllUserData.
How do I access my SharePoint site?
SharePoint Sites are accessed via your internet browser, such as Internet Explorer, Chrome, Firefox or Safari. If you’ve already been given access to a SharePoint Site, you may receive an email invitation to the Site. 1. Click on the link in the invitation email to open the SharePoint Site in your browser.
1. Open the SharePoint Application. Open Actions menu > Open in Microsoft Access. 2. Link the data to the SharePoint site. 3. Create the database: tables, forms, query, etc. Or, you can create new Access Database to SharePoint via Ms Access: 1. go to File > New and choose Custom web app (2013) or Blank Web Database (2010).
Get started with a blank web database Under Available Templates, click Blank Web Database. Review the proposed file name in the File Name box, and the path for the database file, listed just below. To change the path, click the folder icon next to the File Name box to browse for a location to put your database file. Click Create.
What is a SharePoint App?
Organizations use SharePoint to create websites. You can use it as a secure place to store, organize, share, and access information from any device. All you need is a web browser, such as Microsoft Edge, Internet Explorer, Chrome, or Firefox. Want to learn more?