8-page bifold quick reference guide, one of several quick reference guides for Access 2010.

This topic focuses on creating and enhancing database queries. Topics include: how table relationships impact queries, designing queries, creating select queries, contextual tabs and working with query results. In addition, action queries are discussed: make table queries, append queries, delete queries, update queries and cross tab queries. Creating multi-table queries are explained along with how to use calculated expressions to enhance results and how to create parameter queries.

Product Features

• Part of a series of several quick reference guides for Microsoft Access 2010, each focusing on a set of specific and important topics.
• Learn how to create database queries using various methods. & save results for use in reports.
• Work with various query types such as select queries, delete queries and append queries.
• Work with multi-table queries based on 1-many, many-1 or many-many relationships.
• Add calculations and expressions to queries, then save queries to use in reports.