Contents
How do I create a relational database in Access 2010?
How to Design a Relational Database in Access 2010
- Identify your data.
- Eliminate redundant fields.
- Organize the fields into tables.
- Add tables for codes and abbreviations.
- Choose a primary key for each table.
- Link the tables.
It is not a relational database. Each list is independent and SharePoint lists were never intended to be used as a relational database. While SharePoint does have a field type called Lookup, it does not serve as a true relational database.
How to create a database in SharePoint access?
Access 2010 and Access Services provide a platform for you to create databases that you can use on a SharePoint site. You design and publish a web database by using Access 2010 and Access Services, and people who have accounts on the SharePoint site use the web database in a web browser.
Is there a relational data model in SharePoint?
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. Wow, that’s some type of crazy!
Is it possible to create a relational database?
Its solution of having a Repeating Section with data bound in XML, means making relational data models are just not possible. That’s where the TekDog Productivity Controls for Nintex Forms can take over. Our form controls allow for you to create parent-child relationships using native SharePoint lists.
When you publish a web database, Access Services creates a SharePoint site that contains the database. All of the database objects and data move to SharePoint lists in that site. The following video shows the process. After you publish, SharePoint visitors can use your database, based on their permissions for the SharePoint site.