MS Access : Computer Awareness Questions & Answers
Question : In MS Access, how can we create relationship between two tables in the GUI ?
A.
Drag the foreign key of a table into the primary key of another table
B.
Drag any field from parent table and drop on child table
C.
Drag the primary key of a table into foreign key of another table
D.
Any of these can be done to create relationship
Correct Answer is : Option C.
- Which of the following storecommandto gather data from database?
- A search value in SQL query can be a specific value or it can be ________
- What is the default and maximum size of text field in MS Access?
- How can we remove a relationship defined between two tables ?
- Which field type will you select if you need to enter long text in that field?