<

MS Access – Working with Relationships

Posted on
6,954 Points
454 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

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month