<

Go Premium for a chance to win a PS4. Enter to Win

x

MS Access – Working with Relationships

Posted on
6,893 Points
393 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Join & Write a Comment

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month