« previous next »

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

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

In 1885, the Lloyd Manufacturing Company of Albany, New York, promoted and sold "Cocaine Toothache Drops" at 15 cents per bottle! In 1914, the Harrison Narcotic Act brought the sale and distribution of this drug under federal control.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Leaf structure and its relationship to the C4 cycle Leaf structure and its relationship to the C4 cycle
Relationship between body size and seed size in Galapagos finch species Relationship between body size and seed size in Galapagos finch species
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
This modified model of Easton’s systems theory puts government decision makers as the source of pol This modified model of Easton’s systems theory puts government decision makers as the source of pol
The relationship between the crankshaft position (CKP) sensor and the camshaft position (CMP) sensor ... The relationship between the crankshaft position (CKP) sensor and the camshaft position (CMP) sensor ...
E9-23 Prepare income statements Explain the difference in operating income E9-23 Prepare income statements Explain the difference in operating income
Video: EpiPen Animation (Part 1)

For a complete list of videos, visit our video library