Click on the expand indicator next to the record
Double click on the record to expand it
Apply filter by command to display related records
All of above
Answer is Right!
Answer is Wrong!
The correct answer is D. All of above.
To display the related records from other tables in datasheet view, you can:
- Click on the expand indicator next to the record. This will open a subdatasheet that displays the related records.
- Double click on the record to expand it. This will also open a subdatasheet that displays the related records.
- Apply filter by command to display related records. This will filter the datasheet to only show the records that are related to the current record.
Here is a more detailed explanation of each option:
- Click on the expand indicator next to the record. The expand indicator is a small triangle that appears to the left of a record in datasheet view. When you click on the expand indicator, a subdatasheet will open that displays the related records.
- Double click on the record to expand it. Double clicking on a record in datasheet view will also open a subdatasheet that displays the related records.
- Apply filter by command to display related records. To apply a filter by command to display related records, follow these steps:
- On the Home tab, in the Sort & Filter group, click Filter.
- In the Filter menu, click Related Records.
- In the Related Records dialog box, select the tables that you want to display related records from, and then click OK.
I hope this helps! Let me know if you have any other questions.