MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams

Chapter 4. Creating and Managing Queries

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Access 2010 relate to using queries. Specifically, the following objectives are associated with this set of skills:

4.1 Construct Queries

4.2 Manage Source Tables and Relationships

4.3 Manipulate Fields

4.4 Calculate Totals

4.5 Generate Calculated Fields

You’ll learn how to create different types of queries in the first section of this chapter. As you’ll see, you can use queries to help maintain database records and to analyze data. For example, you can use a make-table or an append query to create archives of your records. With a select query, you can retrieve records that match specific criteria—for example, all orders ...