How to Create a Graphic Microsoft Access Database Schematic
- 1). Open the database to be diagrammed in Microsoft Access.
- 2). Click the “Database Diagrams” button. This button appears to have a picture of several linked tables.
- 3). Click “New” from the toolbar. A blank diagram page will appear with the “Add Tables” button.
- 4). Click “Add Tables.”
- 5). Click the title bar for each table to add. Hold the CRTL key and click on each table’s title to select multiple tables.
- 6). Right-click in the diagram page and click “New Table” to create a new table from within the diagram interface.
- 7). Drag and drop the tables to convey relationships between tables and variables. Relationships between the tables are defined in the database and the relationship lines automatically link the appropriate variables and tables. To group a set of tables, move the tables close together and then drag a rectangle around all of the tables.
Source...