Explain how to create a relationship in Microsoft Access. What ...

[folubunmi]

Explain how to create a relationship in Microsoft Access.
 
  What will be an ideal response?

Question 2

Microsoft Access 2013 can secure database files by storing them in a(n) ________.
 
  Fill in the blank(s) with correct word

[ciecieme]

Answer to Question 1

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.

Answer to Question 2

trusted location

[folubunmi]

Thanks for the timely response, appreciate it

[Perkypinki]

Excellent