7. Linked tables and relationships
The previous page has a picture showing two tables with related fields. These are depicted graphically as a line between them.
The line between the fields has a '1' on one side and the infinity sign on the other. In Access this indicates a 'one-to-many' relationship. This is described in more detail on the Entity Relationship Diagram mini-web.
A small relational database may only contain two tables whilst a large corporate database could contain hundreds of tables.
Challenge see if you can find out one extra fact on this topic that we haven't already told you
Click on this link: database diagrams
Copyright © www.teach-ict.com