Desktop Certifications     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2010     77-885: Microsoft Office Access 2010

---

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.

---

---

Objectives

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