How to Use Join Property in MS Access In this How To, I will demonstrate how MS Access uses the Join property with an example of each type of join. Since MS Access database is a relational database by linking one table to another. As you can see in the picture, the ID field in an Employee table is linking to an Employee ID field in the Orders table with a relationship of One-To-Many. If the Enforce Referential Integrity is checked in the Edit Relationships window, the relationship line is…
Read MoreHow to Use Join Property in MS Access
