IUPUI

This workshop lasts 3.5 hours, and is part of the certificate series Access 2010 End-User

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 relational databases and how to create relational queries and forms. Creating multivalued and lookup fields will be introduced. Challenge exercises will help reinforce concepts.

    What You'll learn Available Downloads

• explore various types of relationships and create relationships between tables

• understand how referential integrity rules work

• build relational queries exploring different join types

• create multivalued and lookup fields

• export a query to Microsoft Excel

• create a relational form

• import columns of data from an Excel workbook into an Access table

• explore the options for cascade update related fields and cascade delete related records

• Workshop Materials (PDF)

• Exercise Files (Win) (ZIP)

What you need to know

• understand the basic features of Access

• create simple tables

• enter and edit data in tables

• create simple queries

If you don't have those skills, consider first taking the workshop:

• Access 2010: The Basics