Relational Databases and Microsoft Access 10 1 RELATIONAL DATABASES AND MS ACCESS A database is an organized collection of data. A database may be on paper, or held in computer files such as spreadsheets or more formally in a software system known as a computerized database management system (for example: DB2, db4o, IMS, MS Access, MS SQL Server,. Microsoft Access Cross-Reference Diagrams. Total Access Analyzer generates cross-reference information that shows where and how each object is referenced.. Application Flow Diagram shows procedure and event flow for the entire database ; Data Diagram shows how data flows from tables into queries, forms, reports, etc. Object Diagram shows.
A string expression that's the valid name of a database diagram in the current database. If you execute Visual Basic code containing the OpenDiagram method in a library database, Microsoft Access looks for the database diagram with this name first in the library database, and then in the current database.. An entity relationship diagram (ERD) helps database designers review and verify links between tables in a database. An ERD shows a visual representation of primary and foreign keys, which are the columns used to link tables. Microsoft Access includes a diagram utility that lets you create and view an ERD for your Access database.