Access: Stucturing and Relating Data

Learning Objectives

  • Explore various types of relationships and create relationships between tables
  • Understand how referential integrity rules work
  • Build relational queries exploring different join types
  • Create lookup fields
  • 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

Prerequisite Skills

  • Understand the basic features of Access
  • Create simple tables
  • Enter and edit data in tables
  • Create simple queries

Materials and Files

Canvas course for this title is coming soon.

Find related training with our partners

Pluralsight

Pluralsight is a provider of video-based online training with a focus on more technically oriented and design focused topics.

More information

Log in now (subscribers only)

Skillsoft

Skillsoft is a leading e-learning provider with a wide range of educational services and in-depth coverage of IT and other skills.

More information

Log in now (subscribers only)

Contact us to request IT Training resources in other accessible formats.