This topic contains a solution. Click here to go to the answer

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

folubunmi

  • Hero Member
  • *****
  • Posts: 524
Explain how to create a relationship in Microsoft Access.
 
  What will be an ideal response?

Question 2

Microsoft Access 2013 can secure database files by storing them in a(n) ________.
 
  Fill in the blank(s) with correct word



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ciecieme

  • Sr. Member
  • ****
  • Posts: 331
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 key of one table 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

trusted location




folubunmi

  • Member
  • Posts: 524
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it


carlsona147

  • Member
  • Posts: 341
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

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.

For a complete list of videos, visit our video library