How do I add a second table in access?

How do you create a second table in access?

How to Create a Table in Access1Click the Create tab.2Click Table. ... 3Click the Click to Add field heading. ... 4Select the field type. ... 5Type a name for the field. ... 6Repeat Steps 3-5 to add the remaining fields to your table.7When you're finished adding fields, click the Close button and click Yes to save your changes.Create a Table - Access Training - CustomGuide

How do you add a new table to an existing table in access?

On the Design tab, in the Query Type group, click Make Table. The Make Table dialog box appears. In the Table Name box, enter a name for the new table. Click the down-arrow and select an existing table name.

How do you join two Tables in Access?

First, create a new query and add all 3 tables to the query. Right click on the "join line" between the Employees table and the Orders Table and select "Properties" from the popup menu. When the Join Properties window appears, select the second option and click on the OK button.