Q: Which two of the following types of relations can only be created on numeric fields?  

Answer: D

Justification:

1. A normal relation can be created on any field type.
2. A field fixed relation can only be created on a numeric field. A numerical value must be entered for the Value property of the selected field to act as a filter.
3. A related field fixed relation can also only be created on a numeric field. A numerical value must be entered for the Value property of the selected field to act as a filter.
4. A Foreign Key Relation specifies correspondence between a foreign key field in the present table and the primary key field in another parent table. It is not restricted to numerical field types.

 

Related Lesson: Relations

Click me to Read more Question & Answer of Module 8: Table Relations

---

Share this MCQ