« previous next »

Author Question: Explain the procedure for establishing a relationship between two tables in Microsoft Access. ... (Read 32 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 liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Photograph taken during a laparoscopic procedure. The fundus of the uterus is visible below the prob Photograph taken during a laparoscopic procedure. The fundus of the uterus is visible below the prob
Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ... Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ...
A relationship between folate and B12 metabolism A relationship between folate and B12 metabolism
Exploring Microsoft Office 2010, Volume 1 (2nd Edition) 2nd Edition Exploring Microsoft Office 2010, Volume 1 (2nd Edition) 2nd Edition
The relationship between the number of stem cell divisions in the lifetime of a given tissue and the The relationship between the number of stem cell divisions in the lifetime of a given tissue and the
Relationship Between the Atlas and the Axis. The Dens of the Axis Provides a Pivotal Point Around Wh Relationship Between the Atlas and the Axis. The Dens of the Axis Provides a Pivotal Point Around Wh
Video: Exercise and cardiac output

For a complete list of videos, visit our video library