Introduction to Queries in Access 2010

A broad range of business users

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
60 minutes

Description
Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.

Objective

Creating Queries in Access 2010

  • recognize the basic characteristics of queries
  • create basic select queries
  • modify queries
  • use calculations to refine query data
  • apply grouping and calculating functions to query results
  • create crosstab queries
  • create unmatched queries
  • create find duplicates queries
  • create and modify a Select query
  • refine a query using groupings and calculations
  • create a Crosstab query
  • create a Find duplicates query

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.