Joins, SQL, and Action Queries in Access 2010

Overview/Description
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)
1.0

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