Creating+Relationships+In+Access

= Creating Relationships In Access = READ THIS IF YOU NEED HELP WITH YOUR ACCESS HOMEWORK! It will help you greatly!

Relational databases support a number of different types of relationships between tables; these relationships are designed like **references** between **excel tables**. __Access supports 3 different types of relationships between tables:__


 * 1) **One-to-one relationships** occur when there is exactly one record in TableA that corresponds to exactly one record in TableB.
 * 2) **One-to-many relationships** occur when each record in TableA may have many linked records in TableB but each record in TableB may have only one corresponding record in TableA.
 * 3) **Many-to-many relationships** occur when each record in TableA may have many linked records in TableB and vice-versa.

To create a one-to-many relationship



 * These instructions can be found** here!
 * 1) =====Select the ** Relationships **item from the Tools menu.=====


 * 1) =====We want to work with all **(x number of)tables** in our database (eventually), so highlight all **(x number of)tables** and click the ** Add ** button.=====


 * 1) =====Click the ** Close **button and you’ll be presented with a database diagram showing the database’s four tables=====

Once you’ve created the diagram, it’s time to start building relationships! Here’s the process for our Customers/Orders relationship:

 * 1) =====Click on the ** CustomerID **field in the Customers table and, while holding the mouse button down, **drag** the pointer to the CustomerID field in the Orders table and release the mouse button.=====


 * 1) =====** Verify **that the two fields listed in the Edit Relationships pop-up window are correct. They should point to the CustomerID fields of the Customers and Orders tables.=====


 * 1) =====Check the ** Enforce Referential Integrity ** and Cascade Update Related Fields boxes in the Edit Relationships window and click the **Create** button=====


 * 1) =====You’ll see the link between tables appear in the diagram, with the numeral 1 next to the Customers table and the infinity symbol next to the Orders table, symbolizing a one-to-many relationship (the default for Access).=====

YOU'RE DONE!!!!! =)
You can repeat this process with all of the tables that you need to make relationships between!

=FOR TIPS on how to design access databases for access, please click here! = =This link goes to a certified Microsoft page which is incredibly helpful, you should really check it out!=

Hope I helped you with your access homework!!


 * Thanks for looking at my WIKI!! **

= Chynna = = = = = = = = = = = = Also, here is a video that may be able to help you with creating relationships- Bailey Martinez = = = = media type="youtube" key="OGZTseZNJQk" height="344" width="425" =