Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Office Access 2007. The following topics are covered: Setting and Removing a Primary Key, Setting Table/Query Relationships, Deleting Relationships, Hiding a Table, Setting a Single Field Index, Setting Multiple Field Indexes, Validating Data, Creating Expressions with Functions Creating Complex Select Queries, Creating Parameter Queries, Creating Queries Using Multiple Tables, Creating Statistical Queries, Creating Update Queries, Creating a Report Manually, Customizing Forms, Forms and Subforms, Creating a Subform in an Existing Form, Creating a New Form with a Subform. Using Subdatasheets: Inserting, Expanding & Collapsing, Removing, Merging Data with a Word Document, Importing Data into Access, Export Data from Access, Saving Import/Export Steps and Viewing Object Dependencies. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. This guide is one of two available titles for Access 2010: Access 2010 Introduction and Access 2010 Intermediate.