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.