<

MS Access – Working with Relationships

Posted on
6,924 Points
424 Views
5 Endorsements
Last Modified:
Experience Level: Beginner
5:19
Jim Dettman (Microsoft MVP/ EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.

Video Steps

1. Add the tables

2. Create the relationship

3. Decide if you’re going to set referential integrity

4. Decide if you want cascade updates

5. Decide if you want cascade deletes

6. Save the relationship

7. Save the relationship window layout

5
Comment
0 Comments

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month