Question: how to change relationship type in ms 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.