The Add Tables task pane

The Add Tables task pane (which stays open while you work) replaces the modal Show Tables dialog box in Query Design View and the Relationships window. You can do the following:

Tabs    Select one of four tabs (Tables, Links, Queries, All).

Tabs on the top of the Add Tables task pane

Search    Use a Search box to further filter the list.

The Search box for the Add Tablest Task pane

Multi-select    Select multiple items:

  • Press and hold Shift, and then select multiple contiguous items.

  • Press and hold CTRL, and then select multiple noncontiguous items.

Drag items   Drag selected items from the task pane to the upper section of the Query Designer or the Relationships window.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.