SQL for Microsoft Access

SQL for Microsoft Access

by Cecelia L. Allison, Neal A. Berkowitz
     
 

View All Available Formats & Editions

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

Overview

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.

Product Details

ISBN-13:
9781449627119
Publisher:
Jones & Bartlett Learning
Publication date:
10/22/2010
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
374
Sales rank:
683,676
File size:
9 MB

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >