This book unlocks the power of Structured Query Language in Microsoft Access. It guides the reader through step-by=step realistic examples of creating databases in Microsoft Access, using SQL script to create table, adding records to tables and retrieving and managing records.

SQL for Microsoft Access

Computers & Technology

Allison, Cecelia L.

Programming Languages

Wordware Publishing, Inc.

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.

SQL for Microsoft Access (Wordware Applications Library)

Berkowitz, Neal A.

Computer Science

Jones& Bartlett Learning

See the best price to sell, buy, or rent books by Allison, Cecelia L.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Allison, Cecelia L.