« previous next »

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

Mimi

  • Hero Member
  • *****
  • Posts: 542
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Structure of the ovary and uterine (fallopian) tube. Figure illustrates stages of ovum development a Structure of the ovary and uterine (fallopian) tube. Figure illustrates stages of ovum development a
Injecting an IV push (bolus) medication; C, another type of needleless syringe and needleless IV acc Injecting an IV push (bolus) medication; C, another type of needleless syringe and needleless IV acc
Relationship of the lymphatic system to the cardiovascular system. Relationship of the lymphatic system to the cardiovascular system.
A Classical Conditioning Procedure Outside the Laboratory A Classical Conditioning Procedure Outside the Laboratory
Infant and Toddler Development and Responsive Program Planning: A Relationship-Based Approach Infant and Toddler Development and Responsive Program Planning: A Relationship-Based Approach
The relationship between the Golgi complex and lysosomes The relationship between the Golgi complex and lysosomes
Video: Uterine (menstrual) cycle - phases

For a complete list of videos, visit our video library