Explain how to create a relationship in Microsoft Access
What will be an ideal response?
In Microsoft Access, relationships are created in the Relationships window, which is opened by using the Relationships button on the Database Tools command tab. Once the Relationships window is open, the needed database tables are displayed using the Show Table dialog box. A relationship is initiated by dragging the primary key of one table and dropping it on top of the corresponding foreign key in the related table. At this point the Edit Relationships dialog box is displayed. A referential integrity constraint can be set in this box by checking the Enforce Referential Integrity check box. The relationship is actually created by clicking the Create button in the Edit Relationship dialog box.
You might also like to view...
Identify the interjection in the sentence. The car Mom and Dad gave her runs perfectly? Great!
One important ____ of accounting is that personal assets must be kept separate from business assets
A) principal B) principle
The Paris Convention guarantees that in signatory countries national treatment will be granted to foreign applications for:
a. trademarks. b. copyrights. c. patents. d. Both a and c
The warranty of habitability benefits only the original purchaser of a house
Indicate whether the statement is true or false