Course details

Joins, SQL, and Action Queries in Access 2010

Joins, SQL, and Action Queries in Access 2010

Target Audience
Expected Duration
Lesson Objectives
Course Number

Advanced query methods in Access 2010 make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2010 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries.

Target Audience
A broad range of business users

Expected Duration (hours)

Lesson Objectives

Joins, SQL, and Action Queries in Access 2010

  • create and edit joins in Access 2010 databases
  • creates a parameter query
  • modify data in existing tables
  • create a new table from data in other tables
  • delete data from an Access 2010 database
  • identify how to create a union queries
  • modify an object within a database using a data-definition query
  • access a hosted database with a view to running a pass-through query
  • remove duplicate records from a table using a subquery
  • specify a join in a query
  • use action queries to modify a database
  • create and refine queries using SQL
  • Course Number: