Removing a Relationship
To delete a relationship, just click it in the Relationships window (the line between the tables turns bold to
that it is selected), and then press
Access asks for confirmation; click
and the relationship disappears.
If you delete relationships between tables, you are
how information in the tables can be combined in a query, form, or report. It is a good practice to design your tables so that they can be related. Re member that each table is supposed to hold a subset of the database information. If each table is set up correctly, it should have at least one other table in the database to which it can be
In this lesson, you learned how to create, edit, and delete relationships between tables. In the
lesson, you learn how to create forms using a wizard or from scratch.