To create relationship between two tables
Answer: A) drag the primary key of a table into foreign key of another table
In Microsoft Access, a relationship between two tables is commonly created by dragging the Primary Key field from the parent table and dropping it onto the corresponding Foreign Key field in the child table.
This establishes a link between the two tables and allows you to enforce Referential Integrity.
Example:
Suppose we have two tables:
- Customers Table: CustomerID (Primary Key)
- Orders Table: CustomerID (Foreign Key)
Drag CustomerID from the Customers table and drop it onto CustomerID in the Orders table.
This creates a One-to-Many relationship because one customer can have multiple orders.
Microsoft Access मा दुईवटा Tables बीच Relationship बनाउन सामान्यतया Parent Table को Primary Key लाई Child Table को सम्बन्धित Foreign Key मा Drag गरेर Drop गरिन्छ।
यसरी दुई Tables बीच सम्बन्ध स्थापित हुन्छ र आवश्यक परेमा Referential Integrity पनि लागू गर्न सकिन्छ।
उदाहरण:
- Customers Table: CustomerID (Primary Key)
- Orders Table: CustomerID (Foreign Key)
Customers Table को CustomerID लाई Orders Table को CustomerID मा Drag गरेर Drop गर्दा दुईवटा Tables बीच Relationship सिर्जना हुन्छ।
यसले One-to-Many Relationship बनाउँछ।
Exam Tip: Primary Key → Foreign Key (Parent Table → Child Table)।
त्यसैले सही उत्तर A हो।