« previous next »

Author Question: Explain how to create a relationship in Microsoft Access. Include an example. What will be an ... (Read 85 times)

karen

  • Hero Member
  • *****
  • Posts: 537
on: Jul 7, 2018
Explain how to create a relationship in Microsoft Access. Include an example.
 
  What will be an ideal response?

Question 2

RFM analysis analyzes and ranks customers based on ________.
 
  A) their purchasing patterns
  B) their income status
  C) their residential location.
  D) their age


fur

  • Sr. Member
  • ****
  • Posts: 309
Reply #1 on: Jul 7, 2018
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 of one table on top 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

A


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Leaf structure and its relationship to the C4 cycle Leaf structure and its relationship to the C4 cycle
Invasive species in Canada include (a) zebra mussels, Dreissena polymorpha, (b) sea lamprey, Petromy Invasive species in Canada include (a) zebra mussels, Dreissena polymorpha, (b) sea lamprey, Petromy
Establishing a caring and trusting relationship helps the client come to terms with a terminal illne Establishing a caring and trusting relationship helps the client come to terms with a terminal illne
Relationship of the conduction system to an ECG strip. Relationship of the conduction system to an ECG strip.
Many households today include young adults who have not moved out of their parents’ homes (or who ... Many households today include young adults who have not moved out of their parents’ homes (or who ...
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
Video: The Krebs Cycle Animation

For a complete list of videos, visit our video library