Microsoft Office Tutorials and References
In Depth Information
Referential Integrity
AC 191
2
Click the plus sign in front of the
row for Recruiter 24 to display the
subdatasheet (Figure 3–75).
How do I hide the subdatasheet
when I no longer want it
to appear?
When you clicked the plus sign, it
changed to a minus sign. Click the
minus sign.
+ sign changed
to - sign
subdatasheet
for recruiter 24
I
click to hide
subdatasheet
Experiment
Display subdatasheets for other
recruiters. Display more than one
subdatasheet at a time. Remove
the subdatasheets from the screen.
Figure 3–75
3
Close the datasheet for the Recruiter table.
T O F IND D UPLICATE R ECORDS
One reason to include a primary key for a table is to eliminate duplicate records. A
possibility still exists, however, that duplicate records can get into your database. Perhaps
the same client was inadvertently added to the database with a new client number. You
can detect this type of redundancy by searching to see if any client’s names are duplicated.
The Find Duplicates Query Wizard allows you to fi nd duplicate records. The following
steps illustrate how to use the Find Duplicates Query Wizard to fi nd duplicate records.
1. Click Create on the Ribbon, and then click the Query Wizard button on the Create tab.
2. When Access displays the New Query dialog box, click the Find Duplicates Query
Wizard and then click the OK button.
3. Identify the table and fi eld or fi elds that might contain duplicate information.
4. Indicate any other fi elds you want displayed.
5. Finish the wizard to see any duplicate records.
T O F IND U NMATCHED R ECORDS
Occasionally, you may want to fi nd records in one table that have no matching records
in another table. For example, you may want to determine which recruiters currently have
no clients. The Find Unmatched Query Wizard allows you to fi nd unmatched records.
The following steps illustrate how to fi nd unmatched records using the Find Unmatched
Query Wizard.
1. Click Create on the Ribbon, and then click the Query Wizard button on the Create tab.
2. When Access displays the New Query dialog box, click the Find Unmatched Query
Wizard and then click the OK button.
3. Identify the table that may contain unmatched records and then identify the related table.
4. Indicate the fi elds you want displayed.
5. Finish the wizard to see any duplicate records.
Search JabSto ::




Custom Search