Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access training - referential integrity

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Referential integrity

microsoft access training - Referential integrity

ResolvedVersion Standard

Nigel has attended:
Access Intermediate course
Access Advanced course

Referential integrity

Where you have two existing tables both already populated with data, if you then select referential integrity between a foreign and primary key on each table, will Access validate the two table ensuring that referential integrity exists?

i.e. would tou receive an error message if there is a record on one table which breaches the referential integrity rule you are trying to create.

RE: Referential integrity

The answer is yes, Access should validate the relationship.
A suggestion is to make a copy of your database, and then test this to see exactly what your result will be.

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.