MS Access Join Two Tables Software offers a solution for users who want to join MS Access tables horizontally or vertically. The horizontal joins occur by lining up two tables by a common column of data. In addition, vertical joins append two tables up and down as long as the tables are similar (data types and number of records are the same). The tables can be located in the same or different Access files. For your protection, the two tables are not changed. Instead an entirely new table is created with the result of the join.