How do I open multiple tables in Access?

How do I View multiple tables in Access?

Answers. You can set the option for overlapping windows: File > Options > Current Database > Overlapping Windows. Or if you insist on tabbed style, you can run two instances of Access side-by-side.

How do I open all tables in Access?

Answer: To view all objects in the Navigation Pane, click on the Navigation Pane menu and select "All Access Objects" from the popup menu. Now the Navigation Pane should display all of the tables, queries, forms, reports, and modules that are in your database.

How do I open multiple windows in Access?

Display two windows at the same time by selecting Window » Tile Horizontally from the menu. One of the many benefits of working with Windows is that you can open and work with several windows at once.

Can you have more than one table in Access?

To create a multi-table query: Select the Query Design command from the Create tab on the Ribbon. In the dialog box that appears, select each table you want to include in your query and click Add. You can press and hold the Ctrl key on your keyboard to select more than one table.