<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

MS Access – Working with Relationships

Posted on
6,957 Points
457 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
0 Comments

Featured Post

Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

This following write-up describes a different way to copy Lotus Notes Calendar to Outlook. Along with this, we will also learn the reason behind this NSF to PST migration. Users can prefer different procedures as per their convenience.
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.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month