« previous next »

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

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

Schematic relationship between a phylogenetic tree and taxonomy. Schematic relationship between a phylogenetic tree and taxonomy.
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
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
a Hyenas and other scavengers may have competed with early hominins for access to carcasses. a Hyenas and other scavengers may have competed with early hominins for access to carcasses.
Relationship of the electrocardiogram to electrical conduction in the heart. Relationship of the electrocardiogram to electrical conduction in the heart.
Rocking the leg to create rotation in the hip joint. Rocking the leg to create rotation in the hip joint.
Video: Predator- prey competition and symbiosis

For a complete list of videos, visit our video library