Microsoft Access 2007 Quick Reference Guide: 203 - Designing & Enhancing Data Queries

This is an 8-page bifold quick reference guide which is one of 5 Microsoft Access guides. 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.