Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
• Click the Cascade Update Related
Fields check box (Figure 3–70).
The Cascade check boxes were
dim until I clicked the Enforce
Referential Integrity check box. Is
Yes. Until you have chosen to
enforce referential integrity, the
cascade options have no meaning.
ﬁ elds used to
Can I change the join type like I
can in queries?
Yes. Click the Join Type button in
the Edit Relationships dialog box.
Just as with queries, option
button 1 creates an INNER join,
option button 2 creates a LEFT
join, and option button 3 creates a
Join Type button
• Click the Create button to
complete the creation of the
relationship (Figure 3–71).
What is the symbol at the lower
end of the join line?
It is the mathematical symbol
for inﬁ nity. It is used here to
denote the “many” end of the
“one” part of
Can I print a copy of the
Yes. Click the Relationship Report
button on the Design tab to
produce a report of the relationship.
You can print the report. You also
can save it as a report in the
database for future use. If you do not
want to save it, close the report
after you have printed it and do
not save the changes.
is related to
“many” part of