database
implementation in access
creating the relationship
For the tables to interact they need to be related. I have already designed the type of relationship using an entity relationship diagram earlier so all I need to do now is implement the design in Access.
Firstly I closed down all the entities. If any are active you are unable to make any changes to the relationship. I then clicked on 'Tools' in the main menu and selected the option called 'Relationships'. The following window called 'Show Table' opened:
I then highlighted 'CD' and 'Order and clicked the 'Add' button. I then pressed the 'Close' button and was shown the relationship interface, here I can make significant changes to the relationship between the two entities. Currently there is no relationship between them as shown below:
To create the relationship I clicked on the CD entity's primary key and drag it over to its duplicate in the Order entity. A new window appeared called 'Edit Relationships', it is shown below:
I made sure that the 'Enforce Referential Integrity' box was checked and continued to create the relationship. This then updated the relationships interface with the new relationship. This is shown below:
This ends the implementation process.
Click next to continue...