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.