Author Question: Explain the procedure for establishing a relationship between two tables in Microsoft Access. ... (Read 90 times)

Mimi

  • Hero Member
  • *****
  • Posts: 542
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

  • Sr. Member
  • ****
  • Posts: 336
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

For a complete list of videos, visit our video library