Access 2010: Building Relationships Among Database Tables

One of the advantages of Relational Database Management System such as Access 2010is to easily setup tables and relationships with constraints to make them more tightly followed. One feature is being the ability to create and maintain relationships between tables.

Access will open Relationships tab with Show Table Dialog box. Select tables, queries or both, and hit Add.

You will see selected tables/queries small windows with columns names in Relationships window. Now sit back start pondering over the selected tables to relate them properly. In this example I am using only four tables (AddictiveTips Example, Courses, Lecturer, Mark Sheet).

I am now creating one-many-relationship between AddictiveTips Example (Student) and Courses table. Click & hold the primary key of AddictiveTips Example, drag it and drop over course name insmall window of Courses. Immediately Edit Relationships dialog window will pop-up. Here you can create new relationship between tables, Specify Join Type, and Enforce Referential Integrity. For demonstration purpose, I am going to ignore all options and hit Create.

You will see one-many relationship created between AddictiveTips Example’s ID and course code.

Thanks for the post. Here’s a tutorial that shows how you can easily build an online database-driven web application with a parent-child table relationship, without codinghttp://blog.caspio.com/web-database/creating-one-to-many-relational-datapages/

them

this document was very useful

frank

But how table relationship could be established in web database in Access 2010? Once you start a web database, the relationship control is gone and the icon of relationship becomes not active.

Topics

Authors

Daily articles in your inbox each day for free

About Addictivetips

AddictiveTips is a tech blog focused on helping users find simple solutions to their everyday problems. We review the best desktop, mobile and web apps and services out there, in addition to useful tips and guides for Windows, Mac, Linux, Android, iOS and Windows Phone. Read more...