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.
- In the Database window, click Database Diagrams
under Objects, and choose the New button on the Database window toolbar.
A blank database diagram appears with the Add Table dialog box.
- To add a table to the database diagram, select a table, and then click Add.
-or-
To create a new table in the diagram, right-click anywhere inside the database diagram and then choosing New Table from the shortcut menu.
- 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.