Relationships are the fundamental building blocks of complex databases and are critical to designing and working with sophisticated databases. This workshop is intended for participants who are familiar with the basic features of Access but are interested in learning how to define relationships in a relational database and how to create relational forms and queries. Multivalued fields and lookup fields will be introduced.

(Description continued below)

Participants will:

• explore various types of relationships and define relationships between tables
• explore how relationships are structured and understand referential integrity rules
• build relational queries and explore how join properties work
• create and work with multivalued fields and lookup fields
• build relational forms
• create a lookup table from a query
• export data into Microsoft Excel

The following workshops are suggested prerequisites to this workshop:

• Access: The Basics

Participants should already be able to:

• understand the basic features of Access
• create simple tables
• enter and edit data in tables
• create simple queries