SQL for Microsoft Access

by Cecelia L. Allison, Neal A. Berkowitz

SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code. Explore the relational database structure and the basics of SQL. Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously. Learn how to filter records and group data. Discover how to create parameter queries that prompt users for data. Test your knowledge and comprehension with the end-of-chapter quizzes and projects.

374 pages, Paperback

First published October 1, 2005

About the author

Cecelia L. Allison has a professional background as a software tester and technical specialist. She is currently a published author, freelance Web master, and an on-line professor.

She wrote and facilitates an on-line SQL course entitled Introduction to SQL that is offered on-line through hundreds of accredited colleges, universities, and other accredited educational facilities world wide. She also facilitates on-line technical courses for ITT Technical Institute and Park University.

Cecelia is the author of several database books. She holds a Bachelor of Science in Finance and a Master of Science in Computer Information Systems."