Access 2010: Creating Queries - Maxwell School of ...

• Introduction to Relationships • Why Define Relationships? • Relationships in ER Diagram vs. Relationships in MS Access • Creating Relationships Between Tables → One -to -Ma ny Relationship (1:N) → Many -to -Many Relationship (M:N) • Creating a Field/Column that looks up or lists values in tables à Creating a field that looks up ... ................
................