Access 2016 Intermediate

Lesson 2 – Modifying Tables

Access 2010

10. Close the Payment table, saving the changes. 11. Open the Relationships window and add the Client , Project , and Trainer tables. 12. Create a join between the Client and Project tables on the Client ID field; enforce referential integrity. 13. Create a second join between the Trainer Initials and Initials fields in the Project and Trainer tables respectively; enforce referential integrity. 14. Close the Relationships window, saving the changes. 15. Close the database file.

Page 50

OFFICEPRO, Inc.