Question: how to change the relationship type in access?
Answer: On the Database Tools tab, in the Relationships group, click Relationships. On the Design tab, in the Relationships group, click All Relationships. ...  Click the relationship line for the relationship that you want to change. ...  Double-click the relationship line. ...  Click Join Type.