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
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:
IT – Informatics & Communications Technology Complex (ICTC)
535 W. Michigan St.
Indianapolis, IN 46202
There are no upcoming dates for this event.