Make a new query. Put only table1 in it. Put whatever field corresponds to that series of data from the first column in the design matrix. Under criteria, type something like this: Like (In (SELECT table2ID FROM Table2)) & "*". Here table2ID represents whatever the name of your field is in table2 that has the second column of data that you gave. Good luck!
Create a new select query in design mode, but don't add any tables to it. Then switch to SQL View and paste the folowing in, replacing the table names and field names with your specific table and field names if different:
FROM Table1, Table2
WHERE (((Table1.Field1) Like [Table2]![Field1] & "*"))
ORDER BY Table1.Field1;