Can I create relationships between more than one table in microsoft access?
Relationships between tables are important because they allow the entities to be connected based on certain common fields. Create another table using the wizard; Press “Relationships ” button and choose “The tables aren’t related” radio button, then “OK.” Finally, click “Finish.” Close the new table that is presented in data sheet form, and click on “Relationships” in the “Tools” menu. This is the screen that is used to construct and edit relationships between tables. If both tables are not present, right click on the empty relationships and choose “Show Table.” Highlight both tables in the list, and then press “Add.” This adds tables to the workspace so the relationships may be altered or created. Now press “Close” to clear the add table window. Click on the StudentID field in the first table created with the Students sample, and then drag it onto the StudentID field in the second table. A window will appear allowing you to change the relationship type. Add a checkmark to the box labe
