« previous next »

Author Question: Explain how to create a relationship in Microsoft Access. Include an example. What will be an ... (Read 74 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?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Organisms exhibit a diversity of behaviours, which include (clockwise from upper left), foraging and Organisms exhibit a diversity of behaviours, which include (clockwise from upper left), foraging and
The Secondary Mirror Does Not Create a Hole in the Image The Secondary Mirror Does Not Create a Hole in the Image
A pharmacist can explain to a patient why medication may look different and ensure the correct ... A pharmacist can explain to a patient why medication may look different and ensure the correct ...
Five Factors of Personality and the Traits they Include Five Factors of Personality and the Traits they Include
Relationship between blood and lymph capillaries. Relationship between blood and lymph capillaries.
The insulin receptor and its structural relationship to other transmembrane receptors with protein The insulin receptor and its structural relationship to other transmembrane receptors with protein
Video: Glycolysis Animation

For a complete list of videos, visit our video library