Access: Analyzing and Modifying Data with Queries

Learning Objectives

  • Build relational queries and modify query properties
  • Perform mathematical and text operations in a query
  • Create parameter queries that allow you to supply criteria when run
  • Summarize data using groups, calculated expressions, and aggregate totals
  • Create Crosstab queries to summarize data
  • Create and run Action queries to create, modify, and delete data
  • Use Find Duplicates and Find Unmatched queries to locate data

Prerequisite Skills

  • Understand database relationships
  • Create one-to-many relationships
  • Create simple relational 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.