Joins, SQL, and Action Queries in Access 2010

A broad range of business users

Please contact us for information about prerequisites.

Expected Duration
60 minutes

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.


Creating Joins, SQL, and Action Queries

  • 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




    Multi-license discounts available for Annual and Monthly subscriptions.