Productivity & Collaboration Tools     Microsoft Office 2010     Access 2010     Microsoft Office 2010: Advanced Access

---

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.

---

---

Objectives

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