<

MS Access – Working with Relationships

Posted on
6,961 Points
461 Views
5 Endorsements
Last Modified:
Experience Level: Beginner
5:19
Jim Dettman (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
0 Comments

Featured Post

Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Migrating data tables from MS Access to SQL Server is not for faint-hearted people, you have to draw all your programming knowledge to a higher assumed expertise level. Be prepared to sort out programming issues at a higher level.
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order. But how to rank dupes? Five methods exist, and th…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month