Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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 skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!