Question

Describe the relationship between different types of object in Microsoft access with the help of a diagram.​

Answer 1

Answer:

There are three types of table relationships in Access.

A one-to-many relationship. Let's use an order tracking database that includes a Customers table and an Orders table as an example. ...

A many-to-many relationship. Now let's look at the relationship between a Products table and an Orders table. ...

A one-to-one relationship.

Explanation:

Answer 2

Answer:

There are three types of relationships in Microsoft Access: one-to-many, many-to-many and one-to-one. Table relationships are used for various reasons such as informing query, form and report designs. Fortunately, MS Access makes it easy to create table relationships before you develop other database objects.