Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship command
Answer: D) Tools Menu
In older versions of Microsoft Access (Access 2003 and earlier), the Relationships command was available under the Tools menu.
It is used to create relationships between database tables and enforce Referential Integrity, ensuring that related records remain consistent.
For example, a Customers table can be linked to an Orders table using a common Customer ID.
In newer versions of Microsoft Access (2007 and later), the menu interface was replaced by the Ribbon. The Relationships command is available under the Database Tools tab.
पुरानो Microsoft Access (Access 2003 तथा त्यसभन्दा अघिका Version) मा दुई वा दुईभन्दा बढी Database Tables बीच Relationship बनाउन प्रयोग गरिने Relationships Command, Tools Menu अन्तर्गत पाइन्थ्यो।
यसले Tables बीच सम्बन्ध स्थापित गरी Referential Integrity कायम राख्न मद्दत गर्छ।
उदाहरणका लागि, Customers Table र Orders Table लाई साझा Customer ID मार्फत जोड्न सकिन्छ।
नयाँ Microsoft Access Version (2007 वा पछिका) मा भने यो सुविधा Database Tools Tab अन्तर्गत पाइन्छ।
Exam Tip:
- Access 2003 and earlier: Tools → Relationships
- Access 2007 and later: Database Tools → Relationships
त्यसैले दिइएका विकल्पमध्ये सही उत्तर D. Tools Menu हो।