Explain the procedure for establishing a relationship between two ...

[Mimi]

Explain the procedure for establishing a relationship between two tables in Microsoft Access.
 
  What will be an ideal response?

Question 2

A help-desk information system has answers to questions that only a true user of an account or system would know.
 
  Indicate whether the statement is true or false

[robbielu01]

Answer to Question 1

After creating tables in Microsoft Access, the next step is to define relationships. This can be done by clicking the Database Tools tab in the ribbon and then clicking the Relationships icon near the left-hand side of that ribbon. The Relationships window will open and the Show Table dialog box will be displayed. Double-clicking on table names will add those tables to the Relationships window. Close the Show Table dialog box.
To create a relationship between one row of the first table and an unlimited number of rows in the second table, click on the primary key attribute in the first table and drag that attribute on top of the foreign key in the second table. In the dialog box, click Enforce Referential Integrity, then Cascade Update Related Fields, and then Cascade Delete Related Records. Close the Relationships window and save the changes when requested to do so. The database now has two tables and a relationship.

Answer to Question 2

TRUE