« previous next »

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

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

Desert shrubs create distinctive thermal microclimates in the desert landscape Desert shrubs create distinctive thermal microclimates in the desert landscape
Relationship of the 12 cranial nerves to specific regions of the brain. Relationship of the 12 cranial nerves to specific regions of the brain.
Tracheostomy. A tracheotomy, or incision into the trachea, is performed to create an opening into th Tracheostomy. A tracheotomy, or incision into the trachea, is performed to create an opening into th
Remedies for insomnia include increased physical exercise and time spent outdoors. Remedies for insomnia include increased physical exercise and time spent outdoors.
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 ...
Relationship between the pancreas and the digestive system. Relationship between the pancreas and the digestive system.
Video: Mycobacterium tuberculosis: Drug Resistance and Natural Selection

For a complete list of videos, visit our video library