Create a database diagram (ADP)

 Note   The information in this topic applies only to a Microsoft Access project (.adp).

You can use a database diagram to create, edit, or delete database tables. You can also use a database diagram to see how your tables relate to each other. When you create a new database diagram, you are presented with a blank diagram surface to work on.

  1. In the Database window, click Database Diagrams Button image under Objects, and choose the New button on the Database window toolbar.

A blank database diagram appears with the Add Table dialog box.

  1. To add a table to the database diagram, select a table, and then click Add.


To create a new table in the diagram, right-click anywhere inside the database diagram and then choosing New Table from the shortcut menu.

  1. Arrange the objects in your database diagram.

If you want to move objects to different parts of your diagram — for example, to align the tables or reduce the number of overlapping relationship lines — first select the objects, and then drag the selection to its new location.

  • To select a table, click its title bar.
  • To select a set of tables, hold down the CTRL key as you click inside the title bar of each table in the set.
  • To select a set of tables grouped together, position the pointer near one of the tables and then drag a rectangle around all the tables in the set.

If you select multiple tables, the relationship lines that connect them are automatically included in the selection.

If you select a relationship line, you can slide a line segment to a location that is parallel to its original position. If the relationship line has more than one segment, you can drag a corner diagonally to change both its vertical and horizontal position.

Applies to:
Access 2003